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?
- A CSV or Excel file with one address per row.
- Permission to load data in Data import. Without it, the Import addresses button is greyed out.
As well as the address, the file can have these columns. None of them is required:
| Column | What to put |
|---|---|
| Legal basis | Consentimiento (consent), Relación previa (prior relationship) or empty so that it is worked out |
| Consent date | When the person gave it. Required if the legal basis is Consentimiento |
| Consent source | Where they gave it: form, trade fair, shop… Empty = ‘Import’ |
| Unsubscribe | S if that address unsubscribed in your previous tool |
| Unsubscribe reason | Empty = ‘Imported as unsubscribed’ |
| List | The name of the list to put it in. If it does not exist, it is created |
How do I do it?
- In Mailing → Addresses, click Import addresses. The import wizard opens with the Mailing addresses destination already chosen.
- Upload the file.
- 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. - Choose whether you want to Create only the new addresses or also update the ones that were already there, with Create and update existing.
- 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.
- With Prior relationship, the address counts as a customer even if it is not in your records, and stays that way.
- With Consent, it is recorded with its date and source.
- If empty, the legal basis is worked out from your customer records and your CRM contacts.
- With the Unsubscribe flag, the address is unsubscribed. This is permanent.
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:
- the address is not shaped like an email address;
- the legal basis is not one of the valid ones;
- it says
Consentimientoand has no date; - the same address appears twice in the file, even with different capital letters.
Fix those rows in the file and import it again: the ones that already went in are not duplicated.
More about Mailing
- Newsletters and lists from your customers, suppliers and contacts
- Mailing campaigns
- How to design an email template
- Consent and legal basis of each address
- Newsletter control: progress, pausing, resuming and cancelling
- Managing mailing addresses
- The ERP sending service: sending your newsletters without your own email account
- Sending invoices and other documents by email
- Mailing: newsletters, lists and who you can write to
- The quality of an email address
- Mailing settings: quality, consent, tracking and retention
- Asking for consent by email: double opt-in