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.