WhatSyncHow to export WhatsApp group members and numbers to Excel
WhatsApp has no button to download a group's members. Three ways to get them into Excel: copy them by hand, turn a group export into a spreadsheet for free, or ask your AI for the full member list.
· 4 min read
The quick answer
You want a WhatsApp group's members in a spreadsheet. WhatsApp has no button for it.
Pick by group size:
- A few members: copy them from the group info screen by hand.
- Free, from a group export: our [group numbers to Excel](/tools/whatsapp-group-numbers-to-excel) tool lists everyone who wrote, joined or left.
- Every member: ask your AI through [WhatSync](/whatsapp-mcp): "List the members of my group as a table."
The three ways side by side
| Decision | By hand | Group export tool | Your AI with WhatSync |
|---|---|---|---|
| Cost | Free | Free | Free trial, then a paid plan |
| Quiet members who never wrote | Yes | Only if added or joined during the export | Yes |
| Numbers of saved contacts | Yes, from your contacts | Name only | Yes, where WhatsApp shares them |
| Numbers of people not saved | Yes | Yes | Yes, where WhatsApp shares them |
| Time for a 200-person group | An hour or more | About a minute | About a minute |
| Install anything | No | No | Add WhatSync to your AI app |
1. Copy the members by hand
Fine for a small group, slow for anything over 20 people.
- Open the group and tap its name at the top.
- Scroll to the member list and tap View all.
- Write each name and number into your spreadsheet. Tap a person to see their number if only a name shows.
2. Turn a group export into a spreadsheet, free
Every WhatsApp group can be exported as a text file. It mentions everyone who wrote, everyone added, everyone who joined with a link, and everyone who left or was removed. Our free tool reads that file in your browser and gives you an Excel file.
- In WhatsApp, open the group. On iPhone tap the group name, then Export Chat. On Android tap the three dots, More, then Export chat.
- Choose Without media and save the file.
- Drop it into group numbers to Excel.
- Download the Excel or CSV file: name, phone number, country, status and number of messages for each person.
What the export cannot show
People saved in your contacts appear by name, not number, because that is how WhatsApp writes the export. Members who never wrote and joined before the start of your export are not in the file at all.
3. Ask your AI for the full member list
WhatSync links your WhatsApp to ChatGPT, Claude or any AI agent. Your AI can then read a group's current member list straight from WhatsApp, including the quiet members an export misses.
Once it is set up, ask: "List every member of my Weekend hikers group as a table with name, number and whether they are an admin." Copy the table into Excel or Google Sheets, or ask for it as CSV text.
WhatsApp lets people hide their number in some groups and communities. Those members show without a number, in any tool.
What to do with the list
- Clean up the numbers into the international format WhatsApp needs: number formatter.
- Message people one by one with their name filled in: bulk message planner.
- Only message people who agreed to hear from you. Messaging strangers from a group gets numbers reported and banned.
Questions
- Can I export WhatsApp group members to Excel?
- Not from WhatsApp itself. Export the group chat and drop the file into a free tool like ours to get an Excel file, or ask your AI for the member list through WhatSync.
- How do I get all phone numbers from a WhatsApp group?
- The group info screen lists every member. A group export only has numbers for people not saved in your contacts and who show up in the chat. For every member at once, ask your AI through WhatSync.
- Why does the export show names instead of numbers?
- WhatsApp writes saved contacts by the name you gave them. Their numbers are already in your phone's contacts.
- Can I see hidden numbers in a WhatsApp group?
- No. If WhatsApp hides someone's number from you, no export, tool or extension can show it.
- Is it safe to use an extension to download group contacts?
- An extension that reads WhatsApp Web can see all your chats. The export tool here runs in your browser on a file you choose, and nothing is uploaded.
Sources
WhatsApp and WhatSync features were checked on November 11, 2026.
- WhatsApp Help Center: export your chat history: How to export a chat on iPhone and Android.
- WhatSync WhatsApp MCP server: Setup for each AI app and the full tool list.
Keep reading
Ask your AI about your WhatsApp
Add WhatSync to Claude, ChatGPT or any AI agent, link your WhatsApp, and pick the chats and groups it can read. Then just ask.