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.
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.
Only strictly identical rows are duplicates: the same email address with two different phone numbers remains two contacts. If the Remove duplicates recipients option is turned on in the Sarbacane Campaigns settings, duplicates are also removed before sending, when the credits for your campaign are calculated.
