Paste a ChatGPT table into Excel without everything ending up in one column

Copy the table by selecting it with your mouse

In the chat's answer, click just before the first header, drag to the last cell of the table and press Ctrl+C. That way the browser copies the table as a table, with its rows and columns.

Chat copy buttons behave differently depending on the app. The one below the answer usually copies the whole answer, and in many apps it does so as Markdown, with the bars. Some apps also put a copy button on the table itself. Try yours once: if bars show up when you paste, select with the mouse instead.

Paste into A1 and check the result

Open an empty sheet, click A1 and press Ctrl+V. If it worked, every value sits in its own cell. Check two things:

• Web formatting. It may arrive with another font, shading or borders. Select the table and go to Home › Editing › Clear › Clear Formats.
• Numbers. Real numbers align to the right. If amounts sit on the left, Excel took them as text (you fix that in step 6).

If it all landed in column A, spot the Markdown

If each row fills a single cell and you see something like | Coffee | 12 | 3.50 | 42.00 |, you pasted the Markdown text. The first row is the headers and the second is a line of dashes that, in the chat, only serves to draw the table.

No need to copy again: the bars are exactly what Excel needs to split it.

Open Data › Text to Columns

Select the cells with text in column A (here, A1:A5) and go to Data › Data Tools › Text to Columns. In the first step of the wizard choose Delimited and click Next.

Use the vertical bar as the delimiter

Under Delimiters, untick Tab, tick Other and type | in the box (on a US keyboard, Shift+\). Click Next.

Because every line starts with a bar, the first column in the preview is empty: click it and choose Do not import column (skip). Click Finish. Finally, right-click the row 2 heading (the dashes) and choose Delete.

Fix numbers that arrive as text

If you asked in another language, or the data comes from Europe, the AI may write decimals with a comma (3,50). In a US-format Excel that value stays as text and won't add up, and something like 1,500 may be read as one thousand five hundred. Two fixes:

• With a formula: in a helper column type =VALUE(SUBSTITUTE(B2,",",".")), copy it down and paste the result as values.
• In the wizard: in step 3 of Text to Columns, click Advanced… and set the Decimal separator to a comma.

Ask the AI for a format Excel understands

The easiest route is to avoid the problem in the request. Add at the end:

“Give me the table as tab-separated text, inside a code block, with no bars or formatting. Use a period for decimals and no thousands separator.”

Copy the block with its Copy button, click A1 and paste: Excel splits tab-separated text into columns with no extra steps. If a chat turns the tabs into spaces and everything lands in column A again, ask for CSV instead and split it with Text to Columns using Comma.

For large tables, import with Data › From Text/CSV

With hundreds of rows, copying from the chat gets awkward. Ask for the table as CSV, paste the block into Notepad and save it as table.csv with UTF-8 encoding. In Excel go to Data › Get & Transform Data › From Text/CSV, pick the file and click Import.

In the preview, check File Origin (65001: Unicode (UTF-8), so accented characters come out right) and Delimiter. Click Load: Excel creates a new sheet with the data already turned into a table.