WhatsApp 聊天記錄轉 Excel

在瀏覽器本機將 WhatsApp 匯出的 .txt 聊天記錄轉換為 Excel 或 CSV,支援預覽、傳送者匿名化和群組統計。

預覽

顯示前 50 列
#日期時間傳送者訊息
上傳或貼上 WhatsApp 匯出的 .txt 檔案以預覽解析後的訊息。

Convert exported WhatsApp chats to Excel

Use this tool when you already have an exported WhatsApp chat .txt file and need a clean spreadsheet for review, archiving, reporting, or group analysis. The converter reads the chat text in your browser, detects message timestamps, senders, system messages, and media placeholders, then exports a spreadsheet you can open in Excel, Google Sheets, Numbers, or any CSV reader.

The first version focuses on exported text chats because that is the safest and most reliable input. It does not connect to WhatsApp Web, read your phone backup, or upload private conversations to a server.

What the converter extracts

  • Date and time
  • Sender name
  • Message text
  • System messages
  • Media omitted markers
  • Basic group chat counts
  • Optional anonymized sender labels

Multi-line messages are kept together, so long replies, copied notes, and pasted links do not become separate rows.

How to export a WhatsApp chat

  1. Open the chat in WhatsApp.
  2. Open the chat info or menu.
  3. Choose the export chat option.
  4. Export without media for the fastest and cleanest .txt file.
  5. Upload or paste the exported .txt content into this page.

If a chat has Advanced Chat Privacy enabled, WhatsApp may block chat export. In that case, this converter cannot access the conversation because it only works with files you export yourself.

Privacy

The conversion runs locally in your browser. Your chat text is not uploaded, stored, or sent to CalculatorStore. If you close the tab or clear the input, the content is removed from the page state.

For sensitive conversations, review the preview table before exporting and enable sender anonymization if you need a spreadsheet without real participant names.

Best practices

  • Use exported .txt chat files instead of screenshots for the most accurate result.
  • Export without media unless you only need a media count marker.
  • Check the date format setting if the first and second numbers in your dates could be ambiguous.
  • Use CSV for lightweight data workflows and XLSX when you want a spreadsheet file for Excel users.

FAQ

Is this an official WhatsApp or Meta tool?

No. This is an independent tool for converting chat history files that you export yourself. It is not affiliated with WhatsApp, Meta, or any official WhatsApp product.

Does the converter upload my chat?

No. The parser and export logic run in your browser. The page does not need to upload your chat text to a server.

Which file type should I upload?

Upload the `.txt` file created by WhatsApp chat export. Image, PDF, and screenshot OCR are not part of the first version because they are less accurate and require a different privacy model.

Why are some messages marked as system messages?

Messages without a sender name, such as encryption notices, group membership changes, or export notices, are marked as system messages.

Can I convert group chats?

Yes. Group chats are supported. The converter extracts sender names, message counts, media markers, and date ranges, and you can anonymize sender names before export.