How to Copy a ChatGPT Table to Excel Without Breaking It

Quick answer: if you copy the raw text of a table from ChatGPT, Claude or Gemini, Excel receives markdown, lines full of | symbols, and puts each row in a single cell. To get proper cells, either copy the rendered table from the chat window, paste the markdown into a converter that outputs tab-separated text or an .xlsx file, or split the pasted text with Excel's Text to Columns using | as the delimiter.

Why pasted tables break

AI chat tools write tables in markdown, a plain-text format that looks like this:

| Plan | Price | Users |
|---|---|---|
| Basic | $10 | 1 |

The chat window displays this as a neat table. But when you use a copy button that copies the raw response, or copy from an app that doesn't render markdown, you get the text with the pipes. Excel has no idea that | means "new column", so each line lands in one cell.

Method 1: Copy the rendered table

In most chat apps, select the displayed table with your mouse (not the copy button) and paste into Excel.

• Works well: often, for simple tables in a desktop browser.
• Problems: it can carry over formatting such as background colours and fonts, and some apps paste the whole response. Use Paste Special → Text (or Ctrl+Shift+V in Google Sheets) to drop the formatting.

Method 2: Convert the markdown

Paste the markdown into the markdown table to Excel converter and choose one of:

• Copy for spreadsheet: produces tab-separated text. Paste into any cell and Excel or Google Sheets spreads it across columns automatically.
• Download Excel: an .xlsx file with each table on its own sheet.
• Download CSV: a CSV file that opens with accented characters intact.

The converter also removes bold markers and the dashed alignment row, and lines up rows with missing cells. It runs in your browser, so the data isn't uploaded.

Method 3: Text to Columns in Excel

If the markdown is already in your sheet, one row per cell in column A:

1. Select column A.
2. Go to Data → Text to Columns.
3. Choose Delimited, then tick Other and type |.
4. Click Finish.

You'll then need to delete the empty first column (created by the leading pipe), delete the row of dashes, and trim extra spaces with the TRIM function.

In Google Sheets, the equivalent is Data → Split text to columns, then choose a custom separator of |.

Method 4: Ask the AI for a different format

You can ask the chatbot to "output this table as CSV" or "as tab-separated values". Copy the result and paste it. This works, but you'll need to check that values containing commas are wrapped in quotes, otherwise columns shift.

Fixing common problems after pasting

Numbers stored as text. Values like "$1,200" or "15%" may stay as text. Use Find and Replace to remove currency symbols, then format the column as numbers.

Unwanted date conversion. Excel turns values like 3-4 or 1/2 into dates. Format the target column as Text before pasting, or import the CSV with the column type set to Text.

Lost leading zeros. ZIP codes and product codes such as 02134 lose the leading zero. Format the column as Text first.

Hidden characters. Text copied from web pages sometimes includes non-breaking spaces that stop numbers being recognised. The invisible character remover finds and replaces them.

Using Power Query for repeat imports

If you regularly bring AI tables into Excel, Power Query can clean them automatically:

1. Paste the markdown into column A of a sheet and convert it to a table.
2. Choose Data → From Table/Range.
3. Use Split Column → By Delimiter with a custom delimiter of |.
4. Remove the empty columns and filter out the dashes row.
5. Close & Load. Next time, paste new markdown into the same table and click Refresh.

A worked example

An AI answer gives a table of monthly expenses:

| Category | January | February |
|---|---|---|
| Rent | $1,450 | $1,450 |
| Groceries | $412 | $389 |

After converting and pasting:

1. Select columns B and C.
2. Use Find and Replace to remove "$" and ",".
3. Set the format to Currency.
4. Add totals with =SUM(B2:B3).

The table is now ready for charts and formulas.

Formatting the result as an Excel table

Select the range and press Ctrl+T to turn it into an Excel table. You get filter buttons, banded rows and formulas that expand automatically as you add rows.

When the AI's table is wrong

Converting a table doesn't check it. AI-generated numbers can be outdated or simply wrong, and totals in AI tables don't always add up. Before relying on the data:

• Recalculate totals in Excel rather than copying them.
• Check sources for prices, statistics and dates.
• Look for merged ideas, where one row mixes two items.