How to export a WhatsApp chat to CSV or Excel on a Mac, 2 ways.
WhatsApp only exports chats as a text file. On a Mac you can turn that file into a CSV with 1 Terminal command for free, or export the chat straight to CSV in Textlore, with dates, names and messages in their own columns.
Short answer
WhatsApp only exports chats as a text file. On a Mac you can turn that file into a CSV with 1 Terminal command for free, or export the chat straight to CSV in Textlore, with dates, names and messages in their own columns.
TL;DR
- On your iPhone, open the chat, tap its name, then Export Chat and Without Media. You get a zip with a .txt file.
- 1 sed command turns each line into date, time, name and message columns that Numbers and Excel open.
- Textlore reads WhatsApp for Mac and exports any chat or date range to CSV, next to your iMessages.
- Phone numbers stay hidden in Textlore exports unless you switch them on.
At a glance
| Option | Best for | Catch |
|---|---|---|
| WhatsApp export plus 1 command | 1 chat, free. | Multi-line messages split across rows. Date format depends on your phone. |
| Textlore | Any chat or date range, clean columns. | Paid after 14 days. Mac only. Reads WhatsApp for Mac. |
1. Convert WhatsApp's export, free
- On your iPhone, open the chat, tap the name at the top, scroll down and tap Export Chat, then Without Media. AirDrop the zip to your Mac and open it.
- Open Terminal in the folder with
_chat.txtand run:
sed -E -e 's/"/""/g' -e 's/^\[([^,]+), ([^]]+)\] ([^:]+): (.*)$/"\1","\2","\3","\4"/' _chat.txt > chat.csv
Open chat.csv in Numbers or Excel: date, time, name and message each get a column. It is free. A message with line breaks spills its extra lines into new rows, and the date order follows your phone's region settings.
2. CSV straight from Textlore
Textlore is a Mac app that imports your chats from WhatsApp for Mac next to iMessage. Open the chat and press ⇧⌘E, then pick CSV.


- Clean columns. Every message is 1 row, line breaks included.
- Any stretch. Export the whole chat, a date range, or messages you select.
- Other formats. PDF, HTML, plain text, Markdown or an image, from the same window.
- Search first. Find the part you need with search words such as
from:andduring:, across WhatsApp and iMessage at once.
What Textlore doesn't do
- It is Mac only, and needs macOS 26 or later.
- It reads the Messages history on your Mac, so your iPhone texts need Messages in iCloud switched on to get there.
- It reads Messages (iMessage, SMS and the other texts in it) and WhatsApp for Mac. It can't read an iPhone backup.
- It only reads. It never sends, edits or deletes a message, and nothing leaves your Mac.
Questions
Can WhatsApp export to CSV?
No. WhatsApp exports a chat as a .txt file, with or without media. You can convert that file to CSV, or use an app such as Textlore that exports CSV directly.
How do I open a WhatsApp chat in Excel?
Convert _chat.txt to CSV with the sed command on this page, then open chat.csv in Excel or Numbers.
Why are some messages split over several rows?
WhatsApp's text export puts each line of a multi-line message on its own line. Textlore's CSV keeps each message in 1 row.
Does Textlore need my phone?
No. It reads WhatsApp for Mac on your Mac. Nothing leaves your Mac.
Can I try Textlore before I pay?
Yes. Every feature is free for 14 days, with no account, no email and no card. After that it is a one-time purchase for 2 Macs.
Your WhatsApp chat, in rows and columns.
Download Textlore and export a chat to CSV. Free for 14 days.