Import contacts from a CSV file
Bring your existing customers, suppliers and companies into OPS360 from a CSV file, check the column mapping and fix any rows that can't be imported.
- What you'll achieve: Your contacts imported into the shared address book, with a list of any rows that need fixing.
- Who can do this: Contacts: Create (and Update to change existing contacts)
- Time: about 4 minutes
Before you start
- Your contacts in a CSV file with a header row, exported from your old system or a spreadsheet (up to 2000 rows per import).
- Any custom fields you want to fill in exist in Contacts → Settings → Custom fields.
Steps
1. Open Import data
In the sidebar, select Contacts, then Settings, and select the Import data tab.
Tip: You can also select Import at the top of the contact list.

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 what the file contains
Select Contacts & companies. 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, using the Example value as a guide. Choose Don't import for columns you don't need.
Tip: A contact needs at least a full name, first name, last name or company name, and an email or phone number.

7. Check the data
Select Check data. This checks every row without saving anything.
8. Review the problems
Check the counts: New, Already exist and Invalid. Each problem is listed with its Row number in your file. Fix the rows in your file and upload it again, or carry on and import only the valid rows.
Tip: If some rows match existing contacts by email or phone, you choose whether to skip them, update the existing contacts, or create duplicates.

9. Import the records
Select Import (it shows how many records will be imported) and keep the window open until it finishes. The result shows how many contacts were Created, Updated, Skipped and Failed.

10. Fix the rows that failed
If any rows were not imported, select Download failed rows (CSV) under Rows that were not imported. The file has an Import error column saying what's wrong with each row. Fix those rows, then import the file again.
Troubleshooting
"Could not read this CSV file."
Save the file as CSV (comma separated) with a header row, then upload it again.
The file has more than 2000 rows.
Split it into files of up to 2000 rows and import them one after another.
"First Name or Name is required for individual contacts"
Map a name column under Import as, or fill in the name on that row of your file.
