Importing Contacts from a CSV file

A CSV file (Comma-Separated Value) is simply a text file that is used as a simple way to transfer information between two computer programs that use different file types.

If you have been using another contact manager/address book/customer database program such as Top Producer, Outlook or Gmail Contacts, you would use the ‘Export Contacts’ or ‘Export to a file’ feature in those programs to create a CSV file containing your contacts. Once you have that CSV file saved to a folder on your computer, you are ready to Import those contacts into My Book.

We recommend you to export your Contacts into groups of the same Category and Grade.

Required file format

You can import comma-separated-value (.CSV) text files. Each line in the file contains multiple columns of information for a single contact, as shown in the example below. The first row can optionally contain field names – this is not necessary but it does result in a better “first guess” data mapping with less work for you in the column mapping portion.

Where do I get a CSV file?

If your contacts are currently in a spreadsheet such as Microsoft Excel, you can simply do a File -> Save As and select CSV file format

If your Contacts are currently stored in another computer program such as Outlook or another CRM solution, you will need to use that program’s Export or Export to a File feature. Once you have that CSV file saved to a folder on your computer, you are ready to Import those Contacts and Leads into Your Book.

Importing your Contacts from the .CSV file

1. To begin the import process click on 'My Book'

2. Click on 'Import Contacts' at the bottom of the page

3. This will bring you to the first step in the Import Wizard screen

1 - Here you will have agree that you are not uploading a purchased email list.

2 - Once you have acknowledged and agreed that you are importing your personal Contacts, you can click the Upload button to select your desired CSV file to be imported.

Not a Spam Engine
The Contact Import feature is intended to allow you to transfer Contacts and Leads from another Contact database into Your Book. This is NOT intended to allow you to import purchased email lists for purposes of directly emailing (“spamming”) those email addresses.

Column Mapping

When you import your Contacts from other programs, they may use field names that are very different from the Jumptools Contact attributes. We do our best to automatically figure out which columns in the CSV file should be put into which Contact fields, however there are situations where we are unable to determine which fields specific columns should map to.

1. From the drop down list, select the category that best matches the Header Column content

In order to import the most data possible from your other program you can review our suggested mapping of file columns to Contact attributes. You can also manually specify mappings for columns that did not get automatically mapped. If there are some fields you don't want to import, you can simply leave those as Unmapped.

2. Once you are happy with a particular column mapping, you can lock In that selection. This helps you avoid the mistake of trying to map more than one column to the same contact attribute.

3. Once you are happy with the column mappings, simply click the “Do Import” button to start bringing in the contacts from your uploaded file.

Completion

Once the import process has completed, the confirmation screen below will be displayed.

All contacts will be imported into a new group with the current day’s date as the group name. Once the import process has completed you will be navigated to view the newly-created group.

Your Book is compliant with the Canadian Anti-Spam Law (CASL). For each contact in Your Book, you can manage whether that individual has provided consent to receive electronic communications. As a subscriber, you agree to abide by CASL when sending electronic communications through our service.