Importing your contacts into SendinBlue

SendinBlue enables you to send email campaigns, SMS campaigns, and marketing automation messages to your contacts. To do this, you first need to import your contacts into SendinBlue.

Import your contact's email address(s) as a minimum. However, you may import as many additional data fields (we call them contact attributes) as desired, such as first name, last name, birthday, mobile phone number, etc. 

Good to know: You may define your contact attributes before uploading your contact list or during the import process. You may set up additional contact attributes anytime.  

Three import methods

There are three ways to import your contacts into SendinBlue. Go to the Contacts page to see all three methods. 

import-contacts-EN-1.png

1. Importing contacts from a CSV or TXT file

Most SendinBlue users prefer this import method. You may import your contact list formatted as a CSV or TXT file.

Most website CMS (Prestashop, WordPress, etc.) and CRM solutions (Pipedrive, SalesForce, etc.), allow you to download your contact list as a CSV file. Typically, you may import this file directly into SendinBlue. Or, you may download our sample import file, add your contacts to the sample, and import this file. 

To learn more about setting up a contact import file: 

import-contacts-EN-2.png

2. Adding contacts manually

You may add contacts manually. This method allows you to add new contacts one by one. For a large import, we suggest you use the import or copy/paste methods.

import-contacts-EN-3.png

3. Copying and pasting contacts

To import contacts using the copy/paste method, copy and paste them directly into the empty field in SendinBlue. (You can add up to 500 contacts without importing them from a CSV or TXT file.)  

import-contacts-EN-4.png

Add each new contact on a new line and place a separator between each piece of information about your contact. 

Each contact and its attributes must be separated by either a comma ,, semicolon ;, or tab        as shown in the example below.

EMAIL,FIRSTNAME,LASTNAME 
subscriber1@example.com,firstname1,lastname1
subscriber2@example.com,firstname2,lastname2
subscriber3@example.com,firstname3,lastname3

Good to know: You may include a header row to specify the name of each contact attribute in the import but this is not required.   

Importing contacts

To import contacts, select one of the three methods mentioned above. In our example, we've chosen to import contacts using a CSV file. To do this, go to the Contacts page.

1. Upload your file 

Click on the Add contacts button, then click on the desired method. Here, we've chosen to import a file.

import-contacts-EN-5.png

Click on Select a file and select the desired CSV file, or drag and drop your file within the outlined area.

import-contacts-EN-6.png

Next, you will see a preview of the contacts and attribute data to be imported from your file. The column headers shown in the preview are the same as the headers in your import file. 

import-contacts-EN-7.png

If the contacts and attributes are separated correctly, click Confirm your file to move to the next step. 

2. Mapping data 

In this step, you will indicate how SendinBlue should match the data from your file to your SendinBlue contact list. If you have already defined your contact attributes in your SendinBlue settings, we will attempt to correctly match the data from your file to an existing contact attribute. 

To match the data to a different contact attribute or mark the data as "do not import", click in the Contact attribute drop-down menu and choose your preferred option. 

import-contacts-EN-8.gif

You may also choose to Add a new attribute to define a new contact attribute. 

import-contacts-EN-9.gif

3. Select a list

Now, 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. 

import-contacts-EN-10.gif

Finalize your import 

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

Default settings 

  • If any contacts in your import already exist in your SendinBlue contact list, their attributes will be updated to reflect the current import. 
  • Your email contacts will not be blacklisted. 
  • Your SMS contacts will not be blacklisted. 

Click on the toggle next to each option to choose the opposite of the default setting. 

import-contacts-EN-11.png

Opt-in agreement

SendinBlue may only be used to send emails or SMS messages 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.

import-contacts-EN-12.png

Click Confirm your import to begin your import. 

You will be redirected back to your Contacts page.Large imports may take a few moments to fully process. 

Once completed, 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. 

import-contacts-EN-13.png

What's next?