Getting started
ChatSheet works on a computer, in Chrome 116 or newer, on Windows, Mac, Linux and ChromeOS. It's free, and you don't need to sign up.
- Open WhatsApp Web. Go to web.whatsapp.com in Chrome. If you aren't logged in, open WhatsApp on your phone, go to Linked devices, and scan the QR code. Wait until your chats appear.
- Click the ChatSheet icon in Chrome's toolbar. If you can't see it, click the puzzle-piece icon (Extensions) and click the pin next to ChatSheet so it stays in the toolbar.
- Pick what to export, choose your groups or chats, set the options, then click Preview to see a table first, or Export to save the file straight away.
Tab or side panel? ChatSheet opens in its own full-size tab. If you'd rather have it next to WhatsApp Web, open Settings in ChatSheet and choose the side panel.
Making an export
File types
- Excel (.xlsx) opens in Excel, Google Sheets, Numbers and LibreOffice. Phone numbers are kept as text, so they don't turn into strange numbers.
- CSV works with almost any spreadsheet or contacts tool.
- JSON is for people who want to work with the data in their own tools.
- vCard (.vcf) is for importing numbers into your phone's contacts.
- HTML chat backup (for chat messages) opens in any browser, reads like a chat, and works offline.
Preview
Click Preview to see the export as a table before saving anything. You can search, sort by any column, switch between groups with the tabs at the top, and hide columns you don't need. Then export everything, or just the rows you see. To use the data in Google Sheets, copy the table and paste it into a sheet.
Country column and filter
ChatSheet works out each person's country from the country code of their number. Use the Country option to keep only people or chats from one country.
Export history
Your recent exports are listed in ChatSheet (file names only), so you can find them again. Click Show in folder to open the file's folder. You can clear the list in Settings.
Theme and language
ChatSheet has a light and a dark look and can follow your computer's setting. It's available in more than 50 languages.
The 10 export types
- Group members Export the members of one group or many. Choose everyone, only admins, people saved in your phone, or people you haven't saved. Options: one row per person (people in several groups are merged, with their groups listed together), leave your own number out, keep members whose number is hidden, include people who left recently, and, in Excel, a separate sheet for each group.
- Groups list One row per group: size, admins, your role, community, created date, settings (such as "only admins can send messages" or "only admins can edit group info"), description and, for groups you admin, the invite link.
- Contacts Saved contacts, everyone WhatsApp knows about, people you haven't saved, or businesses. If the same person appears twice, the rows are merged by phone number.
- Chats Your chat list, with the last message time and whether each chat is unread, archived, pinned or muted, plus its labels.
- Chat messages The messages of one chat, several, or all chats at once. Set a date range (from and to) and how many messages to take from each chat: the last 200, 1,000, 5,000 or everything. Turn on media backup to also save photos, videos, voice notes, documents and stickers (skipping files bigger than a size you choose) in a folder next to the file, linked from a File column. Or save an HTML chat backup that reads like a chat and works offline.
- Channels The channels you follow or run. Follower lists are private on WhatsApp, so they aren't included.
- Communities Your communities and the groups in each one.
- Labels For WhatsApp Business accounts: your labels and the chats in each label.
- Join requests People who have asked to join the groups you admin.
- Blocked numbers Everyone you have blocked.
Troubleshooting
ChatSheet says WhatsApp Web isn't open
ChatSheet needs WhatsApp Web open in a tab in the same Chrome profile. Click Open WhatsApp Web in ChatSheet, or go to web.whatsapp.com yourself, wait for your chats to load, and try again.
ChatSheet asks me to log in
WhatsApp Web is open but not logged in. On your phone, open WhatsApp › Linked devices › Link a device, and scan the QR code on web.whatsapp.com. When your chats appear, click Check again in ChatSheet.
"Couldn't start", "Reload WhatsApp Web" or "WhatsApp Web has changed"
Reload the WhatsApp Web tab (click the reload button, or press Ctrl+R on Windows, Linux and ChromeOS, or ⌘+R on Mac), wait for your chats to load, then try again. This is often needed right after you install or update ChatSheet.
If the message stays after a reload, WhatsApp has probably updated WhatsApp Web, and ChatSheet needs an update too. One is usually on the way, and Chrome installs extension updates for you. You're welcome to email connect@pilu.in so we know you're affected.
Some members show "Number hidden by WhatsApp"
In communities and some groups, WhatsApp shows members by name only and doesn't share their phone number with you. ChatSheet keeps their WhatsApp name and marks the number as hidden. If you'd rather leave these people out, turn off Keep members whose number is hidden. See About hidden numbers.
A chat shows "No messages found"
WhatsApp Web hasn't loaded that chat yet. Open the chat once in WhatsApp Web, scroll up a little so its messages load, and then try the export again. Also check that your date range isn't leaving every message out.
Some media says it's "no longer available"
WhatsApp removes older photos, videos and files from its servers after a while. Once that has happened, WhatsApp Web can't download them any more, so ChatSheet notes that the file is no longer available and carries on with the rest of the export.
A big export is taking a long time
Older messages load from your phone, and media is downloaded one file at a time, so large exports, such as "Everything" from many chats or a full media backup, can take a while. To help it along:
- keep your phone switched on and connected to the internet;
- don't close or reload the WhatsApp Web tab while ChatSheet is working;
- keep your computer awake.
ChatSheet shows its progress, and you can cancel at any time.
Where are my files?
In your Downloads folder, or wherever Chrome is set to save downloads. After an export, click Show in folder in ChatSheet to go straight to the file. Media from a chat backup is in a folder next to the file.
How do I put the vCard file into my phone's contacts?
Send the .vcf file to yourself (for example by email or a cloud drive) and open it on your phone, which will offer to add the contacts. You can also import it on a computer: in Google Contacts, use Import; in iCloud Contacts, use Import vCard. Your phone picks up the new contacts when it syncs.
I can't find the ChatSheet icon
Click the puzzle-piece icon (Extensions) at the top right of Chrome, then click the pin next to ChatSheet. It will stay in the toolbar from then on.
Which computers and browsers does it work on?
Chrome 116 or newer on Windows, Mac, Linux and ChromeOS. ChatSheet doesn't work on phones or tablets, because it needs WhatsApp Web in desktop Chrome.
Is ChatSheet really free?
Yes. There are no hidden charges, no paid plan and no export limits, and you don't need an account.
About hidden numbers
WhatsApp protects some people's phone numbers. In communities, and in some groups, you see members by name only. WhatsApp Web doesn't give your browser those numbers, so ChatSheet can't export them either.
ChatSheet keeps these members in your export with the name WhatsApp shows, and writes "Number hidden by WhatsApp" in the number column. When WhatsApp Web already knows someone's number (for example, because they're in your contacts), ChatSheet uses it. It never tries to work around a hidden number.
Using your exports fairly
ChatSheet is made for managing the groups you run or belong to, and for keeping your own records and backups. It doesn't send messages in bulk and doesn't find new numbers.
The numbers and messages you export are other people's personal data too, and laws such as India's Digital Personal Data Protection Act, 2023 and the EU's GDPR may apply. Keep your files private, use them only for running your own groups, and don't add people to lists or groups without their agreement.
Privacy in short
- ChatSheet runs inside your browser and reads only what WhatsApp Web already holds there.
- Files are saved to your Downloads folder. Nothing is sent to us or anyone else.
- No analytics, no tracking, no ads, no code loaded from the internet.
- ChatSheet only keeps your settings, your chosen groups and options, and a list of recent export file names on your computer. Uninstalling removes them.
Read the full privacy policy.
Contact
Questions, problems or ideas? Email connect@pilu.in. It helps if you tell us your Chrome version, what you were exporting, and what ChatSheet showed. Please don't attach exported files or screenshots with other people's numbers or messages.
ChatSheet is an independent product. It is not affiliated with, endorsed or sponsored by WhatsApp LLC or Meta Platforms, Inc.