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.
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.