Importing data
Work imports contacts, companies and deals from CSV files.
Find it at Settings → Data. Importing is owner-only and remains available while an account is paused for billing.
File requirements
- One record type per file. Import companies first, then contacts, then deals, so that later imports can reference existing records.
- Headers in the first row. Header names are mapped in step two.
- Up to 5,000 rows per file.
- CSV only. XLSX files are rejected.
A sample CSV is available for each record type.
The five steps
1. Upload
Choose Contacts, Companies or Deals, select the file and continue.
2. Map columns
Work reads the headers and pre-selects a Work field for each, based on the header name.
Each column has a dropdown holding the available Work fields and — Skip —. Unmapped columns are ignored.
| Type | Available fields |
|---|---|
| Contacts | First name, Last name, Email, Phone, Title, Company |
| Companies | Name, Domain, Address |
| Deals | Name, Value, Stage, Expected close on, Company, Contact |
For deals, Stage takes one of lead, qualified, proposal, won, lost. Company and Contact columns are matched by name against existing records.
Duplicate handling
Set If a record already exists to:
- Skip it (default): the existing record is left unchanged.
- Update it: the existing record is overwritten with the file's values.
3. Preview
The first five rows are shown as they will be saved, each marked OK or Error with the reason.
Rows with errors do not block the import. They are skipped.
4. Confirm and import
Press Confirm and import. The import runs in the background with a progress bar showing a percentage and “x of y rows”. The page can be closed while it runs.
5. The report
On completion, the Data screen shows a summary and the import's page shows the full result:
| Count | Meaning |
|---|---|
| Created | New records added |
| Updated | Existing records overwritten |
| Skipped | Existing records left unchanged and rows with errors |
| Errors | Listed per row with a reason |
The last 20 imports are listed on the Data screen with their status.
Re-running an import
Records are matched on an identifying field: email for contacts, name for companies. Importing the same file twice skips or updates existing records according to the duplicate setting.
Common errors
| Problem | Cause |
|---|---|
| “Must be a CSV” | The file is XLSX. Re-export as CSV |
| Contacts imported without their company | The companies did not exist yet. Import companies first |
| A deal's stage is blank or wrong | Stage must be lead, qualified, proposal, won or lost |
| Dates rejected | Use YYYY-MM-DD |
| File over 5,000 rows | Split the file into batches |
| Names in one column | Split into first and last name columns before importing |
Alternatives
For an ongoing sync rather than a one-time migration, use the API or the CLI, which create contacts, companies and deals directly.