Import your contacts to Sendinblue

Before being able to send emails and SMS messages, you will first need to import your contacts. While you are able to add contacts one at a time, you will most likely be importing them using an import file.

In this article, we will explain how to import your contacts to Sendinblue.

Before you start

Create the contact attributes

You can define your contact attributes before uploading your contact list or during the import process.

Create your import file

Learn how to format an import file in Format guidelines for contact import files.

To prepare your contact import file:

  1. In a spreadsheet, create and name your column header (optional).
  2. Paste your contacts' information into the relevant fields.
    mceclip3.png

  3. Save the file in a .CSV or .TXT format.

💡 Good to know
We have created three sample import files that you can download and update with your own data:
- Semicolon delimited sample import file
- Comma delimited sample import file
- Tab delimited sample import file

Import your contacts

Option 1: Upload a file

  1. Go to the Contacts tab.
  2. Click Import contacts.
    Import-contacts_import-button.png
  3. Select the Upload a file option.
    mceclip5.png
  4. Select your contact import file or drag and drop it within the outlined area.
    You will see a preview of the contacts and attribute data to be imported from your file. The table header shown in the preview is the same as the one in your import file.
    mceclip6.png
  5. If the contacts and attributes are separated correctly, click Confirm your file.

Option 2: Copy/Paste

  1. Go to the Contacts tab.
  2. Click Import contacts.
    Import-contacts_import-button.png
  3. Select the Copy/Paste option.
    mceclip7.png
  4. Copy the data from your contact import file and paste it into the empty field.
    mceclip8.png
  5. Click Check the data.
  6. You will see a preview of the contacts and attribute data to be imported from your file. The table header shown in the preview is the same as the one in your import file.
    mceclip6.png
  7. If the contacts and attributes are separated correctly, click Confirm your file.

Map the data

You will now indicate how Sendinblue should match the data from your import file to your Sendinblue contact list. If you have already defined your contact attributes in Sendinblue, we will attempt to correctly match the data from your file to an existing contact attribute.

❗️ Important
When importing an SMS number, always include the + sign and the country code.
Please note that to prevent any wrong SMS number to be added to your contact list, we always ask you to select a country code in case there are any SMS numbers that do not have a country code. We will then apply the selected country code to all SMS numbers that do not already have a country code. For example, if you select France, any number without a country code will automatically apply the French country code.

To match the data to a different attribute:

  1. Click the Contact attribute drop-down menu.
  2. Select the desired attribute.

To cancel the import of a specific data:

    1. Click the Contact attribute drop-down menu.
    2. Select Do not import.

import-contacts-EN-8.gif

To define a new attribute:

    1. Select Add a new attribute.
    2. Enter the new attribute name.
    3. Click Create.

import-contacts-EN-9.gif

Once you are done with the data mapping, click Confirm mapping.

Select a list

Choose the list(s) to which your new contacts will be added. You may select one or multiple existing lists, or create a new list.

To select a list:

    1. Go to the Select a list tab.
    2. Tick the list(s) in which you want to add your contacts.

To create a new list:

    1. Go to the Create a list tab.
    2. Enter the new list name.
    3. Select the folder in which the new list should appear.
    4. Click Create list.

import-contacts-EN-10.gif

Once you are done, click Confirm your list.

Finalize your import

Before importing your contacts, you will be asked to confirm several important settings:

Contacts management

  • Update the attributes of the existing contacts: If you enable this option, any existing attribute will be overwritten if contacts in your import already exist. If you disable this option, these attributes will remain unchanged.
    • Import empty fields to erase existing attribute data: If you enable this option, empty fields in your import will erase any contact attributes that currently contain data. If you disable this option, the empty fields will not affect your existing data.
  • Blacklist the imported Email contacts: If you enable this option, your imported contacts will be blacklisted from receiving your email campaigns. If you disable this option, your imported contacts will be subscribed to receive your email campaigns.
  • Blacklist the imported SMS contacts: If you enable this option, your imported contacts will be blacklisted from receiving your SMS campaigns. If you disable this option, your imported contacts will be subscribed to receive your SMS campaigns.

Opt-in agreement

You must use Sendinblue to send emails or SMS messages only to contacts who have officially agreed (opted-in) to receive your messages. Please review our opt-in guidelines to ensure you are only importing opt-in contacts, and then check the box.

Once you are done, click Confirm your import to begin your import. Please note that large imports may take a few moments to fully process.

Once your import is completed, you will then be redirected back to your Contacts page. A banner will summarize the details of your import, including the number of added contacts, number of duplicates, number of invalid email addresses, etc. You will also receive an email notification confirming this summary.

Capture_d_e_cran_2018-12-31_a__11.39.36.png

⏩ What's next?