- You can import Excel, CSV, TXT and ZIP formats into the system.
- You can upload contacts to an existing address book or you can create a new address book.
Creating a new address book
To create a new address book:
- Select Contacts from the top navigation menu.
- Select New address book.
- Enter a name for the address book, choose an appropriate folder destination for it and add a description (description is optional).
- Select Save.
You're now prompted to choose a method for adding your contacts.
- Select the first option - Add a list of contacts from an Excel or CSV file.
- Select Choose file and choose the file to upload. You can also add an email address to notify when the contact import has finished (the logged in user's email address is populated by default).
- Select Upload.
On the data mapping page, click on the dropdown menu of each field and select the appropriate contact data field for each column, or create a new contact data field by selecting Add new data field.
If your file contains consent data, then you'll need to map any columns to the appropriate consent fields in the dropdown - 'consentdatetime', 'consentip', 'consenttext', 'consenturl' and 'consentuseragent'. You don't need to include all five consent fields to be able to map this type of data successfully.
Mapping an opt-in type
To import contacts with an opt-in type, map the following values to the 'optintype' contact data field:
If you don't map one of these values to this contact data field, the value will get set to 'Unknown' by default.
If you don't have verified double opt-in turned on for all signups (under 'Regulatory settings' in your account settings) and you map 'Verified double' as a value to this contact data field, the value will be changed to 'Unknown'.
If your import file uses our standard contact data field labels as column names then these will be automatically mapped for you.
Using column names that differ to our standard contact data field labels
If you've included column names that differ from our standard contact data field labels in any way, you'll need to click on Change settings and tick First row contains column names.
This lets the importer know it should recognise the top row of your import as column names rather than a standard data row, and will prevent the importer from rejecting the row for being an invalid email address.
Extra options for CSV/TXT file formats
If you've used a CSV/TXT file format, extra options are available from Change settings to allow you to set your column delimiter, text qualifier and escape mode.
Overwriting data by importing contacts into an existing address book
- If you're importing into an existing address book, and thus overwriting contact data, select Show advanced settings to choose a data merge option.
- You can either choose to:
- update all of the existing contact data fields with the imported data
- keep existing data in contact data fields from being updated with any imported blank values
- merge your imported data so that you keep any existing values in contact data fields.
- When ready, click on Finish and the file will be imported into the selected address book.
Successful imports are confirmed by a clearance message from our powerful and intelligent data analysis tool, the Data Watchdog.
If any records failed to import successfully, a faults file will be available for you to download at the foot of the confirmation report.