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:

ColumnWhat it holds
nameThe contact's name, empty when there is none
phone_numberThe 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
noteThe note your team wrote on the contact
labelsThe contact's labels, sorted and separated by commas
conversation_created_atWhen the conversation started. For an imported conversation, this is its oldest message
note_automationThe note your automations wrote, through Zapier, Make, n8n or the API
conversation_notesThe internal notes of the conversation, oldest first, separated by |
last_message_atThe time of the last message, in either direction
last_reply_atThe last time the contact wrote to you
last_send_atThe last time you wrote to the contact
business_numberYour number the conversation happens on. Empty for a conversation on another channel, such as Instagram or Messenger
contact_created_atWhen 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 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.
  • 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.

On this page