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, 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, 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
labelscolumn 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. - AI agents. Labels an AI agent 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. That export follows the filters you set there.
- API, Zapier and Make. To read contacts from an integration, use List contacts in the API. The CSV export is for people; the API is for automations.
Related
Labels
Create labels in Whatsable, apply them automatically by keyword, from ads or by an AI agent, limit them to numbers, and use them to filter, route and schedule.
Chat assignment
Whatsable routes conversations with labels and member access rather than an assignee field: keyword labels, AI agent labels, automations, and per-member numbers and labels.