Export a WhatsApp chat to Excel
Choose the .zip or .txt that WhatsApp exports and download an .xlsx or .csv with one row per message, ready to filter, sort and count. Free, with no row limit, and nothing is uploaded.
- 100% free
- No usage limits
- No sign-up
- Nothing uploaded: your chat stays on your device
A short made-up conversation with a photo, to see how it works.
To get the file: open the chat in WhatsApp → tap the name at the top (iPhone) or ⋮ → More (Android) → Export chat → with or without media → save it or send it to yourself.
PDF and reading options
How to export a WhatsApp chat to Excel
- Export the chat from WhatsApp. “Without media” is enough for a spreadsheet and gives you a small .txt.
- Choose the file here. A .zip works too; there is no need to unzip it.
- Filter if you want. Date range, one participant or a word: only what you see is exported.
- Press “Download Excel” or “Download CSV”.
What the spreadsheet contains
The first sheet has one row per message. Date and Time are real Excel values rather than text, so sorting, filtering by month and pivot tables work without any clean-up. Messages with several lines stay in one cell. The second sheet summarises the chat: first and last message, and messages, words and media per participant.
What people use it for
- Orders taken by chatShops and freelancers who take orders in WhatsApp filter by customer or date and copy the rows into their own sheet.
- Research and courseworkGroup chats exported for qualitative analysis, coded in Excel, Sheets or imported into R or Python as CSV.
- Time and work logsCheck-in messages from a team group become a table you can count by person and day.
- Finding a figureSearch a long chat for an amount, a date or an address, and keep only those rows.
How to export a chat from WhatsApp
| iPhone | Open the chat → tap the name at the top → scroll down → Export Chat → Attach Media or Without Media → Save to Files, or send it to yourself. |
|---|---|
| Android | Open the chat → ⋮ → More → Export chat → Include media or Without media → save it to your files or to Drive, or send it to yourself. |
With media you get a .zip that holds the text of the chat and its photos, videos and voice notes. Without media you get a .txt, or a small .zip with only the text. WhatsApp exports one chat at a time and, with media, only the most recent part of a very long chat: that limit is set by the app, not by this page.
Private by design
A conversation is one of the most personal files you have, and the usual converters ask you to upload it. This page works the other way round: your browser opens the file, reads it and builds the result on your own device. No message, photo or file name is sent anywhere, and there is no account that could keep a copy.
You can verify it yourself: open the developer tools, look at the Network tab while you load a chat, or disconnect from the internet once the page has loaded. Everything keeps working.
Limits worth knowing
- Excel’s own limits apply: 1,048,576 rows per sheet and 32,767 characters per cell. A longer message is cut at that length and the page tells you how many were cut. The CSV has no such limit.
- Times are those written in the export, in the time zone of the phone that exported the chat. Android exports have no seconds, so they appear as :00.
- Phone numbers of senders appear only for people who were not saved as contacts on the phone that exported the chat; saved contacts appear by name.
- Very large chats depend on your device’s memory, because the file is built in the browser. In our test, 200,000 messages became an 18 MB .xlsx in about five seconds, during which the page does not respond.
- Formats: exports from WhatsApp for Android and iPhone, with 12- or 24-hour clocks and dates written with
/,.or-. Exports whose dates use other scripts or calendars (Arabic or Persian digits, for example) are not recognised. - Day/month or month/day: the order is worked out from the dates themselves. When a chat gives no clue (every day is 12 or lower), the page tells you and lets you choose.
Frequently asked questions
Is it really free?
Yes. It is 100% free, with no usage limits, no message cap, no account, no sign-up, no watermark and no paid plan.
Is my chat uploaded?
No. The file is opened and processed inside your browser and never leaves your device. The page only downloads its own code from this site. If you accept analytics cookies, Google Analytics receives anonymous usage data such as page views, never your chat, its file name or its contents.
How do I export a WhatsApp chat to Excel?
Export the chat from WhatsApp (without media is enough), choose the file on this page and press “Download Excel”. You get an .xlsx with one row per message and a second sheet with totals per participant.
How do I export a chat from WhatsApp?
On iPhone, open the chat, tap the contact or group name at the top, scroll down and tap Export Chat. On Android, open the chat, tap the three dots, then More, then Export chat. Choose “Attach media” or “Include media” if you want the photos, and save the file or send it to yourself. You get a .zip, or a .txt if you export without media.
Which columns does the spreadsheet have?
Date, Time, Sender, Message, Type (text, photo, video, audio, file, omitted media, deleted or system) and Attachment (the file name). Date and time are real Excel values, so you can filter by month or build a pivot table.
Are multi-line messages kept in one cell?
Yes. A message with several lines stays in a single cell with its line breaks, in both Excel and CSV.
Does the CSV open correctly in Excel and Google Sheets?
It is saved as UTF-8 with a byte-order mark, so accents and emojis display correctly when you open it in Excel, and Google Sheets imports it directly.
Can I export only part of the chat?
Yes. Set a date range, pick one sender or type a search before downloading: only the messages shown are exported.
Is this an official WhatsApp tool?
No. This site is independent and is not affiliated with, endorsed by or connected to WhatsApp or Meta. It only reads the export file that WhatsApp itself creates.
Analytics: only if you accept cookies, the page loads Google Analytics (through Google Tag Manager) to count visits and see which tools are used. It never receives your chats, your files or their names. You can change your choice at any time with “Cookie settings” at the bottom of the page.