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

# Import and export customers

> Bring in a customer list from an Excel or CSV file, match its columns to customer fields, and download your customers as a file.

Have a contact list in Excel or another app? You don't need to add people one at a time — import the whole file from the **Customers** page.

## Importing contacts

**1. Upload your file**

From **Customers**, click **Import Contacts**, then **Add Import**, and upload a **CSV or XLSX** file (up to 30 MB).

![Upload step of the import wizard with a Before you upload checklist and a drag-and-drop file area accepting CSV or XLSX up to 30 MB](https://docs.chatflows.io/contacts/img/import-upload.png)

Image shows the upload step with the before-you-upload checklist and file drop area.

Not sure how your file should look? Click **Download sample CSV** on this step to get a ready-made example.

Your file needs a **header row** as the first row, and phone numbers must include the **country code** (for example `+9198******`). If a phone number already belongs to a customer, you choose what happens on the last step.

**2. Map your columns**

ChatFlows reads your file's headers and suggests a mapping to contact fields automatically. Review and adjust the mapping — including your own [customer fields](https://docs.chatflows.io/core-setup/custom-fields.md) — before continuing.

![Map Columns step showing a preview of the first rows of the uploaded file above dropdowns matching each file column to a contact field, with Phone and First Name marked required](https://docs.chatflows.io/contacts/img/import-map-columns.png)

Image shows the Map Columns step with a file preview and field mapping dropdowns.

**3. Set Default Values and start the import**

First, choose what happens when a phone number already belongs to a customer:

* **Skip the row** — the existing customer stays as it is. The row is listed as skipped. This is the default.
* **Update the existing contact** — the customer is updated with the columns from your file and the default values below. Groups and labels are added, never removed.

Updating an existing customer doesn't use any of your room for new contacts.

Then set the **status**, **source**, **group(s)**, **label(s)**, **WhatsApp channel**, and **assigned team member**. These values are applied to **every** contact in this file — they cannot come from the file itself. Then choose **Start Import**. The import runs in the background, so large files don't block you from continuing to use the app.

If your file has more rows than you have room for, ChatFlows warns you here and imports only what fits. The extra rows are reported as failed.

![Default Values step showing an import summary of the column mapping, a note confirming how many rows were detected and how many contact slots remain, the If a phone number already exists choice with Skip the row selected, and default fields for channel, type, status, source, assignee, groups, and labels](https://docs.chatflows.io/contacts/img/import-default-values.png)

Image shows the Default Values step with the import summary and default field settings.

> [!NOTE]
>
> Some defaults are **required** — the WhatsApp channel, type, status, and source must be set before you can start the import.

## Tracking an import

![Import Contacts page listing past imports with the file name, a progress bar showing rows processed with counts of imported and skipped rows, a Completed status, and the date](https://docs.chatflows.io/contacts/img/import-history.png)

Image shows the Import Contacts page listing past imports with their progress.

Each import you run is listed with its status and progress. Open one to:

* See how many rows were imported, updated, skipped, and failed.
* **Download Failed Rows CSV** — a file listing the rows that failed and why.
* **Download Original File** — the file you uploaded.
* **Delete** a single import record, or **bulk-delete** several at once. This only removes the import history entry — contacts already created by that import are not deleted.

> [!WARNING]
>
> Failed row details are kept for **30 days**. Download the Failed Rows CSV before they are removed.

## Exporting contacts

From the **Customers** page, apply the filters you want — **type**, [status](https://docs.chatflows.io/core-setup/statuses.md), [source](https://docs.chatflows.io/core-setup/sources.md), **active**, **assignee**, or [channel](https://docs.chatflows.io/core-setup/channels/whatsapp.md) — or type in the search box, then click **Export** to download exactly that filtered list as a file.

You can also select specific contacts in the list. When contacts are selected, **Export** downloads only those rows.

## What's next

> [card] [Managing customers](https://docs.chatflows.io/contacts/managing-contacts.md)
>
> Browse, create, and edit contacts individually.

> [card] [Bulk Actions & Merge](https://docs.chatflows.io/contacts/bulk-actions-and-merge.md)
>
> Clean up and organize contacts after a large import.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.