How to see who sends the most messages in a WhatsApp group
WhatsApp shows who is in a group and, through message info, who read a message you sent. It has no count of how many messages each member wrote. To get one, export the group and count the senders in a spreadsheet. It takes about ten minutes the first time, and the chat stays on your own computer.
Chat analyzer websites will do the counting if you upload the export to them. That file holds every message from every member, so think about whose messages you are handing over before you use one. The steps below need only Google Sheets or Excel.
1. Export the group without media
WhatsApp Web, or the Windows or Mac app. Open the group, open the menu at the top of the chat, click Export chat, choose All messages or Custom date range, then click Export. You get a ZIP file (WhatsApp's steps).
Android. Open the group, tap the three-dot menu > More > Export chat, tap Without media and pick where to send it (WhatsApp's Android steps).
iPhone. Open the group, tap the group name at the top, then Export chat and Without media, and save it, for example to Files (WhatsApp's iPhone steps).
Unzip it and keep the text file. A custom date range is handy if you want this month's numbers rather than the group's whole history.
2. Put the chat into a spreadsheet
Open the text file, select everything, copy it, and paste it into cell A1 of a new Google Sheet. Each line of the chat lands in its own row in column A. If a dialog asks how to split the text, choose not to split it, so each line stays in one cell.
Look at a few rows. The layout depends on the phone and language that made the export, but every message line starts with a date and time, then the sender's name, a colon and the text. Two common layouts:
13/11/2026, 21:41 - Ana: see you at 8(Android and WhatsApp Web style)[13/11/2026, 21:41:05] Ana: see you at 8(iPhone style)
3. Pull out the sender's name
In cell B1, use REGEXEXTRACT to copy the name that sits between the timestamp and the colon. For the first layout:
=IFERROR(REGEXEXTRACT(A1, " - ([^:]+): "), "")
For the iPhone layout:
=IFERROR(REGEXEXTRACT(A1, "\] ([^:]+): "), "")
Fill the formula down the column. Lines that aren't the start of a message, such as the second line of a long message or a line saying someone joined, come out blank, so they won't be counted. Check a handful of rows against column A before you trust the result.
4. Count with a pivot table
Select column B, then click Insert > Pivot table. Add the column to Rows, add it again to Values summarized by COUNTA, and sort by that count, largest first (Google's pivot table steps). Remove the blank row from the result. You now have every member who wrote in the export and how many messages each sent.
For a single person, a COUNTIF is quicker: =COUNTIF(B:B, "Ana"). Excel users can paste the same way, use Excel's own text functions or Flash Fill to split out the name, and build the count with a PivotTable.
Why your numbers may look off
- Names follow your contacts. A member you haven't saved shows up as a phone number, and one person with two numbers counts as two rows.
- Media still counts. A photo or voice note becomes a placeholder line such as "<Media omitted>", so it adds one to the sender's total. So does "This message was deleted".
- Silent members are missing. The count only lists people who wrote something in the exported period. Compare it with the group's member list to see who never posts.
- Some chats won't export. WhatsApp's Help Center says members of a group using Restricted chat can't export it. See what Restricted chat blocks on WhatsApp Web.
- Old messages may be absent. An export from WhatsApp Web covers what the computer has. See why WhatsApp Web isn't showing old messages.
If you want to read what one member wrote rather than count it, our guide on seeing all messages from one person in a WhatsApp group uses the same export.
Sources
- WhatsApp Help Center, How to export your chat history (WhatsApp Web, Windows, Mac)
- WhatsApp Help Center, How to export your chat history (Android)
- WhatsApp Help Center, How to export your chat history (iPhone)
- WhatsApp Help Center, About restricted chat
- Google Docs Editors Help, REGEXEXTRACT
- Google Docs Editors Help, Create & use pivot tables
- Google Docs Editors Help, COUNTIF
- Microsoft Support, Create a PivotTable to analyze worksheet data