To import contacts into Sarbacane Contacts, open a standard list and choose how to add them: file, manual entry or copy and paste. You then map the columns of your file to the fields of the list. Allow about five minutes with a prepared file.
A Sarbacane Campaigns license (Sarbacane Contacts is included).
A standard list: how do you create a contact list.
A prepared file: what should you prepare before importing your contacts.
After you create the list, the screen for adding contacts opens. On the right, choose Import a file (.xlsx, .txt, .csv), Manual entry or Copy / Paste.
For a file, in the center, drop it into the "Drag and drop a file here to import contacts" box or click Browse. The size limit is 100 MB. For copy and paste, separate each address with a comma, semicolon, tab or line break.
If your numbers have no country code, choose the country below the box, in Format phone numbers without any area code (France (+33) by default). A single country code applies to the whole import.
The Correspondence of the columns screen opens. For each row under CURRENT COLUMNS, choose the matching column of your file under NEW SOURCE. Only columns with the same header are mapped automatically. For example, map your pixel column to Email pixel tracking consent. Leave <None> if you have no data to map.
If your file contains information the list does not have, click + New column.
At the bottom, click Validate. For a file import, the contact analysis then starts automatically.
Open the list. At the top left, next to its name, click •••, then Add contacts.
Choose how to add contacts, then your file, as for a new list.
Important: if your file comes from a Sarbacane export, first rename the "Email pixel tracking consent" column to pixel. Its header contains the word "email": it would not be picked up and the consent would be lost.
The Adding contacts window opens.
Caution: Replace permanently deletes all the current contacts in the list. There is no trash for contacts, only for lists.
Click Complete to add your contacts to the ones already there.
Map the columns as for a new list, then click Validate.
The contacts appear in the list and the counter updates. The SOURCE column shows the name of the imported file. Pixel consent shows as Active or Inactive, dated the day of the import. Contacts excluded by the analysis are in the list's incorrect tab.
Its header probably contains the word "email", for example in a Sarbacane export. Rename it before importing, unless it is the column with the addresses. If your file contains two "email" or "phone" columns, keep only one.
Check that the pixel column is mapped to Email pixel tracking consent at the mapping step: it isn't automatic.
By default, a new column is a text column. Before importing, tell Sarbacane Contacts that it contains dates:
Next to the list name, click •••, then Manage columns.
To the right of the column, open the type menu and choose Date type field.
In the list that opens, choose the format used in your file, for example DD/MM/YYYY or YYYY-MM-DD. The order of day, month and year, the separator (/ or -) and whether the time is included must match exactly.
At the bottom, click Validate.
If your dates are stored as text in your file, convert them to a date format in your spreadsheet before importing.
The contact analysis starts automatically after a file import. If you added contacts another way, run it yourself: next to the list name, click •••, then Analyze addresses. Excluded contacts move to the incorrect tab, with their cause, for example Duplicate or Unknown domain.
The contact analysis only removes strictly identical rows: the same email address with two different phone numbers stays on two rows. At the time of sending, however, if the Remove duplicates recipients option is turned on in the Sarbacane Campaigns settings (it is on by default), only one row per address is kept, with the information from the last row. To send one email per row to the same address, see why contacts are excluded from my campaign.
