Top tips for importing contacts to OnePageCRM

In OnePageCRM you have the option to add individual contacts manually and import multiple contacts from a .CSV file. Check out our top tips below for importing contacts in bulk.

1
Last name OR Organization  name are required fields in order to create a contact in OnePageCRM.
Note:
  • If you have both First name and Last name in the one column, you can easily separate into two. For more details on this click here.
2
Download the import example file and populate the cells with your contacts' details if you don’t have an existing CSV file with your contacts' data or if you’re unsure of what fields you can import. 
Note:
  • For any columns in your .CSV file that OnePageCRM does not have as default fields, you must create custom fields in OnePageCRM prior to importing.
3
Prepare your file by deleting any columns you don’t need. This saves you having to  Ignore fields in  Step 2 of the  Import process.
4
Before importing, manage your status labels and decide whether you want to use  Tags or  Custom fields for grouping data. Check out this article for the pro’s of each - Tags vs custom fields.
5
Before importing, remove duplicates from your import file before importing. For more information on this, check out thi article on how to remove duplicates from import file in Excel.
6
 Make sure you’ve saved your file as a .CSV (comma-separated value) format as otherwise, you may receive errors such as  “ Invalid file type. Please check that you've selected a .csv file and try again. ”
7
To import special characters (for example: á, è, õ, ü, ć) seamlessly, download a free app called Libre Office as it gives you the option to save in Unicode UTF-8.
8
It’s only possible to import a file with one tab, will not work if you've several tabs on the one file.
9
Be realistic when setting Next Actions on your import file. For example, set 10 for one date, then 10 for the next date. This will prevent you from having lots of overdue actions.
10
If you receive the  "Error:   Invalid file separator", check to ensure you don't have a coma at the end of a sentence without any more text, and ensure a semi-colon is not being used instead of a coma. We'd recommend to do a Find and Replace in Excel to amend your file.
11
Check all fields prior to importing. Ensure they are mapped correctly. If OnePageCRM does not recognize a field, the system will highlight it in yellow.
12
We always recommend importing a small sample of data first, such as 10,000 contacts or less, to ensure all data is correct and mapped in OnePageCRM.
Note:

Related Articles