This guide will give you a basic walkthrough of uploading Contacts/Customers into Jetpack CRM. If you need more CSV importing power, we recommend checking out CSV Importer Pro.
Upload your CSV File
First upload the CSV file to CSV Importer. To do this select “Data Tools” and then “CSV Importer” from your Jetpack CRM top menu bar.
You’ll be presented by an upload screen similar to what you see when you upload a plugin or theme to WordPress.
Here you’ll simply need to select the .CSV file from your computer and click “Start CSV Import Now”.
Map your fields
Click here for a full guide on mapping fields in CSV Importer
Once you have your CSV file uploaded, you’ll be presented with the second page of the import wizard, which will look something like the following:
As you can see in this screenshot we’re presented with several drop down lists. Each one of these white boxes represents a field in your CSV (a column). The CSV Importer extension pulls through the first line of your CSV file as an example (Shows up with the label “Map: “). This way you can see what should go where.
Note on Ignoring first line (CSV Column Titles): If your CSV file has a “header line”, that is that its first line contains titles for each column, you will need to tick “Ignore first line of CSV…” – otherwise you’ll get your titles imported as a customer!
On this page you’ll need to go through and select a field to map each of your columns of data (from your CSV) into. For example, if you have “Email address” as a column in your CSV, you can select “Email Address” from the “To: ” drop down list, and then when the importer pulls through that field for each line it’ll assign the customers email address to the right field in Jetpack CRM.
You’ll need to select at least one field to map here, and select “Ignore This Field” for any which don’t fit within the Jetpack CRM Customer framework.
Note on Importing Tags: Click here for info on Tagging
Checking Your Mapped Fields
Great, so if you’re following along with this documentation you’ll now see the 3rd wizard page, which will look something like this:
This page shows a summary of what will be imported, including the number of lines (Customers), as well as any import settings (Ignore first line), and field mappings you’ve set.
Note: It’s worth going through your field mappings again here. Once you’ve clicked Run Import, there’s no easy way to remove all of the customers that’ll get added.
Unless you see any problems here you can scroll down to the bottom and click “Run Import”
Import Complete
All being well you’ll now see an import which will look something like this:
That means your import was successful! In this example, we’ve only imported 3 customers, but you’ll likely have many more. Provided you didn’t hit any snags you should now see all of these customers in your Customers list.
You can now safely close the import wizard or click through to another part of your Jetpack CRM.
Useful Note: The number to the right of each customer in the log (like #9977) is the customer ID for the imported customer.
Useful Note: The “date added to CRM” will always be the date of the import, since that’s the date the contact was imported/added to Jetpack CRM. It’s not possible to change that. However, if you need to keep track of a separate date, you could add a custom field with that date.
Congratulations, you’ve successfully imported some customers into Jetpack CRM.
FAQ
I don’t import customers frequently. Do I need to keep the CSV Importer plugin active?
Unless you’re importing customers regularly, you can safely deactivate the “CSV Importer” plugin from your WordPress admin menu. By deactivating the plugin, you’ll save one or two milliseconds when loading Jetpack CRM pages (optional).
What happens if you import contact data via a CSV file if the contact already exists within the CRM? Does that create a duplicate contact? Will the data be overwritten?
The CSV Importer determines duplicate contacts by email address. If the newly imported contact data is a duplicate, the information will be updated for all other fields except the email address.