Preparing the import fileYour Excel file must contain a first row with the name of the fields, as well as one contact per row. It is possible to import a file with a single column labelled "email address.”
To speed up the data processing time, avoid using a file with complex formatting or macros. You can quickly copy and paste your data without formatting it by copying the data and pasting it into a new file using the “Paste values” option in Excel.
- In the Newsletter application, click on the Contacts menu and then on Connectors.
- In the Import Excel section, click on Upload and select your Excel file.
Three columns will then appear. The first column on the left is the list of columns in your Excel file. The center column is the list of custom fields in the Application. You must therefore link the column from your file with the corresponding custom field so that the application knows where to save the data. It is not necessary to link all of the columns if some of them are not used in your contacts.
To link a column, simply drag and drop the block into the corresponding box.
- Click on Import. The import duration with depend on your file size.
A summary will appear. If certain email addresses already appear in your repository, they will be considered as updated contacts. If you have invalid contacts, the corresponding lines will be indicated at the bottom of the page. Invalid email addresses are usually due to an incorrect email address format or when there are empty lines at the end of your file.