How-to

How to import a spreadsheet into your CRM

Bring your existing rows into Chaudie. Every row is checked against your CRM's rules before it lands, and a whole import can be undone.

Before you start

You need to be one of your CRM's admins. Save your sheet as a CSV first: in Excel, File then Save As then CSV; in Google Sheets, File then Download then CSV.

  1. 1

    Open Import a spreadsheet

    Open your CRM, then your account menu in the corner, then Company Studio. Studio is for your CRM's admins. Choose the Import a spreadsheet tile.

  2. 2

    Choose the module

    Under Which Module, pick where the rows should go, for example your customers.

  3. 3

    Add the file

    Under The file, choose your CSV. Chaudie reads its columns.

  4. 4

    Match the columns

    Under Match the columns, each column in your file is paired with a field. Change any pairing that's wrong, or choose Ignore this column for anything you don't want brought in.

  5. 5

    Tell it how dates are written

    If your file has dates like 09/10/2026, say whether that's September 10 or 9 October, so every date lands on the right day.

  6. 6

    Fix the rows that need a look

    Rows that break a rule (a missing required field, a value that isn't allowed) are listed under Rows that need a look, with the reason. Type a Corrected value, or Skip this row.

  7. 7

    Import, and undo if you need to

    Finish the import. It appears under Past imports, where Undo removes everything that import brought in.

Tips

  • Import one tab at a time: each usually belongs in its own module.
  • Import the records others point to first (customers before their jobs), so links between them can be matched.
  • Formulas come in as their values. Chaudie works out its own totals from the records.

Questions

Can I import Excel files directly?+

Save them as CSV first. Excel and Google Sheets both can, from their File menu.

What happens to rows with mistakes?+

They're held back and shown with the reason, so you can correct or skip each one. Nothing that breaks a rule is saved.

Can I undo an import?+

Yes. Past imports lists each one, and Undo removes the records it created.

More about this feature

More to read

Start with the interview.

You'll see exactly what we'd build before anything is built.

Build my CRM