KakaoTalk Chat to CSV
Drop a chat file here, or
Preview (first 50 rows)
Long messages are shortened on screen only; the downloaded file keeps the full text. Line breaks show as ⏎.
How to get a KakaoTalk chat file
- Open the chat room you want to move in KakaoTalk.
- Tap ≡ (menu) at the top right.
- In Settings (the gear), tap Export chat history. On Android it sits under Chat history.
- Choose Send text messages only.
- On Android, save it as a file. On iPhone, send the mail that opens to yourself.
- Add the saved .txt, or the .zip or .eml you received by mail, on this page.
- Open the chat room you want to move in KakaoTalk for PC.
- Click ≡ (menu) at the top right of the chat window.
- Under Chat history, click Save chat history.
- Choose Save as text file and pick where it goes.
- Add the saved .txt file on this page.
Does the CSV open straight in Excel?
Yes. Double-click the CSV and Excel opens it. Google Sheets and Numbers open it too.
- Text is saved so it never turns into garbled characters.
- Messages with line breaks or commas stay in one cell.
- Messages starting with =, +, - or @ are kept as plain text.
Pasting the exported .txt into a spreadsheet drops everything into one cell. This tool rewrites it as a CSV with real date, time, weekday, sender, message and type columns, so sorting and filtering work at once.
What columns come out?
One message is one row, and the first row holds the column names.
| Column | Shape | What it holds |
|---|---|---|
| date | YYYY-MM-DD | The date exactly as the export writes it. |
| time | HH:MM | 24-hour time. |
| weekday | Mon · Tue · Wed … | Worked out from the date. |
| sender | name of the sender | The name as shown in the chat room. |
| message | the message body | A multi-line message stays in one cell, unchanged. |
| type | photo · sticker · file … | Filled only for attachments. |
Can my conversation leak?
No. Reading the file and building the CSV both happen inside this browser. There is no upload step, so the conversion still finishes offline.
Common questions
- Is the chat file I add uploaded anywhere?
- No. The CSV is built on this machine and saved straight to your downloads.
- How do I open the downloaded file in Excel?
- Double-click it. There is nothing to set up.
- Do system lines like “joined” and “left” become rows?
- No. Only messages people actually sent become rows.
- What about “This message was deleted”?
- That stays as a row, marked in the type column.
- How do photos and stickers come out?
- They are classified in the type column. Ordinary messages leave that cell blank.
- Do group chats work?
- Yes. Filter the sender column to see one person.
- Do multi-line messages shift the columns?
- No. A message with line breaks stays in one cell.
- Do exports from iPhone and PC work too?
- Yes. It tells the formats of each device and language apart on its own.
- How large a file can it take?
- It reads up to 100MB or 1,000,000 lines and builds up to 200,000 rows.
- Another tool would not open my file. Will this one?
- Add it and you will know at once. If no message can be read, you get the reason instead of an empty CSV.
- Can I get an .xlsx instead?
- This tool makes CSV only. Open it in Excel and use Save As to get an .xlsx.
- What if I need statistics or a PDF?
- Use KakaoTalk Chat Analyzer for statistics and KakaoTalk Chat to PDF for a printable document.
- It says some lines could not be read. How do I report that?
- Press Report this format in the lines not read notice to get a draft with names and messages masked.