How to export WhatsApp group contacts to Excel for free
To export WhatsApp group contacts to Excel for free, open the group on WhatsApp Web or the desktop app, click the group name, click “View all” under the members, select the list and copy it. Paste it into the free phone number extractor and download an Excel, CSV or VCF file with every number in +91 format, duplicates removed. No Chrome extension and no paid app. WhatsApp only shows the numbers of members you have not saved, though. For saved contacts you get their saved name, and the number is already in your phone contacts.
Updated · Free · No install · Works with your own WhatsAppExport WhatsApp group contacts to Excel in 5 steps (free)
- 1
Open the group on a computer
Open web.whatsapp.com in Chrome, Edge or Safari, or the WhatsApp desktop app, and link your phone (WhatsApp on the phone → Linked devices → Link a device → scan the QR code). WhatsApp Business works the same way. Then open the group.
- 2
Open Group info
Click the group name at the top of the chat. The Group info panel opens on the right with the member count, for example “148 members”.
- 3
Show every member
Under the first few members, click “View all” (it may say “View all (138 more)”). A window opens with the full member list.
- 4
Select and copy the list
Click just before the first member, hold the mouse button down and drag to the bottom of the list, then press Ctrl+C (Cmd+C on a Mac). For a big group, WhatsApp only loads the rows on screen, so copy one screenful, scroll down, copy the next part and paste each part one after the other. Repeated members are removed later.
- 5
Paste and download
Paste everything into the phone number extractor. It picks out every mobile number, adds +91, removes duplicates and keeps the WhatsApp name shown after the ~ sign. Download Excel (.xlsx), CSV or Contacts (.vcf).
Paste the copied member list here: Open the free phone number extractor
Try it with your own list
Upload an Excel or CSV file, write your message and see exactly how it looks before anything is sent.
Getting the numbers of saved members, with their names
For members you have saved, the copy only gives their name. You do not need WhatsApp for these numbers, because they are already in your phone contacts. If your phone syncs contacts to Google (most Android phones do), open contacts.google.com on a computer, select the people you need (or a label), click Export and choose Google CSV. Open the CSV in Excel and you have their names and numbers.
On an iPhone, contacts are usually in iCloud: open icloud.com/contacts, select the contacts, and choose Export vCard. Then convert the .vcf file to Excel with the free VCF to Excel tool.
Then put both lists in one sheet: the unsaved members from the extractor and the saved ones from your contacts. The contact list cleaner removes the numbers that appear twice and fixes +91, spaces and leading zeros.
Have a .vcf file from your phone or iCloud? Convert VCF to Excel
Export as CSV or VCF instead of Excel
Excel (.xlsx): one row per member, with Name, Phone (+91…) and the number without the code in a third column. Numbers are stored as text, so Excel does not turn +919876543210 into 9.19877E+11.
CSV: the same list as plain text. Choose this for Google Sheets, a CRM, or any app that asks for a CSV. Google Contacts also imports it.
VCF (contacts file): open it on your phone and every member is saved to your contacts in one go. Members without a name get a label you choose, like “Society 001”. Saving numbers is optional, though: Rapid Sender can message a list without saving anyone first.
Already have an Excel sheet and want contacts? The Excel to VCF tool does the reverse.
From your phone only (Android or iPhone)
The WhatsApp phone app does not let you select or copy the member list. You have two free choices:
Export the chat. Android: open the group → ⋮ → More → Export chat → Without media. iPhone: tap the group name → Export Chat → Without Media. Open the .txt (or the iPhone .zip) in the phone number extractor. You get every unsaved member who has written in the group, plus any numbers people shared in messages (delete the ones that are not members). Members who never wrote anything are not in the chat file.
Use WhatsApp Web on a tablet or a second phone. Open web.whatsapp.com (in Chrome on a phone, tap ⋮ → Desktop site), then on your main phone go to Linked devices → Link a device and scan the code. Some versions let you link with your phone number instead. Then follow the 5 steps above: long-press a name to start selecting and drag the handle down. It is fiddlier than with a mouse, so copy in small parts.
Why not a Chrome extension?
Most results for this search are Chrome extensions that export group members. Before you install one, know what it can do:
An extension that runs on WhatsApp Web can read every chat, message and contact in your account, not just the group you want. You cannot check what it sends to its own servers.
Many are free for the first few contacts and then ask you to pay, or ask you to sign in with Google and accept wide permissions.
Extensions that scrape or automate WhatsApp Web go against WhatsApp’s terms, and accounts that use them can be limited. Extensions are also removed from the Chrome Web Store from time to time, and one that is sold to a new owner can change what it does after an update.
The copy-and-paste method above uses only WhatsApp’s own screen. The extractor runs in your browser, so the list you paste is not uploaded anywhere.
Before you message the members: consent
A group number is not permission to message someone privately. Message only people who know you and expect to hear from you: your own society, class parents, team, club or customer group, for something related to that group. A personal message from a stranger who found a number in a big group gets blocked and reported. WhatsApp limits or bans numbers that are reported often.
A good first message says who you are, which group you know them from, and why you are writing. It also lets them opt out. Group admins: tell the group first, e.g. “I’ll send each of you your fee receipt / seat number personally.”
Send each member a personal message by name with Rapid Sender
Once the members are in Excel, open the sheet in the Rapid Sender bulk sender. It sends every person their own chat from your own WhatsApp, one by one. It is not a group post and not a broadcast, so nobody sees the others’ numbers, and you do not need to save the numbers first. {{name}} puts each person’s name in the text, and you can attach a photo or PDF, even with their name printed on it. The first 50 messages are free; after that, packs start at ₹149 for 250 messages.
Ready messages for people from a group (copy, or press “Send to your list”):
- Society
Namaste {{name}} 🙏 This is Priya Shah, secretary of the Shree Residency residents group. The annual general meeting is on Sunday, 6 December 2026 at 10 am in the society hall. Please reply YES if you can come.
- School parents
Dear {{name}}, this is Mrs. Mehta, class teacher of 5B. You are in our class parents group. I will send each child’s report and PTM time to you personally here. Reply STOP if you would rather get them in the group.
- Event guests
Hi {{name}}, thank you for being part of the Sharma family wedding group! The photos are ready. Reply PHOTOS and we will send your album here. 📸
- Customers
Hello {{name}}, this is Rakesh from Shiv Electricals. You are in our offers group. Our year-end sale runs until 31 December 2026. Reply here for prices, or STOP and I won’t message you again.
- Hindi
नमस्ते {{name}} जी 🙏 मैं सोसाइटी ग्रुप से अनिल बोल रहा हूँ। मेंटेनेंस की रसीद आपको अलग से यहीं भेज रहा हूँ, कृपया देख लें। कोई सवाल हो तो इसी चैट में पूछें।
Want to add these people to another group instead? Add contacts from Excel to a WhatsApp group
व्हाट्सएप ग्रुप के नंबर Excel में कैसे निकालें (Hindi)
ध्यान दें: जो नंबर आपके फ़ोन में सेव हैं, वे लिस्ट में सिर्फ़ नाम से दिखते हैं। उनके नंबर आपके कॉन्टैक्ट्स (Google Contacts) में पहले से हैं। किसी Chrome extension की ज़रूरत नहीं है।
- 6
कंप्यूटर पर ग्रुप खोलें
web.whatsapp.com या WhatsApp डेस्कटॉप ऐप खोलें, फ़ोन से QR कोड स्कैन करें और ग्रुप खोलें।
- 7
Group info → View all
ऊपर ग्रुप के नाम पर क्लिक करें, फिर मेंबर लिस्ट के नीचे “View all” दबाएँ।
- 8
लिस्ट कॉपी करें
माउस से पूरी लिस्ट सेलेक्ट करके Ctrl+C दबाएँ। बड़ा ग्रुप हो तो थोड़ा-थोड़ा स्क्रॉल करके हिस्सों में कॉपी करें।
- 9
Excel डाउनलोड करें
फ़्री phone number extractor में पेस्ट करें। सारे नंबर +91 के साथ आ जाएँगे, डुप्लिकेट हट जाएँगे। Excel, CSV या VCF डाउनलोड करें।
Frequently asked questions
How do I export WhatsApp group contacts to CSV or VCF?
Follow the same steps and choose CSV or Contacts (.vcf) instead of Excel when you download. CSV is for Google Sheets, Google Contacts or a CRM. VCF saves all the members to your phone contacts in one go.
Can I export group contacts from WhatsApp Business?
Yes. The WhatsApp Business app links to WhatsApp Web and the desktop app in the same way, and Group info → View all works the same. The steps on this page apply to both apps.
Can I export WhatsApp group contacts on Android without a computer?
Not from the member list, because the phone app does not let you copy it. Export the group chat instead (⋮ → More → Export chat → Without media) and open the .txt file in the phone number extractor. You get the unsaved members who wrote in the group. Or open WhatsApp Web on a tablet or a second phone.
Why are some members missing from my Excel file?
Saved contacts appear by name, not number. In a community announcement group, WhatsApp hides members’ numbers from everyone except admins. In a big group, only the rows on screen are copied, so scroll and copy the rest in parts. Members using a username or similar privacy feature may also appear without a number.
Is it safe to use a Chrome extension to export WhatsApp group members?
Be careful. An extension on WhatsApp Web can read all your chats and contacts, and many charge after the first few contacts. Scraping tools also go against WhatsApp’s terms. Copying the list yourself and pasting it into a tool that runs in your browser avoids all of that.
व्हाट्सएप ग्रुप के सभी नंबर एक साथ कैसे कॉपी करें?
WhatsApp Web पर ग्रुप खोलें, ग्रुप के नाम पर क्लिक करें, “View all” दबाएँ और पूरी मेंबर लिस्ट सेलेक्ट करके कॉपी करें। फिर उसे phone number extractor में पेस्ट करके Excel डाउनलोड करें। जो नंबर आपके फ़ोन में सेव हैं वे सिर्फ़ नाम से दिखेंगे।
Can I message all group members privately at once?
Yes, with Rapid Sender: open the Excel list in the bulk sender and each member gets their own message from your WhatsApp, with {{name}} replaced by their name. Message only people who know you and expect it. The first 50 messages are free.
Ready to send your message?
Upload your list, write your message and connect your WhatsApp. It is free and takes a few minutes.
Start sending