Skip to content

Importing mailing addresses from a file

How to load a whole list of addresses at once —from another mailing tool or a spreadsheet— with their consent and with the unsubscribes you already had. You do it with the Data import wizard, the same one that imports customers or items.

What do I need before I start?

As well as the address, the file can have these columns. None of them is required:

ColumnWhat to put
Legal basisConsentimiento (consent), Relación previa (prior relationship) or empty so that it is worked out
Consent dateWhen the person gave it. Required if the legal basis is Consentimiento
Consent sourceWhere they gave it: form, trade fair, shop… Empty = ‘Import’
UnsubscribeS if that address unsubscribed in your previous tool
Unsubscribe reasonEmpty = ‘Imported as unsubscribed’
ListThe name of the list to put it in. If it does not exist, it is created

How do I do it?

  1. In Mailing → Addresses, click Import addresses. The import wizard opens with the Mailing addresses destination already chosen.
  2. Upload the file.
  3. In the mapping, say which column of your file is each field. If the columns have the same names as the fields (Direccion, BaseLegal, FechaConsentimiento…), they are assigned automatically.
  4. Choose whether you want to Create only the new addresses or also update the ones that were already there, with Create and update existing.
  5. Import and check the report.

What happens when I import?

Each address comes in normalised, in lower case, with quality 70. If it was already in the register, it is reused: an identical one is never created.

Importing never downgrades what was already there. If an address had consent, importing it as ‘Prior relationship’ does not remove it. A consent older than the one stored does not replace it. And an unsubscribe is not lifted by importing. In those cases the row goes in, and the report says what was not applied and why.

With Create only, an address that was already in the register is not touched: it appears in the report as skipped.

How do I put them all in a list when I import them?

With the List field. In the mapping, assign it to a column of the file that gives the list for each row, or type the name in quotes —for example "Feria 2026"— to put them all in the same one. If there is no list with that name, it is created.

If the address belongs to a single record or a single CRM contact, and the list would write to exactly that address, that record or contact goes into the list; if not, the address on its own goes in. With Create only, an address that was already there is not touched, but it does go into the list. Nothing is added to an archived list: the address is imported anyway and its row says so. It is explained in mailing lists.

Which rows are rejected?

Rows that cannot be imported are left out with their reason, and the rest go in anyway:

Fix those rows in the file and import it again: the ones that already went in are not duplicated.

More about Mailing