Import deals from a CSV file
Bring your open deals from another CRM or a spreadsheet into OPS360, linked to the right contacts.
- What you'll achieve: Your deals on the Deals board, in the right stages and linked to their contacts, with a list of any rows that need fixing.
- Who can do this: Contacts: Create
- Time: about 4 minutes
Before you start
- Your deals in a CSV file with a header row (up to 2000 rows per import).
- The contacts the deals belong to are already in Contacts (see "Import contacts from a CSV file"), or you let the import create them.
- Your pipeline stages are set up (Deals → Pipeline Settings).
Steps
1. Open Import data
In the sidebar, select Contacts, then Settings, and select the Import data tab.

2. Start an import
Select Start an import.
3. Choose where the file comes from
Choose where the data comes from: Zoho CRM, HubSpot, Salesforce, QuickBooks Online, or Other CSV for any other file.
4. Choose Deals
Select Deals. Import one record type per file.

5. Choose your CSV file
Select Choose a CSV file and pick your file. It needs a header row, and up to 2000 rows.
6. Check how each column is imported
For each Column in file, check the field under Import as. A deal needs a Deal title. Contact email or Company name links it to a contact. Choose Don't import for columns you don't need.
Tip: Turn on Create a contact when the deal's contact or company is not found only if the file holds new customers. Otherwise a typo in an email creates a duplicate contact.

7. Check the data
Select Check data. This checks every row without saving anything.
8. Review the problems
Check Ready to import, Warnings and Invalid. Each problem is listed with its Row number in your file. Fix those rows and upload the file again, or carry on and import only the valid rows.
Tip: A stage that doesn't match one of your pipeline stages is reported here. Rename it in the file, or add the stage in Pipeline Settings first.
9. Import the deals
Select Import (it shows how many records will be imported) and keep the window open until it finishes. The result shows how many deals were Created, Updated, Skipped and Failed.

10. Fix the rows that failed
If any rows were not imported, select Download failed rows (CSV). The file has an Import error column saying what's wrong with each row. Fix them and import that file again. The imported deals appear on the Deals board in their stages.
Troubleshooting
"Could not read this CSV file."
Save the file as CSV (comma separated) with a header row, then upload it again.
The import says the base currency isn't set.
Deals without a Currency column use your base currency. Set it in Settings first, or add a Currency column to the file.
A deal was imported without a contact.
No contact matched its email or company. Link it from the deal's Edit form, or import again with the create-contact switch on.
