The Quick Import tool provides a quick and easy way to add a batch of accounts to your database without using the standard Import Manager.
To access the Quick Import tool, navigate to Tools > Import Manager and click on Quick Import.
From this page, you can either manually type in the account information or paste it directly from a spreadsheet. Your spreadsheet columns should be set up in the order shown in the Quick Import tool.
If you choose to paste from Excel, please note that you can only paste to this sheet once per import. To paste, select the first cell and hit Ctrl + V (Command + V for Mac users).
Importing Individual Accounts
The default page is for importing individual accounts. You cannot import company accounts from this page.
Importing Company Accounts
To import company accounts, click on the below link to change to the Company Quick Import form. Note that the spreadsheet columns are slightly different.
Quick Import Commands
This checks your data for any issues (as described in the Data Problems section below).
Save My Work
This saves your import without creating NeonCRM accounts, so you can come back later and finish making changes before importing. You can access saved imports by navigating to: Tools > Import Manager.
This imports your data into NeonCRM and creates accounts. This can be reversed by navigating to: Tools > Import Manager and clicking Delete next to the import you wish to reverse.
This removes all currently-entered data from the quick import sheet.
This cancels the import process and sends you back to the Import Manager dashboard. All unsaved data will be lost.
NeonCRM highlights data cells that contain problems. While you can proceed with an import of problematic data, we don't recommend it. Here are some explanations for common problems:
NeonCRM requires a first name and last name to create an account.
This import tool requires states to be formatted as two-letter state codes. This includes Canadian provinces.
Zip codes must be at least five digits long.
Email addresses must be complete and correctly formatted.