WhatsApp chat to Excel
Turn a WhatsApp chat export into a spreadsheet with one row per message, ready for Excel, Numbers or Google Sheets. It's free, has no message limit, needs no account, and the chat never leaves your device.
Also in: Español · Português · Bahasa Indonesia
How to turn a WhatsApp chat into a spreadsheet
- Export the chat from WhatsApp. On iPhone: open the chat, tap the name at the top, then Export Chat and Without Media. On Android: open the chat, tap ⋮, then More, Export chat and Without media.
- Open it here. Choose the .zip or .txt above (on a phone, open this page in the phone's browser and pick the file from Files or Downloads).
- Click Download for Excel (CSV). Your browser saves a .csv file named after the chat.
- Open the file in Excel, Numbers or Google Sheets (in Sheets: File, Import, Upload).
Only need part of the chat? Type in the search box first: the spreadsheet then holds only the matching messages.
What's in the spreadsheet
| Column | What it holds | Example |
|---|---|---|
| Date | Year-month-day, which sorts correctly in any spreadsheet | 2026-10-18 |
| Time | 24-hour time, whether the phone showed 9:41 PM or 21:41 | 21:41:00 |
| Sender | The name, or the number for someone not in your contacts | Ana |
| Message | The text, with line breaks kept in one cell | See you at 8! |
| Type | text, media (a file was sent but isn't in the export) or deleted | text |
The converter reads WhatsApp exports from iPhone and Android in English, Spanish, Portuguese, Indonesian, German and French, whichever way the phone writes dates. Notices such as "Messages and calls are end-to-end encrypted" aren't messages, so they're left out. WhatsApp limits how many recent messages one export includes, so a very long chat can arrive without its oldest messages.
What people use it for
- Keeping a record of a chat with a landlord, a client or a school, sorted and searchable. A spreadsheet isn't certified evidence; ask a lawyer what your case needs.
- Counting things with a pivot table: messages per person, per month or per hour. For the usual numbers without building one, the free chat analyzer does it for you.
- Finding one message by filtering the Message column, or sorting by date.
Private by design
Sites that convert WhatsApp chats usually ask you to upload them. This one doesn't: the page reads the file on your device and your browser writes the spreadsheet. Load the page, switch off Wi-Fi, and it still works. No cookies, no account, nothing saved.
Questions
How do I export a WhatsApp chat to Excel?
Export the chat from WhatsApp (Export Chat, Without Media), open the .zip or .txt on this page, and click Download for Excel (CSV). Open the file in Excel, Numbers or Google Sheets: each message is one row.
What columns does the spreadsheet have?
Date (year-month-day), time, sender, message and type. Type is text, media (a photo, video, voice note or file was sent; the file itself isn't in the export) or deleted. A message that ran over several lines stays in one cell.
Why do some cells start with an apostrophe?
A message that starts with =, +, - or @ could run as a formula when Excel opens the file, and a chat partner could send one on purpose. The converter puts an apostrophe in front of those cells so Excel treats them as plain text. Phone numbers like +1 555 0100 get one too.
Does it export contacts or phone numbers?
No. It converts the messages in one chat export. The sender column shows each person as WhatsApp wrote them in the export: a saved name, or a number for people not in your contacts.
Is my chat uploaded?
No. The page reads the export on your own device, and your browser builds the spreadsheet file itself. Nothing is uploaded or saved, and the page sets no cookies.
Why is everything in one column?
Excel in some countries expects semicolons between columns, not commas. Import the file instead of double-clicking it: in Excel, choose Data, then From Text/CSV (on a Mac: File, Import), pick the file and set the delimiter to Comma.
Will emoji and accents show correctly?
Yes. The file starts with a marker that tells Excel it's UTF-8, so emoji, accents and other alphabets come through. If you open it in Numbers or Google Sheets, they read it the same way.