Need everyone’s number from a WhatsApp group in one Excel sheet, for an event list, a class register or client follow-up? WhatsApp has no export button, but you can do it for free with WhatsApp Web and Excel.
▶️ Subscribe to Elgon Web Hosting on YouTube for more step-by-step tech tips.
Before you start
You need a computer and your phone, and you must be a member of the group. Members you’ve saved in your phone show as names; everyone else shows as a phone number.
Method 1: WhatsApp Web and Excel (free, no extra software)
- Open WhatsApp Web. On your phone, open WhatsApp, tap the three dots, then Linked devices › Link a device, and scan the QR code at web.whatsapp.com.
- Inspect the member list. Open the group, right-click the member names under the group name, and choose Inspect.
- Copy and clean. Right-click the highlighted line in the code panel and copy it. Paste it into Notepad and use Replace to remove the extra code, leaving names and numbers separated by commas.
- Split it in Excel. Paste the list into Excel, go to Data › Text to Columns, choose Comma and click Finish. Then copy the row and use Paste Special › Transpose to get one tidy column.
Method 2: A Chrome extension (faster)
Some Chrome extensions add a download button to WhatsApp Web and save the group as a CSV file you can open in Excel. They can read your WhatsApp Web session, so only install one with good reviews and check its permissions first.
Use the numbers responsibly
Phone numbers are personal data. Under Uganda’s Data Protection and Privacy Act, 2019, use them only for the purpose people agreed to, keep the file private, and never use them for spam.
Methods based on Wondershare MobileTrans’ guide. WhatsApp Web’s layout changes from time to time, so your screen may look slightly different.