You're able to 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.
To create a new address book:
- Select Contacts from the top navigation menu
- Click on the New address book button
- Enter a name for the address book, select an appropriate folder destination for it and add a description (description is optional)
- Click on the Save button
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 the file to upload by clicking on Choose file. 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).
When ready, click on the Upload button.
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.
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.
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.
If you're importing into an existing address book, and thus overwriting contact data, tick Show advanced settings to select 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 will be 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.