How-to guide

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 WhatsApp

Export WhatsApp group contacts to Excel in 5 steps (free)

  1. 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. 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. 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. 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. 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

What you get: saved names, numbers and hidden members

WhatsApp shows a group member in one of three ways, and that decides what ends up in your Excel sheet. These are the rules on WhatsApp Web today. WhatsApp changes its screens from time to time, so a label may move or read slightly differently.

Group members on WhatsApp Web and what a copy gives you
How the member appearsWhat the copied text hasIn your Excel file
Saved in your phone (e.g. “Ravi Mama”)Your saved name only, no numberNot listed. The number is already in your contacts (see below)
Not saved: +91 98765 43210 ~SunitaThe number and their WhatsApp name+919876543210 with the name Sunita
Not saved, no WhatsApp nameThe number only+919876543210 with no name (you can label it, e.g. “Parent 001”)
Community announcement group, you are not an adminNames only. WhatsApp hides members’ numbers from other membersNot listed. Only admins can see these numbers
Member using a username or privacy featureMay show without a numberNot listed
You“You”Not listed

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.

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”):

  1. 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.

  2. 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.

  3. 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. 📸

  4. 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.

  5. 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 की ज़रूरत नहीं है।

  1. 6

    कंप्यूटर पर ग्रुप खोलें

    web.whatsapp.com या WhatsApp डेस्कटॉप ऐप खोलें, फ़ोन से QR कोड स्कैन करें और ग्रुप खोलें।

  2. 7

    Group info → View all

    ऊपर ग्रुप के नाम पर क्लिक करें, फिर मेंबर लिस्ट के नीचे “View all” दबाएँ।

  3. 8

    लिस्ट कॉपी करें

    माउस से पूरी लिस्ट सेलेक्ट करके Ctrl+C दबाएँ। बड़ा ग्रुप हो तो थोड़ा-थोड़ा स्क्रॉल करके हिस्सों में कॉपी करें।

  4. 9

    Excel डाउनलोड करें

    फ़्री phone number extractor में पेस्ट करें। सारे नंबर +91 के साथ आ जाएँगे, डुप्लिकेट हट जाएँगे। Excel, CSV या VCF डाउनलोड करें।

Frequently asked questions

How can I export WhatsApp group contacts to Excel for free?

Open the group on WhatsApp Web, click the group name, click “View all” under the members, select the list and copy it. Paste it into the free phone number extractor on Rapid Sender and download Excel. It adds +91 and removes duplicates. You do not need an extension or a paid app.

Can I export WhatsApp group contacts to Excel with names?

Yes, for members not saved in your phone: WhatsApp shows their number with their WhatsApp name after a ~, and the extractor puts that name next to the number. Members you have saved show only your saved name. Export those from Google Contacts or iCloud, where both the name and number are.

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.

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.

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.

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.

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 डाउनलोड करें। जो नंबर आपके फ़ोन में सेव हैं वे सिर्फ़ नाम से दिखेंगे।

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