Importing your address book

9 June 2021

Step 1 

To upload your address book in a specific format (CSV) open your address book in Microsoft Excel. 

The columns marked with * are required fields.

Please note, your file should have the following columns in this order:

• First Name
• Last Name (Either company name or last name is required.) *
• Company *
• Email Address
• Phone Number
• Address Line 1
• Address Line 2
• City
• County/State
• Postcode
• Country *

Once complete, click Save As

Next choose Comma Separated Values .CSV and click Save

Step 2

Go to 'Setup' in your eCommerce Hub dashboard, in the drop down menu select 'Automation'. Here you will need to click Address Book.

You can now select Choose file which will allow you import your address book that you saved earlier in a CSV format. Remember, tick the box which reads 'Skip the first row (it contains headers). 

If you have any questions, please contact your account manager.