How to export WhatsApp group contacts to Excel

Before you start: two rules for every method

• You must be a member of the group. No method can read the member list of a group you have not joined. You do not need to be an admin.
• You get what WhatsApp shows you. In regular groups, members' numbers are visible to other members. In community announcement groups WhatsApp hides most members' numbers (why a member's number isn't showing).

Method 1: Copy from Group info (small groups, no install)

1. Open the group on your phone or in WhatsApp Web and tap or click the group name.
2. Open the member list (tap View all if it is collapsed).
3. Type each name and number into Excel: names in column A, numbers in column B.
4. Before entering numbers, format column B as Text (Ctrl+1 → Text). Otherwise Excel may drop the +, drop leading zeros, or show long numbers in scientific notation.

Good for a dozen people. Slow and error-prone beyond that.

Method 2: Export the chat and list who posted (active groups, no install)

WhatsApp's Export chat saves the conversation as a text file. Every message line includes the sender, so you can build a list of people who have posted.

1. On your phone, open the group → menu → More → Export chat → Without media (Android), or tap the group name → Export Chat → Without Media (iPhone).
2. Open the .txt file on your computer, copy everything and paste it into column A of a blank sheet.
3. Pull the sender into column B with a formula. In Excel for Microsoft 365, for Android-style lines (date, time - Name: message) try =IFERROR(TEXTBEFORE(TEXTAFTER(A1," - "),": "),""); for iPhone-style lines ([date, time] Name: message) replace " - " with "] ". Adjust the separators to match your file, then use Data → Remove Duplicates.

Limits: members who never posted will not appear, and saved contacts appear by your saved name, not by number. The file also contains message text, so delete it once you have the list.

Method 3: Download visible members to Excel with a Chrome extension (large or repeat exports)

WA - Download Group Phone Numbers runs on WhatsApp Web in desktop Chrome and downloads an Excel (.xlsx) workbook.

1. Install the extension in desktop Chrome, open WhatsApp Web and sign in.
2. Click the extension icon in the Chrome toolbar. In Choose this first, pick From groups.
3. In Choose this next, select one group, several groups, or All groups.
4. Tick the columns you need. Phone number and country code are always included. Optional columns include saved name, public display name, business account, source name, saved-contact status, labels, past participants, pending requests and last-message details.
5. Tick Include admins if you want group admins in the file. They are left out otherwise.
6. Click download. The free trial download includes the first 10 contacts so you can check the file; the full list needs a paid plan ($7.99/month, or a one-time 30-day or 6-month pass).
7. Open the .xlsx file in Excel or Google Sheets.

Step-by-step product page: download WhatsApp group numbers to Excel.

Check that the list is complete

Compare the number of rows with the member count in Group info. If you have fewer:

• Admins are missing: export again with Include admins ticked.
• Large group: let the participant list finish loading in WhatsApp Web, then export again.
• Community announcement group: some numbers are not visible to you at all. That is expected.

Need CSV, vCard or Google Contacts?

The extension downloads an Excel (.xlsx) workbook, not a direct CSV file. For CSV, open the workbook in Excel and use File → Save As → CSV UTF-8, keeping phone columns as Text. CSV stores one sheet and does not preserve workbook formatting, so keep the original workbook and test a small batch before importing into a CRM. For your phone's address book, import the CSV into Google Contacts. See import WhatsApp group contacts into Google Contacts and save group members as CSV.

Which method should you use?

Want the short answer and a side-by-side of Chrome extensions? See the best way to export WhatsApp group contacts.

Fields worth reviewing in Excel

The useful fields depend on what is visible in your WhatsApp Web session and what your team needs next. Common fields include phone number, public display name, saved-contact name, country-code context, source group, saved-contact status, and selected message context when available.

After export, add your own business columns. Examples include owner, campaign, class, batch, project, city, source, status, consent note, next action, or CRM lifecycle stage. These internal columns make the spreadsheet operational instead of just being a list of numbers.

Excel cleanup checklist

1. Remove duplicate phone numbers across the same export and previous exports.
2. Normalize country codes before calling, importing, or filtering contacts.
3. Keep the source group column so the team knows where each row came from.
4. Remove contacts that do not belong in the current workflow.
5. Add owner, status, and next-action columns before team handoff.
6. Save a clean copy for import and keep the raw file separate if your process requires audit history.

Common team examples

• Sales: export buyer or inquiry group contacts, assign owners, and prepare CRM import.
• Education: export parent, student, batch, alumni, or admissions groups for administrative review.
• Real estate: export buyer, broker, channel partner, or site-visit groups before calling workflows.
• Events: export attendee, volunteer, webinar, meetup, or community groups after registration or attendance.
• Retail: export local customer, classifieds, reseller, or shop community groups for responsible follow-up.

Responsible use

A spreadsheet can make follow-up easier, but it does not create permission by itself. Use exported contacts only with appropriate authorization, consent, internal policy, and applicable law. WA - Download Group Phone Numbers is independent and is not affiliated with WhatsApp or Meta.

Related export pages

See download WhatsApp group numbers to Excel, why a group member's number isn't showing, choose the contact fields to export, save group members as CSV, import group contacts into a CRM and compare WhatsApp contact export tools.