Import contacts from a spreadsheet

5 min read72
Copy for AI:

Importing brings your base from another system in one go. It lives in Audience β€Ί Contacts, under the Import button, and has four steps: File, Mapping, Review and Result. Nothing is saved until you confirm in the third step β€” the review is a dry run that shows what would happen. Renata, from Casa Moura CafΓ©s, uses it to bring the customers exported from the store's sales system straight into the Store customers list.

1. File

The screen accepts Excel (.xlsx, .xls) or CSV, up to 20,000 rows and 10 MB. Have more? Split the spreadsheet.

  • Excel template and CSV template β€” download, fill in and upload back: the columns are already in place.
  • Copy AI instructions β€” for a spreadsheet that came from another system, with different columns and names. Paste the instructions into an artificial intelligence tool together with your spreadsheet and our template, and it returns the file in the import format. Check the returned file before uploading it.

2. Mapping

Each spreadsheet column shows up with its first value as an example ("e.g. ..."). Choose which contact field it goes to, or Do not import this column. Columns with well-known names (email, name, phone, city, company) arrive already linked, as do columns with the same name or key as one of your custom fields. Check them anyway. Each field takes only one column, and the Email column is required.

Add to lists

Choose the lists the imported contacts will join β€” in the example, Store customers.

If the email is already registered

  • Skip β€” keeps what is already registered, and the row counts as "already exists".
  • Update β€” the spreadsheet corrects the record. Empty cells erase nothing: whatever is blank in the spreadsheet stays as it was on the contact.

Three details that make a difference:

  • With Skip, existing contacts keep their record as it is, but join the chosen lists. Importing the store's base into Store customers also puts there those who were already customers, without touching anyone's data. The exception is a deleted contact: it stays in the trash and out of the lists.
  • A contact you deleted counts as registered: with Skip it stays out; with Update it is restored.
  • Neither option touches the contact's status. Importing again does not resubscribe someone who asked to leave.

The legal basis

Before reviewing, answer On what basis will you write to these people?:

  • They opted in β€” form, checkbox at sign-up, explicit request.
  • There is an ongoing relationship β€” customers, suppliers, partners, students.
  • Legitimate interest β€” prior relationship with a reasonable expectation of contact.

Then tick the statement that these people can leave the list at any time and that you take responsibility for the base. It is recorded with date, time and origin. On contacts created by the import, the Consent source shows the import and the chosen basis; contacts that already had a source keep the original. The choice of basis is yours β€” the screen records what you stated.

Without the email linked, a legal basis and the statement, the Review button stays off, and the warning says what is missing.

3. Review

The spreadsheet is read row by row without saving anything. Large spreadsheets take a few minutes, and you can cancel midway. At the end, four numbers:

  • Will be imported β€” what will come in.
  • Already exist β€” emails already registered (when you chose Skip) and rows that repeat another row of the same file: the second identical row is ignored.
  • With problems β€” rows that will not come in.
  • Rows in file.

Under What will not come in, each line shows the spreadsheet row number, the field, the value as it came and What to fix: blank or invalid email, a value that does not fit a custom field (a date that is not a date, an option that is not on the list). Download CSV takes that list with you so you can fix the spreadsheet and import only what was missing.

Two cases that come in but do not receive: an address already blocked in your account comes in with the block's status, and an address on the platform-wide block list comes in as Bounced. That way you see the contact and understand why it does not receive.

All good? Click Import N contacts. Or go to Back to mapping to adjust.

4. Result

The import starts shortly and shows its progress in rows. You can leave the screen: the result stays in Previous imports, at the bottom of the page, with when, file, who imported, status and the summary of imported, ignored and with errors.

Cancel import stops midway: what already came in stays, the rest of the spreadsheet is discarded and it cannot be resumed. To finish, import again with Skip β€” whoever already came in is ignored.

Who can import

Manager, Administrator and the account Owner. For Author and Viewer, the Import button does not show.

Where to go next

  • Custom fields β€” create the fields before importing, so the columns have somewhere to land.
  • Lists β€” the list that will receive the imported contacts.
  • Add and understand your contacts β€” each contact's status and page.

In short: download the template or use the AI instructions, link the columns, choose Update when you want existing contacts added to the lists, state the legal basis, review the problem rows and only then import β€” knowing that cancelling keeps what already came in.

Was this article helpful?