Importing blank contact attributes

In this guide, we'll review how to import empty fields and choose how to update your existing contacts' details.

Overview

When importing contacts, you will see an option during the confirmation step to “Import empty fields to erase existing attribute data in SendinBlue”.

If enabled, empty fields in your import will erase any attributes that currently contain data in SendinBlue. If disabled, the empty fields will not affect your existing data.

Screenshot_2019-01-04_11.37.20.png

Example 

Let’s say the following subscribers already exist in your contact list and you want to remove some of their details.
Capture_d_e_cran_2019-01-02_a__16.28.52.png

Click on Import contacts and select your favorite import method. In this example, we’ll choose to copy/paste the following data:

EMAIL;LASTNAME;FIRSTNAME;SMS
john@example.com;;John;33123456789 
harry@example.com;Pierce;Harry;33111222222
howard@example.com;Paige;;33777888898


For the contact with the email address john@example.com we are choosing to erase LASTNAME from this contact’s details and for howard@example.com we are erasing his FIRSTNAME attribute.

Then you can Check your data to preview your import:

Capture_d_e_cran_2019-01-04_a__17.37.04.png

Once you have finished your mapping and selected your list(s), then enable the “Import empty fields to erase existing attribute data in SendinBlue” option to finalize your import.

Capture_d_e_cran_2019-01-02_a__16.25.16.png

As soon as the import is completed successfully, you will see your contacts details updated like below:

Capture_d_e_cran_2019-01-02_a__16.32.22.png 

Good to know: If the option “Import empty fields to erase existing attribute data in SendinBlue” is switched off, empty imported fields will be ignored and your contact details won’t be removed.

Related articles