Export your contacts

You can export your contacts whenever you like, from the Panel. You get one zip with every contact, their permissions with their proof, the entities, the addresses never written to again and the history.

Exporting needs the holder or the level “Edit and send”. It works while Email is paused too.

Export your contacts

1. In Contacts, open “People”.
2. Press “Export”. The zip downloads: “The export is in your downloads.”

To export only some, search, add conditions or apply a list first. The button then says how many it exports.

Export one contact

1. Open the contact’s page.
2. Press “Export this contact”.

It holds their details, their permissions and their whole history. Use it when a person asks to see what you keep about them.

What is in the zip

The zip’s name has the day it was made.

File	What it holds
contacts.csv	One row per contact: their details, entity, category, tags, and the website they came from
permissions.csv	Each contact’s permission for each purpose, with its proof
entities.csv	The entities, with their category, website, address and description
suppressions.csv	The addresses never written to again, for one purpose or for all, with the reason and the date
history.csv	What happened to each contact, newest first
about.txt	What each file holds, in your language

When you export only some contacts, entities.csv and suppressions.csv hold only theirs. One contact’s zip has no entities.csv or suppressions.csv.

The history never holds what anyone opened or clicked.

The columns

File	Columns
contacts.csv	id, email, first_name, last_name, language, phone, entity, position, joined_at, left_at, category, tags, origin, created_at, updated_at
permissions.csv	person_id, email, purpose, state, basis, source, at, left_at, by, note, file_name, opt_in_at, confirmed_at
entities.csv	id, name, category, website, address, description, created_at, updated_at
suppressions.csv	email, scope, reason, at
history.csv	person_id, email, kind, data, by, at

A few of them:

• category is the contact’s own category, or else their entity’s.
• origin is the website they came from, written website: and its id.
• by is who declared the permission, and note how and when they gave it.
• file_name, opt_in_at and confirmed_at come from the file, when the permission was imported.
• scope is a purpose’s name, or all.
• data holds the details of each history entry, in JSON.

How to read them

• They are CSV files in UTF-8: commas between values, and a first row naming each column. Any spreadsheet opens them.
• The column names are in English, whatever your language.
• Times are in UTC, written year-month-day and then the hour.
• Tags are separated by semicolons.
• A value starting with =, +, - or @ begins with an apostrophe, so a spreadsheet does not read it as a formula. A number, such as a phone, is left as it is.

In the copy of your account

The copy of your account holds the same files, in the folder services/contacts/. Read Download a copy of your account.