100% Free × No Sign-Up × Zero Data Saved
Tell us what to build next
☕ Buy Me a Coffee Helps bring more free tools and upkeep

Chat to Excel

ZERO DATA SAVED
Drop WhatsApp .txt or .zip here, or click to browse
Instant conversion • Zero data saved or stored
Reading chat... 0%
Scanning chat structure...
Spotlight — Isolates every message containing your exact words or two-word phrases (up to 5, case-insensitive) into a unified Filtered Results tab with a Matched Keyword column. Type directly without quotes.
Sender — Choose one or more participants from your uploaded chat to group their messages chronologically into Filtered Results:
No participants detected in this file.
Spotlight i Isolates messages matching up to 5 words or two-word phrases (case-insensitive) into a unified Filtered Results tab with a Matched Keyword column. Type directly without quotes.
Sender i Opens a participant checklist from your uploaded chat to group messages from selected senders into Filtered Results.
Harvester i Extracts all shared email addresses and phone numbers from the active chat scope into a clean Contacts sheet.
Strip Noise i Removes <Media omitted>, deleted logs, missed calls, and system banners. Turn OFF to keep media rows and embed resized photo thumbnails from With Media .zip files.
Mask Names i Replaces real participant names and phone numbers with anonymous aliases (Person A, Person B). Disabled while specific Senders are selected.
Sponsored
Google Ads Leaderboard Slot (728 × 90 Desktop / 320 × 100 Mobile)
↓ How to Export WhatsApp Chat, Features & FAQs

How to Export WhatsApp Chat to Excel (.xlsx) on iPhone & Android

STEP 1
Open the WhatsApp individual or group chat you want to convert and open its chat info or options menu.
STEP 2
Locate "Export Chat" and choose whether to export without media or include media—WhatsApp will generate a .zip or .txt file.
STEP 3
Drop the exported .zip or .txt file directly into the upload box above, pick your filters, and click Export.
Sponsored
Responsive In-Content Google Ad Banner

Spotlight — Filter WhatsApp Chat by Keywords & Phrases into One Clean Tab

Track up to 5 single words or two-word phrases (such as deal done or order shipped) at once—case-insensitive. All matches land chronologically in a unified Filtered Results tab with a Matched Keyword column.

Harvester — Extract Phone Numbers & Email Addresses from WhatsApp Groups

Scan thousands of group chat messages to pull every shared phone number and email address with sender name, timestamp, and original message context into a structured Contacts tab.

Sender Checklist — Export Messages from Specific Group Participants

Pick one or multiple participants directly from an auto-populated checklist of your uploaded chat—no spelling or phone-code guesswork—to group their messages chronologically in Excel.

Strip Noise, Media Thumbnails & Mask Names

Strip <Media omitted> clutter and anonymize names (Person A, Person B)—or turn Strip Noise OFF to embed resized photo thumbnails from With Media .zip exports into a dedicated Media column.

Frequently Asked Questions — WhatsApp to Excel (.xlsx)

Everything you need to know about converting WhatsApp .txt and .zip exports into structured spreadsheets.

Are my WhatsApp messages uploaded to a server or saved anywhere when converting to Excel?

No. As indicated by the ZERO DATA SAVED badge, your WhatsApp chats are never saved, logged, or stored anywhere. Once your Excel (.xlsx) file is generated, nothing is retained.

Power GuideHow can I combine Spotlight, Sender, Harvester, Strip Noise, and Mask Names together?

All 5 round switches unlock once your chat finishes processing and can be stacked for multi-layered queries in a single export:

• Spotlight + Sender: Extracts only the messages sent by your chosen Senders that match your 5 Spotlight keywords or two-word phrases (case-insensitive—for example, every time John wrote deal done or order shipped) into one unified Filtered Results tab with a Matched Keyword column.
• Harvester + Sender: Scans messages from your selected Senders only and pulls every phone number and email address they shared into the Contacts sheet.
• Spotlight + Harvester: Extracts phone numbers and email addresses exclusively from chat messages that match your Spotlight keywords.
• Strip Noise + Mask Names (Global Cleaners): Apply across every tab in the workbook to remove <Media omitted> clutter and anonymize participant names. (Note: Mask Names automatically disables while specific Senders are selected.)
• Images & Media (Strip Noise OFF): Turn Strip Noise OFF to keep media rows and add a dedicated Media column (even alongside Spotlight, where media rows are tagged as Media / Image). For .txt or Without Media exports, the Media column lists file references. For With Media .zip exports, photos are automatically resized into lightweight thumbnails directly inside Excel—capped at 200 thumbnails (prioritizing Filtered Results first) to keep conversion fast and your Excel file lightweight, with any extra photos beyond 200 listed cleanly by filename.
How do I convert a WhatsApp chat (.txt or .zip) to Excel (.xlsx) without breaking multi-line messages?

Opening a raw WhatsApp .txt transcript directly in Microsoft Excel splits multi-line paragraphs across broken rows because Excel treats every line break as a new record. When you drop your .txt or .zip file into the upload box above, our parser detects exact timestamp boundaries and merges multi-line messages into a single clean cell alongside dedicated Date, Time, and Sender columns.

Why did WhatsApp export a .zip file instead of a .txt file, and do I need to unzip it first?

Depending on your device, WhatsApp version, and export settings, WhatsApp may save your chat as either a compressed .zip archive or a plain .txt file. You never need to unzip or extract it manually—drop either format straight into the upload box above and the tool will read and convert the chat transcript automatically.

How can I extract all phone numbers and email addresses from a WhatsApp group to Excel?

Slide the Harvester switch ON before clicking Export. The engine scans both participant headers and message bodies across the active chat scope to extract every shared email address and phone number into a dedicated Contacts tab inside your Excel workbook, complete with sender name, date, time, and message context.

How do I extract unsaved phone numbers from a WhatsApp group without saving every contact?

Export your WhatsApp group chat from your phone, drop the exported .zip or .txt file into the converter above, and toggle Harvester ON. Every unsaved phone number that has posted a message in the group or been shared in the text will be compiled into a clean Excel column.

How do I filter a WhatsApp chat by specific words or phrases into a clean Excel tab?

After your file loads, turn ON the Spotlight switch to open the 5-keyword bubble. Type up to 5 single words or two-word phrases (such as deal done, bill split, or order shipped) directly without quotes—matching is completely case-insensitive. All matching messages are combined chronologically into a unified Filtered Results tab with a Matched Keyword column so you can slice by keyword in one click.

Can I export WhatsApp messages from specific people in a group chat?

Yes. After uploading your chat, toggle the Sender switch ON to open a searchable participant checklist populated directly from your file. Check one or more people to group all of their messages chronologically into the Filtered Results tab.

How do I remove <Media omitted> lines and hide real names in a WhatsApp chat export?

Keep Strip Noise switched ON to automatically remove <Media omitted>, image/video omitted placeholders, deleted message notices, missed call logs, and end-to-end encryption banners. Switch ON Mask Names to anonymize the transcript by replacing every sender's real name and phone number with consistent aliases (Person A, Person B, etc.).

Why do emojis and non-English languages (Hindi, Arabic, Spanish) look like garbled symbols in Excel?

WhatsApp exports chat transcripts in UTF-8 encoding. When you open a raw .txt or .csv file directly in Excel, Excel frequently defaults to legacy ANSI encoding, turning emojis and non-Latin scripts into unreadable symbols. Generating a native .xlsx workbook through our converter preserves all Unicode emojis and international scripts intact.

What is the maximum number of WhatsApp messages I can export to Excel at once?

WhatsApp's built-in export typically allows up to 40,000 recent messages without media (or around 10,000 messages when including media). Choose Without Media for the deepest text history, or Include Media when you want photo thumbnails—our engine processes 50,000+ lines into Excel smoothly.

Does this converter support both iPhone and Android WhatsApp date and time formats?

Yes. The parser keeps WhatsApp's exact original Date text and separate Time column on the left, and adds value-pasted Formatted Date (dd-mmm-yy, ddd) and chronological Month (mmm-yy) columns on the right so Excel filters and PivotTables sort cleanly from oldest to newest.

What columns and tabs are included in the downloaded WhatsApp Excel (.xlsx) workbook?

Your workbook exports in clean, plain default Excel formatting across up to 3 structured tabs: Filtered Results (when Spotlight and/or Sender is ON, with Date, Time, Sender, optional Matched Keyword, Message, optional Media, Formatted Date, and Month columns), Contacts (when Harvester is ON), and Full Chat as your complete chronological master transcript.