# Export contacts as CSV

> Download every contact of your Whatsable organization as a CSV file, with labels, notes and conversation dates in the time zone you choose. For owners and admins.

The contact export gives you every contact of your organization in one CSV file. Open it in Excel or Google Sheets to build reports, compare it with a CRM export, or keep a copy of your contact list.

## What the file contains

The file has one row per conversation: one person who wrote to two of your numbers gets two rows. A contact with no conversation yet still gets one row, with the conversation columns empty.

The columns, in this order:

| Column | What it holds |
| --- | --- |
| `name` | The contact's name, empty when there is none |
| `phone_number` | The contact's WhatsApp number, as text, so the spreadsheet keeps every digit. Empty when WhatsApp did not share the number, for a contact known only by their username |
| `note` | The note your team wrote on the contact |
| `labels` | The contact's [labels](/features/labels), sorted and separated by commas |
| `conversation_created_at` | When the conversation started. For an imported conversation, this is its oldest message |
| `note_automation` | The note your automations wrote, through Zapier, Make, n8n or the API |
| `conversation_notes` | The internal notes of the conversation, oldest first, separated by ` \| ` |
| `last_message_at` | The time of the last message, in either direction |
| `last_reply_at` | The last time the contact wrote to you |
| `last_send_at` | The last time you wrote to the contact |
| `business_number` | Your number the conversation happens on. Empty for a conversation on another channel, such as Instagram or Messenger |
| `contact_created_at` | When the contact was created |

The column names and their order do not change, so a report you build on the file keeps working. New columns, if any, are added at the end. The first four names match the export of the previous Whatsable app.

### Dates and time zones

Every date is written as `YYYY-MM-DD HH:mm` followed by its offset from UTC, for example `2026-08-03 09:05 -03:00`. You choose the time zone when you download. The offset is the one in force on that date, so summer time is handled for you.

### Opening the file

The file is UTF-8 with a byte order mark, so Excel shows accented names correctly. Phone numbers are written as text, so a spreadsheet never turns them into a number like `5.5119E12`. A text cell that starts with `=`, `+`, `-` or `@` gets a leading apostrophe, so text your contacts wrote is never run as a formula.

To keep the digits as text, `phone_number` and `business_number` are written as a small formula, `="5511987654321"`, which Excel and Google Sheets show as the plain number. A program that reads the file as raw text (a script, or a CRM import) sees that formula: remove the leading `="` and the trailing `"` to get the number.

## Download the file

**Open Settings**

Go to **Settings → Organization**.

**Open the export**

Under **Contact export**, click **Export contacts**.

**Choose the time zone**

**Time zone for the dates** starts on your browser's time zone. Pick another one if your report needs it.

**Download**

Click **Download CSV**. The file is named `contacts-YYYY-MM-DD.csv`, after the day you download it in the time zone you chose.

A large contact list takes longer to prepare. The file is built as it is read, so the export does not stop at a fixed number of contacts.

## Who can export

- **Owners and admins** see **Contact export** and can download the file, on any paid plan.
- **Members** do not see it and cannot download it. That includes a member [limited to certain labels or numbers](/features/chat-assignment), because the file holds contacts that member may not see.

Each download is recorded with the person who made it, the time, and the number of contacts. The record never holds contact data.

## How it works with other features

- **Labels.** The `labels` column lists every label on the contact, including labels an AI agent or a keyword applied. Filter the spreadsheet on a label to count, for example, the contacts who finished a conversation with your AI agent. See [Labels](/features/labels).
- **AI agents.** Labels an [AI agent](/features/ai-chatbot) applies show up in the file like any other.
- **Inbox export.** To export the conversations of one inbox view instead, with the last messages of each thread, use **Export conversations** in the [inbox](/features/inbox-conversations#export-conversations). That export follows the filters you set there.
- **API, Zapier and Make.** To read contacts from an integration, use [List contacts](/api-reference/v1/contacts/list-contacts) in the API. The CSV export is for people; the API is for automations.

## Related

- [Labels](/features/labels)
- [Team roles](/features/team-roles)
- [Route chats to the right teammate](/features/chat-assignment)