> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lekalao.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Import and export

> Bring an existing list in, and take a copy out.

## Importing

The **Imports** tab of a list.

<Steps>
  <Step title="Drop the file">
    Drag in a **CSV**, **TXT** or **XLSX** file of 20 MB at most. The first row must hold the column headers.
  </Step>

  <Step title="Match the columns">
    Lekalao recognises the usual headers and suggests a target for each column:

    | Target             | Headers recognised                             |
    | ------------------ | ---------------------------------------------- |
    | E-mail address     | email, e-mail, mail, courriel, adresse e-mail… |
    | First name         | first name, firstname, prénom…                 |
    | Last name          | last name, surname, nom, nom de famille…       |
    | Tags               | tags, tag, labels, étiquettes                  |
    | Time zone          | timezone, tz, fuseau, fuseau horaire           |
    | Language           | locale, language, lang, langue                 |
    | Attribute          | any other column, under the name you choose    |
    | Ignore this column | the column is not imported                     |

    One column has to hold the e-mail address.
  </Step>

  <Step title="Choose the options">
    * **Tags added to everyone in this file**;
    * **Replace existing tags** of the subscribers already there, instead of adding to them;
    * **Subscribe again people who unsubscribed** who appear in the file (unticked by default: someone who left stays away, and their line is flagged in the report).
  </Step>

  <Step title="Start it">
    The import runs in the background; the page shows how far it has got. At the end: added, updated, failed, with an **error report you can download**, line by line.
  </Step>
</Steps>

### What an import does

* An address that is already there is **updated**: the fields filled in the file overwrite those on the record, and the attributes are merged.
* An address on the **suppression list** is refused.
* Imported people are subscribed **without a confirmation e-mail**: an import assumes consent was gathered elsewhere. It is recorded as such in the consent log.
* The tags column takes several values separated by `,`, `;` or `|`.
* The language column takes `fr`, `FR`, `fr_FR`, `pt-BR`, or the name of the language (`Français`, `French`, `Deutsch`).
* Automations triggered by "someone subscribes" start for the new subscriptions.

<Warning>
  Your plan's subscriber allowance applies. If it runs out part-way, the
  import stops and is marked **failed**; the lines already handled stay
  imported. Move up a plan or make room, then import the rest of the file.
</Warning>

## Exporting

The **Exports** tab of a list. Choose what to export: every active subscriber, one status, or a segment. **Start the export** prepares a CSV file in the background; it appears in the list, ready to download.

The file holds: address, first name, last name, time zone, language, status, tags, subscription and unsubscription dates, then one column per custom attribute.

<Info>
  Exported files are deleted automatically after **7 days**.
</Info>