Import your contacts from an excel File into SendinBlue

1. You have fewer than 1000 contacts to import into SendinBlue

2. You have more than 1000 contacts to import into SendinBlue

3. Finalizing the contacts import and mapping your attributes

In order to send email campaigns to your contacts, you’ll need to import these contacts into SendinBlue. At a minimum, you’ll need to import your contacts’ email addresses. However, you can import as many additional fields as you want. It does not matter if some fields are empty for some contacts.

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.

1. You have fewer than 1000 contacts to import into SendinBlue

If you have fewer than 1000 contacts to import into SendinBlue, we’ve made the process extremely simple. Login to your SendinBlue account and go to the “Import Contacts” section in your account. If you can’t access that page directly, navigate to the “Contacts” section in SendinBlue and click the "Import Contacts" option.

ImportContacts.png

Once you get to the Import Contacts section, select the “Copy Paste” option.

CopyPaste.png

copyPaste2.png

Now open your Excel file and select the contacts you wish to import to SendinBlue. Right click and select Copy.

CopyExcel.png

Now go back to SendinBlue, and paste your contacts into the CopyPaste window.

image11.gif

To finalize your contact import, jump to section "3. Finalizing the contacts import and mapping your attributes".

2. You have more than 1000 contacts to import into SendinBlue

If you have more than 1000 contacts to import into SendinBlue, you’ll need to import your contacts as a .csv file.

First, login to your SendinBlue account and go to the “Import Contacts” section on your account. If you can’t access that page directly, navigate to the “Contacts” section on SendinBlue and click the Import Contacts option.

image12.png

Once you get to the Import Contacts section, select the “Import a file” option.

image13.png

Now go back to your excel file in which you’ve stored your contacts. You can only export one sheet from your excel file as a .csv formatted file, so you’ll need to navigate to the sheet where your contacts are stored before going to the next step.

image3.png

Next, go to File > Save As. In the contextual menu, name your file and select CSV UTF-8 (Comma delimited) (.csv) as file format.

image4.png

Excel will warn you that it’s only going to save the active sheet as a .csv file. Accept the warning and confirm.

image9.png

Finally, locate your .csv file, and drag it into SendinBlue’s import section.

image5.png

Alternatively, you can click on the cloud icon in SendinBlue and locate your .csv file from where you have it saved in your computer file system using the contextual menu.

3. Finalizing the contacts import and mapping your attributes

You can now map your custom fields (if any) to existing or new attributes, or you can simply decide to ignore certain columns.

image10.png

Confirm your mapping, and choose the list to which you’d like to add your contacts. You can either create a new list, or select an existing list. If you are importing contacts for the first time, SendinBlue will have already generated a default first list called “My First List”.

image2.png

Good to know: In SendinBlue, contacts are unique, and can be in different lists. You can import some of your contacts to different lists by repeating this process at anytime. Unlike most email platforms, you can have unlimited lists, contact attributes, and contacts for free on SendinBlue, so you can really make the most of our segmentation tools.

To finalize your import, confirm that it respects our Terms and conditions (and make sure it really does, or you’ll get in trouble later on down the line) and confirm your import!

image8.png

Voilà! You’re now ready to send your first campaign with SendinBlue!