WhatsApp messages to Excel: export a chat or log every lead

WhatsApp can't save chats as a spreadsheet, but Excel can read its exports. For one chat, use Export chat, which saves a text file (zipped on iPhone), and split it into columns with From Text/CSV and Power Query. To log each new message, a Power Automate flow fed by a WhatsApp tool's webhook can add it to an Excel table.

The first method is free and suits one customer's history, such as a dispute over what was quoted. The second suits a sales team that wants a running log of enquiries in a workbook its managers already open. Both are below, with the limits of each, and a note on where WavesFlo's own exports fit.

Can you export a WhatsApp chat to Excel?

Not directly. WhatsApp's Export chat produces a text file, not a spreadsheet, and you export one chat at a time from inside it. As of October 2026, WhatsApp's help centre adds that on iPhone the export arrives as a ZIP file and leaves out view once messages, and that including media attaches only the most recent media. The file can't be imported back into WhatsApp either, because it is a text file, not a backup. Excel can open it and turn it into columns. And as of October 2026 there is no Export chat in a chat where someone has turned on Restricted chat, or the Advanced chat privacy it is replacing: both stop anyone exporting it.

How do you export a WhatsApp chat on Android and iPhone?

On Android:

1. 1Open the chat.
2. 2Tap More options (the three dots), then More, then Export chat.
3. 3Choose Without media, which is all Excel needs.
4. 4Pick how to send it, for example by email, so it reaches the computer that has Excel.

On iPhone:

1. 1Open the individual or group chat.
2. 2Tap the contact's or group's name at the top, then Export chat.
3. 3If the chat contains media, choose Without Media.
4. 4Send it to yourself, for example by Mail, and unzip the file on the computer.

How do you open a WhatsApp export in Excel with proper columns?

In the exported text, each message normally starts on a new line with its date and time, then the sender's name, then the text. The punctuation between them differs between Android and iPhone and with your phone's date settings, so look at the first few lines before you start. Power Query, built into Excel, does the splitting:

1. 1In Excel, go to Data, then From Text/CSV in the Get & Transform Data group, and pick the file. If the preview splits lines at commas, set Delimiter to Custom with a character your chats never contain, such as |, so each line stays whole. Then choose Transform Data to open Power Query.
2. 2Select the column, choose Split Column, then By Delimiter, and enter the characters that separate the time from the name in your file. Split at the left-most delimiter.
3. 3Split the right-hand column again at the left-most colon, which separates the name from the message. Using the left-most one keeps colons inside messages, such as Rate: ₹450, intact.
4. 4Split the left-hand column at the comma between date and time, and clear any brackets with Replace Values.
5. 5Set the date column's type with Change Type, then Using Locale, and pick the locale that matches your phone, such as English (India), so 05/10/2026 reads as 5 October rather than 10 May.
6. 6Choose Close & Load to put the table on a sheet.

Two clean-ups remain. A message with line breaks spills onto extra rows that don't start with a date, and WhatsApp's own notices, such as a change of group name, have no sender; filter both out or fix them by hand. A worksheet holds up to 1,048,576 rows, plenty for one chat.

How do you log every new WhatsApp message to Excel automatically?

Use Power Automate with a service that sends an event for each message. With WavesFlo, the signed message.received event fires for every incoming message on a connected number and carries an event ID, the sender, their profile name, the text, a timestamp and the id of the number it arrived on.

1. 1Keep the workbook in OneDrive for Business or SharePoint, under the Excel Online (Business) connector's 25 MB limit, and format a table named Messages with the columns EventID, Time, From, Name, ArrivedOn, ChatType and Message. Keep column names to letters and numbers, because the connector's Filter Query accepts nothing else.
2. 2Create a cloud flow that starts with When an HTTP request is received, save it to get the URL, and set who can trigger it to Anyone. Microsoft's other options expect a Microsoft Entra token, which WavesFlo's webhooks don't carry, so the signature check is what keeps strangers out.
3. 3In WavesFlo, add a webhook destination with that URL, subscribed to the Messaging category, and add a condition in the flow that continues only for message.received events from a direct chat. The event also fires for group, channel and status messages and says which kind of chat it came from; send group messages to a table of their own if you want them.
4. 4Verify the signature in a small Azure Function before going further; the Power Automate connector guide explains why expressions can't do it.
5. 5Add List rows present in a table with the Filter Query EventID eq followed by the event's ID in single quotes, and continue only if no rows come back, so a retried delivery is skipped.
6. 6Add the Add a row into a table action, mapping the event's fields to the columns and using the event's own timestamp for Time.
7. 7In the trigger's settings, turn on Concurrency Control with a limit of 1.

Those settings follow from how the connector behaves, per Microsoft's documentation as of October 2026. Writes can take up to 30 seconds to show, so a duplicate arriving within seconds can still slip past the check; the EventID column lets you clear it later with Remove Duplicates. Writing to one file from several places at once isn't supported, so don't edit the log by hand while the flow runs. The connector allows 100 calls per connection a minute. And the flow needs a premium licence: Excel Online (Business) is standard, but the call to your Azure Function goes through Microsoft's premium HTTP connector.

How do you keep one row per lead in Excel?

Add a second table, Leads, keyed on the sender's number, and fill it from direct chats only. After the new row is added, list the Leads rows whose From matches the sender. If none comes back, add a row with the first-seen time, name, the number it arrived on and the first message. If one exists, use Update a row with From as the key column and fill in only LastMessage and LastSeen: Microsoft's documentation says columns left blank are not updated, so the first-message columns keep their values. Leave formulas out of both tables, because Microsoft warns that recalculation can time the connector out and a retry can then insert a row twice.

What about the reports WavesFlo exports?

They answer a different question. WavesFlo's 11 reports export as CSV and JSON; the CSV files open in Excel through the same From Text/CSV step. They cover what you sent and what happened to it, from delivery receipts: sent, delivered, read and failed. They are not a transcript of your inbox. Read rates in them are a floor, because people can turn read receipts off. What each campaign metric means explains the figures.

Excel or Google Sheets for a WhatsApp log?

The Google Sheets version is in logging WhatsApp leads to Google Sheets, and the same events can go to a CRM instead, as in the Zoho CRM guide. Going the other way, from a table to WhatsApp, is a separate flow: sending WhatsApp messages from Excel with Power Automate. For the wider routine, see running WhatsApp sales as a team.