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
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
Choose the module
Under Which Module, pick where the rows should go, for example your customers.
- 3
Add the file
Under The file, choose your CSV. Chaudie reads its columns.
- 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
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
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
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 to read