Integrations

Transferring contacts via CSV

You can bring contacts from any tool, e-shop or spreadsheet into SmartMailer with a CSV file. This guide shows how to prepare the file, how to split contacts by status and how to check the import result.

How it works

  • The steps apply to every tool that can export contacts to CSV. Some tools also have their own guide, you will find them in the Guides for specific tools box.
  • You use the regular contact import of an address book: choose the file, map the columns to the fields of the address book and SmartMailer shows the result.
  • You can run the import again. SmartMailer finds a contact that is already in the address book by its e-mail and updates it, and adds new contacts.

Step by step

  1. 1

    Prepare address books in SmartMailer

    In the Address books menu, create a recipients address book and add fields for the data you want to transfer. A field can be text, e-mail, phone, number or date. For unsubscribes you have an address book of the Unsubscribes type called Default unsubscribes.

  2. 2

    Export contacts with their status

    Export the contacts from the original tool to CSV, ideally in UTF-8 encoding. Include the contact status and the consent details if the tool keeps them. If the tool can export each status separately, use that.

  3. 3

    Split contacts by status

    Following the Contact statuses table, split the rows into two files: subscribed contacts into a file for the recipients address book, unsubscribed, blocked and hard bounce contacts into a file for the unsubscribe address book. Put unconfirmed contacts without documented consent into neither of them.

  4. 4

    Import the recipients

    In the recipients address book, click Import contacts and choose the file with subscribed contacts. In the Column mapping window, check which address book field each column belongs to and click Import.

  5. 5

    Import the unsubscribes

    Import the file with unsubscribed, blocked and hard bounce contacts the same way into the Default unsubscribes address book. Campaigns then exclude it as the status table describes.

  6. 6

    Check the result

    After the import, SmartMailer shows how many contacts were added, how many were updated and which rows were not imported and why. For a file with more than 1,000 rows you will find this in the Background imports panel on the contacts page of the address book once it finishes. In a campaign, the Count recipients button then shows how many addresses remain after duplicates and excluded address books are removed. Do not cancel your account in the original tool until you have checked the import.

What the file looks like

The first row holds the column names, every following row one contact. This is a small file with consent:

email,fname,lname,CONSENT_AT,CONSENT_SOURCE
jana@example.com,Jana,Nováková,2024-03-05 14:30:00,Website form
petr@example.com,Petr,"Svoboda, ml.",,
  • Save the file in UTF-8 encoding, a BOM at the start of the file is fine. A file that is not valid UTF-8 is read as Windows-1250, so older Excel exports work too.
  • The header is the first non-empty row. A column is mapped to an address book field by the field slug or name, letter case does not matter.
  • SmartMailer detects the column delimiter from the header itself: semicolon, comma, tab or vertical bar. You do not choose it for the import, the CSV delimiter setting in your account preferences applies only to exports and the sample file.
  • Wrap a value that contains the delimiter in double quotes, like "Svoboda, ml." in the sample.
  • After you choose the file, Column mapping appears with the first contact of the file. Columns with the same or a usual name as a field are preselected, the others are set to Do not import. The e-mail column is required and each field belongs to one column only. The consent columns are in the list too, so you can map them from a differently named export column.
  • Download the header for a specific address book with the Download sample CSV button in the import window.

Contact statuses

Tools name statuses differently. Use this table to decide where each contact belongs.

Status in the original tool Where it goes in SmartMailer
Active, subscribed, confirmed Into the recipients address book.
Unconfirmed, pending confirmation Among recipients only with documented consent, otherwise nowhere.
Unsubscribed Into an address book of the Unsubscribes type.
Blocked, blacklisted, spam complaint Into an address book of the Unsubscribes type.
Hard bounce, permanently undeliverable Into an address book of the Unsubscribes type, not among recipients.
  • A campaign always excludes the address book selected in the Record unsubscribes in field. For a new campaign it is preset to the default unsubscribe address book from the project settings, and when none is set, to the Default unsubscribes address book.
  • A campaign excludes unsubscribes in another address book only when you select it in the Exclude address books field of the campaign.
  • If SmartMailer already knows an address as permanently undeliverable, the import adds it to the recipients address book, but the campaign does not send it an e-mail and Count recipients lists it as undeliverable.

What a CSV import does not transfer

  • Campaigns, templates and automations or their statistics. Create them again in SmartMailer.
  • The history of sends, opens and clicks of individual contacts.
  • Tags, groups and segments as such. Turn a tag or group into a column and import it into a custom contact field. In a campaign you then narrow the recipients in the Segmentation section by the field, for example with the equals condition. All conditions apply at once.
  • The equals condition compares the whole field value. When one cell holds several tags, put each tag into its own field, or split the contacts into several address books.

Watch out for

  • A contact is looked up in the address book by its e-mail, letter case does not matter. A repeated import therefore does not create the same contact again but updates its data.
  • An empty cell in a mapped column clears the field value of an existing contact during the update. Leave columns you do not want to change for existing contacts on Do not import in the mapping, their values stay.
  • If the same e-mail is in the file more than once, the first row is imported. SmartMailer skips the other occurrences and lists them in the import result.
  • A row without an e-mail, with an invalid e-mail or with a value the field does not accept is not imported, the other rows are. For a recipients address book SmartMailer also checks that the e-mail domain accepts mail. Addresses on defunct domains are still imported into an unsubscribe address book so that they stay excluded.
  • One import always goes into one address book. Import lists you want to address separately into separate address books. You can send a campaign to several address books at once and an address that is in more of them receives the e-mail only once.
  • The file can be at most 50 MB. A file with more than 1,000 rows is imported in the background, so you do not have to split it or wait on the page. The result is sent to you by e-mail. Only one background import runs for an address book at a time.

Always transfer unsubscribes

People who unsubscribed must not receive commercial messages after the switch, so do not leave unsubscribes out. Do not import contacts without documented consent or another legal basis as recipients.