How to export a ChatGPT conversation to Excel

Export your data from ChatGPT, then convert the ZIP to CSV with ChatExports. You get one row per message with the conversation title, date, speaker and message text, which opens directly in Excel, Numbers or Google Sheets and can be filtered and pivoted like any other table.

Short answer

Step by step

Request your export: In ChatGPT open Settings, then Data controls, then Export data, and confirm from the email OpenAI sends. The download link expires, so save the ZIP.
Drop the whole ZIP on the converter: Open the converter and drop the ZIP straight on the page with no need to unzip it. Every conversation is read inside your browser tab.
Choose CSV: Select the conversations you want and press CSV. You can export one chat, a selection, or the whole archive as a single table.
Open it in your spreadsheet: Double click the file in Excel or Numbers, or import it into Google Sheets. The columns are already named, so sorting and filtering works immediately.

A spreadsheet is the right shape for a chat archive when you want to count things rather than read them. What did I actually ask about most? How many of these threads are from work hours? Which month did I stop using it for code?

What the CSV contains

One row per message, with columns for:

Conversation title
Conversation date
Message timestamp
Speaker, you or the assistant
Message text

That layout is deliberately boring, because boring is what pivot tables want. Filter on speaker to read only your own prompts. Sort by date to see your usage over a year. Count rows per title to find your longest thread.

Things people do with it

Pull every prompt they have written into one column, as a reusable prompt library
Count messages per month to see whether their usage is growing
Filter for a client name to gather everything relevant before a meeting
Feed the prompt column into a another tool for tagging or clustering
Keep a compliance record that a reviewer can search without reading every chat

Excel and long messages

Excel truncates what it shows in a cell, though the content is still there. Turn on Wrap Text and widen the row height to read long answers, or keep the CSV for analysis and use the Word or PDF export when you want to read the conversation properly. Most people use both.

Commas, quotes and code

Chat text is full of commas, quote marks and newlines, which is exactly what breaks a badly written CSV. Fields are quoted and escaped properly, so a code block or a bulleted answer stays inside its own cell rather than spilling across columns.

Privacy

The conversion happens in your browser tab. The ZIP is read from your disk, the CSV is built on your device, and nothing is uploaded or stored. This matters more than usual with a spreadsheet, because a CSV of your whole history is an unusually easy file to accidentally share.

Cost

Browsing your conversations is free. Downloads are a one time unlock, ten dollars for ChatGPT or twenty five dollars for all nine platforms.

Frequently asked questions

Can I get one row per message?

Yes, that is the default layout: title, date, timestamp, speaker and message text, one message per row.

Will it open in Google Sheets?

Yes. Import the CSV in Sheets, or open it in Excel or Numbers. It is a standard comma separated file with a header row.

Do code blocks survive?

Yes. Fields are quoted and escaped, so code, commas and line breaks stay inside their own cell.

Can I export my whole history as one spreadsheet?

Yes. Select everything and you get a single table covering every conversation in the archive.