How to get a ChatGPT table into Excel (without retyping it)

AI models answer "make me a table of…" in Markdown, not in spreadsheet format. Here's the one-minute path from chat to a working .xlsx — and why the paste key alone never gets you there.

Why the AI table lands in Excel broken

When ChatGPT, Claude or Gemini builds a table, it writes GitHub-flavored Markdown: cells separated by pipes (|), a header row, and an alignment row underneath. Excel has never heard of that syntax. Paste it into a worksheet and Excel applies its usual text-paste rules — split on tabs, merge everything else — so each row collapses into one cell full of pipes.

The same applies to "export" prompts: the model still writes Markdown. What you need is a structural conversion — parse the pipes, infer column types, then hand Excel real cells.

Convert the table to Excel in three steps

1. Copy the responseUse the chat's copy button so you get the raw Markdown, including the table's pipe syntax and alignment row.

2. Convert it in your browserPaste the Markdown into the converter — nothing is uploaded, and every table in the text is detected.

Paste into the Markdown table to Excel converter free — no signup, no upload.

3. Download and openOpen the .xlsx in Excel: numbers infer as real numbers, and leading-zero IDs stay as text.

Convert a ChatGPT table to Excel →

Model-specific notes

ChatGPT: the "Copy" button on a response block preserves the Markdown table. Copying by mouse-selection from the rendered view can pick up formatted text instead — prefer the button.
Claude: same GFM tables with alignment rows. Long tables may be truncated with an offer to continue; convert each part, or ask for the full table in one block first.
Gemini: outputs GFM tables as well; watch for "view as sheet" exports that produce a screenshot — you want the text.

Before you trust the spreadsheet

Check numeric columns. The converter infers numbers and booleans; anything with a leading zero (IDs, ZIP codes) deliberately stays text, and the fidelity note says so.
Check multi-line cells. AI cells that contain line breaks arrive as \n in the text — replace them in Excel if needed (Find & Replace, Ctrl+J).
Watch the row count. Models sometimes abbreviate long tables mid-generation. Compare the last row to what the chat promised.

Frequently asked questions

Why does pasting a ChatGPT table into Excel collapse into one column?

ChatGPT renders tables as Markdown — pipes and dashes — which Excel sees as ordinary text. Excel splits pasted text on tabs, not pipes, so every row lands in a single cell. Converting the Markdown parses the pipe structure first, then hands Excel real columns.

Do the numbers stay as numbers in Excel?

Yes: cells like 42 or 3.14 become real Excel numbers. IDs and ZIP codes with leading zeros are deliberately written as text — 00123 keeps its zeros — and the converter states this in the fidelity output so you know what you got.

Does this work with Claude and Gemini tables too?

Yes. Claude, Gemini and most other chat models also emit tables as GitHub-flavored Markdown. As long as the copy contains the pipe syntax, the same conversion works identically — no account, no upload.

Is any of the table data uploaded to a server?

No. The conversion runs entirely in your browser; the pasted text never leaves your device. That matters for confidential spreadsheets pasted out of an internal AI session.

Getting the whole AI answer into Word or PDF — the document-level version of this workflow
Excel → Markdown — the reverse direction, for feeding data back into a prompt
Format support — exactly what converts natively, element by element