Export WhatsApp Group Contacts to an Excel or CSV File

A WhatsApp group can hold hundreds of people, and WhatsApp gives you no button to save that list. The group info screen shows the members one by one, and the Export chat feature saves the conversation, not who is in it. This guide shows the ways people really get a member list into a spreadsheet: copying it by hand, using a free browser extension, and moving to a desktop app when a job is too big. The same extension also exports the people you chat with and your saved contacts.

Watch the free extension do it in 51 seconds, from choosing groups to the finished file:

What the video shows:

1. 0:00 Why copying numbers by hand wastes hours
2. 0:10 Choose your groups and what to export
3. 0:25 Export to Excel, CSV or VCF
4. 0:37 Your file, ready to use

What WhatsApp Lets You Save

WhatsApp’s help page, How to export your chat history, describes Export chat as a way to send a chat’s history out as a text file, with or without media. The page adds that the file cannot be re-imported, because it is a text file and not a backup. That file holds the messages. It is not a table of members with their phone numbers.

The group info screen does list every member, and that is where every method below starts. The problem is only that there is nowhere to click that turns the list into a file.

Method 1: Copy the List by Hand

For a small group this is fine. Open the group in WhatsApp Web, open the group info, scroll through the members and copy the names and numbers into a sheet. A committee group of 15 or 20 people takes a few minutes.

It stops being practical quickly. People you have saved appear under the name you gave them, so you often have to open each one to see the number. A community group in Dubai with 340 members, or a freelancers’ group in Manila with 120, would take hours, and copying that much by hand always leaves typing mistakes behind.

Method 2: Export with a Free Extension

The free Group Contacts Extractor & Exporter for WhatsApp Web, made by LeadTrapper, does the copying for you. It is a Chrome extension that works inside your own WhatsApp Web tab. It reads the group and member lists that WhatsApp Web has already loaded in your browser, and it builds the file on your computer. It does not send your groups, names or numbers to our servers or to anyone else. The privacy policy lists exactly what it keeps: one small counter for your daily allowance.

1. Install Group Contacts Extractor & Exporter for WhatsApp Web from the Chrome Web Store.
2. Open web.whatsapp.com and sign in with the QR code on your phone. Wait until your chats appear.
3. Click the extension icon. It opens on the Groups tab, with your groups listed with their sizes. A group whose size WhatsApp has not loaded yet shows a number as soon as you tick it.
4. Tick one group or several. You can also search the list.
5. Choose what to export: a send-ready file, without group admins, or only people who are not in your contacts. To keep one country, pick it under Only numbers from.
6. Pick Excel, CSV or VCF and click Export.

The send-ready option is the one most people want. It puts each number in international format, removes people who sit in more than one of the groups you picked, and adds the country and a WhatsApp link. The section on what is in the file shows example rows.

The free allowance is 50 contacts a day, shared by the Groups, Chats and Saved contacts tabs and counted on the day of your computer’s clock. A group of 200 people therefore takes four days, and when the allowance runs out the result screen offers our free trial instead of a file. If you would rather not wait, the WhatsApp group member extractor inside the LeadTrapper app has no daily limit.

Export Your Chats and Saved Contacts

Group members are not the only list people want. Version 1.1.0 of the extension added two more tabs next to Groups:

• Chats exports everyone you have a one-to-one chat with, including people you never saved. This is the list a small business usually means by "my WhatsApp customers": the people who messaged you about an order or a price. Groups, Status and channels are not part of this tab.
• Saved contacts exports the people in your phone's contacts who use WhatsApp, as WhatsApp Web knows them. It is a quick way to get your WhatsApp address book into a spreadsheet or a CRM.

Open the tab you want, click Export, and you get the same Excel, CSV or VCF file as for a group. The send-ready option and the country filter work here too, and the Chats tab can also keep only people who are not in your contacts. “Leave out group admins” appears only on the Groups tab, because a chat has no admins.

What Is in the File

Every export has the same columns, so a file from a group, from your chats and from your contacts can go into one sheet. These rows are made-up examples from a send-ready export of two groups:

• Name is the name you saved the person under. When you have not saved them, it falls back to the name they chose for themselves in WhatsApp.
• WhatsApp name is the profile name the person set, which helps when your saved name is a nickname.
• Group / source shows the group, or Chats or Saved contacts for the other tabs. People in two of the chosen groups get one row that lists both.
• Role says Admin or Member, and stays empty for chats and contacts.
• Business account says Yes when the person uses WhatsApp Business, which helps when you sort customers from suppliers.
• Two more columns are not shown above: WhatsApp link (a wa.me chat link, in send-ready files) and In your contacts (Yes or No).

Going the other way, from a spreadsheet into a group? The guide on how to add members to a WhatsApp group from Excel covers it, including people whose privacy settings stop you adding them.

Excel, CSV or VCF: Which File to Choose

Excel is the friendliest choice when you want to sort, filter or add notes. The extension stores phone numbers as text, so Excel does not turn 447700900101 into 4.47701E+11.

CSV is what most other tools want when you import a list into a CRM or a bulk tool. Excel opens CSV files too, and the extension has a switch that keeps long numbers as text for that case. Our guide to formatting a phone list for WhatsApp explains the leading zeros and country codes that break lists, and the free WhatsApp number formatter cleans a list that came from somewhere else.

VCF is the phone-book format. Open it on your phone or import it into Google Contacts and every person is saved with their number. Only do that for people you really want in your address book.

Why Some Members Are Missing

Newer WhatsApp versions identify some group members by an internal ID instead of a phone number. When your account can see the number, the extension finds it through WhatsApp’s own tables and your contact records. When it cannot, that person has no number to export. The extension leaves them out, counts them, and tells you how many on the result screen. It never invents a number.

Two more limits are worth knowing. You can only export groups you belong to and chats you have. And people you have saved appear under your own name for them, which the extension keeps in the Name column next to the number.

Use the List Responsibly

Someone who joined your group did not join your mailing list. WhatsApp’s terms of service ban sending impermissible communications such as bulk messaging and auto-messaging, and ban collecting information about its users in any impermissible or unauthorized manner. This is not legal advice, and rules differ between, say, Dubai, London and São Paulo, so check the ones where you and your contacts live.

The safe uses are plain ones: backing up the members of a community you run, moving customers who agreed to hear from you into a CRM, or making a list for an event you organise. If you plan to message people you have never spoken to, read our cold outreach policy guide first.

When 50 a Day Is Not Enough

The extension is built to show you what a clean export looks like. For larger jobs, LeadTrapper is a Windows app that runs on your own computer, and its group extraction has no daily limit. The same app checks which numbers are on WhatsApp with the WhatsApp Number Filter, finds business leads on Google Maps, Instagram and Facebook, and works as a WhatsApp bulk sender with delays and account warm-up built in. It costs $50 a year and starts with a 14-day free trial that needs no card.

Get LeadTrapper — $50/Year →