A ChatGPT table is a Markdown pipe table — plain text using | characters to suggest columns. Spreadsheets expect cell boundaries, not pipes, so every row lands in a single column. Converting the table to XLSX or CSV first produces real rows and columns that open correctly in Excel, Sheets, and Numbers.
Why the whole table lands in column A
What the chat window shows you is a rendered table. What your clipboard receives is usually this:
| Region | Q1 | Q2 |
| --- | ---: | ---: |
| Europe | 412 | 486 |
| Asia | 377 | 381 |
That is a Markdown pipe table. The vertical bars are ordinary characters that look like column dividers to a human reader. The second line, with its dashes and colons, tells a Markdown renderer where the header ends and how to align each column.
Excel splits pasted text on tab characters, not pipes. Since there are no tabs, each line is a single value, and the entire table stacks into column A with the pipes still visible. Google Sheets and Numbers behave identically.
The alignment row is the giveaway that this was never spreadsheet data. No spreadsheet export contains a row of hyphens and colons.
The fastest fix: convert before pasting
Rather than pasting and repairing, convert the table into a format spreadsheets already understand.
For Excel and Numbers, Markdown Table to Excel produces a genuine .xlsx file. Paste the table, download the spreadsheet, open it. Numbers stay numbers, the header row stays a header row, and nothing needs splitting afterwards.
For Google Sheets, Markdown Table to CSV is usually smoother. CSV imports natively through File → Import, and you avoid the download-then-upload round trip that XLSX requires in a browser. The converter escapes quotes and embedded commas properly, which is where hand-rolled conversions typically break.
Both run locally in your browser, so the data never leaves your machine — worth noting if the table contains anything you would not paste into a random website.
The manual methods, and when they are worth it
If you would rather not leave the spreadsheet, two built-in routes work.
Text to Columns (Excel). Paste the raw table into column A, select it, then Data → Text to Columns → Delimited, and set the delimiter to the pipe character. You will still need to delete the alignment row and trim the stray empty columns created by the leading and trailing pipes.
SPLIT (Google Sheets). With the raw table in column A, use =SPLIT(A1, "|") and fill down, then copy and paste-as-values. Same cleanup applies.
These are fine for a single small table. They get tedious quickly, and both leave whitespace padding inside every cell — the spaces Markdown uses for readability become part of the value, so Europe will not match Europe in a lookup formula. That trailing-space problem is the most common reason a converted table looks right but behaves wrong.
A note on copying: if you drag-select the rendered table in the chat window rather than using the copy button, some browsers put tab-separated text on the clipboard, which pastes into columns correctly. It is inconsistent across browsers and chat interfaces, so it is worth trying but not worth relying on.
When the table is buried in a longer answer
Often the table you want is one part of a much longer response, mixed in with explanation above and below it.
Extract Tables from Text finds table-like rows inside surrounding prose — pipe-delimited or tab-delimited — and returns just the table as CSV. Paste the entire answer and take the data out, rather than hand-selecting rows and hoping you caught the boundaries.
Two things worth checking on any converted table before you build on it:
- Numbers stored as text. If a column arrives left-aligned in Excel, the values are text. Currency symbols, thousands separators, and percent signs in the original are the usual cause. Select the column and use Data → Text to Columns → Finish to coerce them.
- Merged or wrapped cells. Markdown tables cannot express merged cells, so a model presenting complex data will sometimes fake it with repeated values or line breaks inside a cell. Those need a human decision, not a converter.
If the rest of the response also needs to travel — headings, lists, the explanation around the table — see why pasted AI text shows ** and ##.
Frequently asked questions
Why does a ChatGPT table paste into one column in Excel?
Because it is a Markdown pipe table, which is plain text using | characters as visual dividers. Excel splits pasted text on tabs, not pipes, so each line is treated as one value and the whole table stacks into a single column.
How do I convert a Markdown table to Excel?
Paste it into Markdown Table to Excel and download the resulting .xlsx file. It produces real rows and columns with the header preserved, so there is nothing to split or clean up after opening.
What is the row of dashes and colons in an AI table?
It is the Markdown alignment row. It separates the header from the body and sets column alignment — a colon on the right means right-aligned, on both sides means centred. It is formatting syntax, not data, and should be removed during conversion.
Why do my converted cells have extra spaces?
Markdown pads cells with spaces for readability, and manual splitting keeps that padding inside the value. It matters because ' Europe ' will not match 'Europe' in a lookup. A proper converter trims the padding; if you split manually, wrap the results in TRIM.
Can I paste an AI table into Google Sheets directly?
Not with the columns intact. Converting to CSV first and importing through File → Import is the most reliable route, since CSV is a format Sheets parses natively and it avoids the XLSX download-and-upload round trip.