Guides

How to Export WhatsApp Contacts and Group Members to CSV

WhatsApp Web has no built-in export. Here is what data is actually available to export, how browser extensions read it, which CSV columns are worth keeping, and the privacy rules that apply once the file exists.

Key takeaways

  • WhatsApp Web has no native export function; every export path relies on reading the data already loaded in the interface.
  • Group member exports are limited to groups you are a member of, and admin-only member lists stay hidden.
  • Phone number, display name, and group role are reliable columns; profile photos and status text often are not.
  • Open exported CSVs with an explicit UTF-8 import step or non-Latin names and emoji will be mangled.
  • An exported contact list is personal data — consent, storage, and deletion obligations follow the file wherever it goes.
What it contains
  1. Key takeaways
  2. What Data Is Actually Available
  3. Exporting Contacts
  4. Exporting Group Members
  5. Getting a Clean File
  6. What You May Do With the File
  7. A Practical Workflow
  8. Frequently asked questions

WhatsApp Web has no export button. There is no menu item that produces a contact list, no way to download group members, and no supported API for a personal account. Every working export method reads the data your own session has already loaded and writes it to a file locally.

That constraint shapes what is possible. This article covers what data is genuinely available, how to get a clean CSV out of it, and the obligations that attach to the file the moment it exists.

What Data Is Actually Available

When WhatsApp Web loads, it populates an in-memory store of the entities your account can see. An extension running on the page can read that store. It cannot read anything your account cannot already see.

Reliably available:

  • Phone number in international format
  • Display name — the contact’s saved name if you have one, otherwise their WhatsApp push name
  • Whether the number is a saved contact
  • Whether the account is flagged as a business account
  • Group name and group ID for groups you are in
  • Group membership, including admin and super-admin roles

Partially available or unreliable:

  • Profile photo URLs, which expire and are frequently absent
  • Status or “about” text, subject to the contact’s privacy settings
  • Last-seen timestamps, hidden by default for most users
  • Email or any other contact channel — WhatsApp simply does not hold it

Never available:

  • Members of groups you do not belong to
  • Contacts of your contacts
  • Anything from a group whose admins have restricted the member list

If a tool advertises data from the third list, that claim is false regardless of how the tool is built.

Exporting Contacts

The mechanics are the same across tools: open WhatsApp Web, let the chat list fully sync, then run the export.

The important preliminary step is letting the sync finish. WhatsApp Web loads chats progressively as you scroll. Exporting immediately after connecting produces a partial list containing only the most recent conversations. Wait until the chat list stops changing, and scroll to the bottom of the list once, before exporting.

In WAPlus, contact export lives under the sync section: it reads the synced contact store and writes a CSV or XLSX locally in your browser. No contact data is uploaded anywhere — the file is generated in the page and saved through the browser’s normal download flow.

Columns worth keeping:

ColumnWhy it matters
phoneThe join key for every other system you own
nameDisplay name for personalization tokens
is_contactDistinguishes saved contacts from inbound-only numbers
is_businessUseful for segmenting B2B from B2C
is_my_contact_groupWhich groups, if you are exporting membership too

Drop the rest. Profile photo URLs expire, and status text is rarely worth the column.

Exporting Group Members

Group export is the more common need, usually for one of two reasons: migrating a community to a new platform, or building a segmented list from a group whose members opted in.

The process differs in one important way — you must open the group first. Member data for a group loads when the group is opened, not when the app starts. Exporting a group you have never opened in this session often returns an empty or partial member list.

A group member export typically includes the phone number, display name, and role (member, admin, super-admin). The role column is more useful than it looks: admins are usually the people who actually run the community and are the right first contacts for any migration.

Group export limits to know about:

  • Very large groups may need a moment after opening before the full member list is present.
  • Members who left are gone; there is no historical membership record.
  • If the group is set to hide member details, you get what the interface shows and nothing more.

Getting a Clean File

Two problems account for nearly every broken export.

Encoding. Names contain emoji, Arabic, Devanagari, Chinese, accented Latin. If the CSV is UTF-8 and Excel opens it as Windows-1252, every one of those becomes mojibake. Fix: in Excel use Data → From Text/CSV and explicitly select UTF-8 rather than double-clicking the file. Google Sheets and LibreOffice detect it correctly on their own.

Number formatting. A phone number like +8801712345678 will be interpreted as a number and rendered in scientific notation, silently destroying it. Fix: import the phone column as Text, not General. If you control the export, a leading + and quoting the field both help.

After import, run a quick sanity pass:

  1. Row count matches roughly what you expected.
  2. No blank phone numbers.
  3. Numbers all carry a country code.
  4. Deduplicate on the phone column — the same person can appear in several groups.

What You May Do With the File

This is the part that gets skipped, and it is the part with consequences.

A phone number is personal data. Under GDPR, the UK DPA, Brazil’s LGPD, and a growing list of similar laws, an exported list of numbers is a processing activity that needs a lawful basis. Being in a group is not consent to be marketed to — people joined a community, not a mailing list.

Practical obligations that follow the file:

  • Purpose limitation. Use the list for the purpose the data was shared for. Migrating a group to a new platform is defensible. Cold-selling an unrelated product is not.
  • Storage. The file is now a sensitive asset. Keep it in a controlled location, not a shared Downloads folder or an email attachment.
  • Retention. Delete it when the purpose is served. An exported CSV sitting on a laptop for two years is a liability with no upside.
  • Deletion requests. If someone asks to be removed, you must be able to remove them from every copy — which is a good reason not to have many copies.
  • Transparency. If you contact people from an exported list, say how you got their number. It is required in many jurisdictions and it markedly reduces spam reports either way.

A Practical Workflow

  1. Open WhatsApp Web and let the chat list fully sync.
  2. Open the specific groups you intend to export.
  3. Export contacts and group members to CSV.
  4. Import into a spreadsheet as UTF-8 with the phone column typed as Text.
  5. Deduplicate on phone number.
  6. Remove anyone who has previously opted out.
  7. Store the file somewhere access-controlled and set a deletion date.

Step 6 is the one people forget, and it is the one that causes an opted-out contact to receive another campaign — which is the fastest route to a spam report.

Related reading: How to Send Bulk WhatsApp Messages Without Getting Your Number Banned explains what to do with a cleaned list once you have one.

Frequently asked questions

Can I export my WhatsApp contacts to Excel?

Not with WhatsApp's own features. Browser extensions running on WhatsApp Web can read the contact and group data already loaded in your session and write it to a CSV file that Excel opens. Import it as UTF-8 so non-Latin characters survive.

Is it legal to export WhatsApp group members?

Exporting is generally permitted for groups you belong to, but what you do next is regulated. Under GDPR and similar laws, phone numbers are personal data; using them to send marketing messages requires a lawful basis, and consent to be in a group is not consent to be marketed to.

Why does my exported CSV show broken characters?

Excel defaults to a legacy encoding when a CSV is opened by double-click. Use Data then From Text/CSV and select UTF-8, or open the file in Google Sheets, which detects UTF-8 automatically.

Can I export members of a group I am not in?

No. The data only exists in your session for groups you belong to. Any tool claiming otherwise is either wrong or describing something that does not work.