How to Copy a ChatGPT Table Into Excel or Google Sheets (Cleanly)

Why a ChatGPT table pastes into Excel as one column of pipe characters, and three fixes: paste from the rendered view, Text to Columns, or a markdown converter.

Ask ChatGPT for a comparison and it hands you a tidy table. Copy it, paste it into Excel, and you get a single column of lines with pipe characters in them, plus a row of dashes. The table is there; it is just in the wrong format. This guide explains why and shows three ways to get real rows and columns, in order of effort.

Why pipes paste as text

Chat assistants write tables in markdown. A row looks like this in the source:

| Plan | Price | Users |
|------|------:|-------|
| Basic | $10 | 1 |
| Team | $40 | 5 |

The chat window renders that into a grid. When you click the copy icon, most interfaces copy the source above rather than the grid. Excel and Google Sheets split pasted text into cells on tab characters and line breaks, and they have no idea a pipe means "next cell". So each line becomes one cell, pipes and all, and the second line of dashes comes along as a bonus row.

Occasionally the opposite happens: you paste and get a real grid. That means the copy operation included HTML and the spreadsheet accepted it. It depends on the interface, the browser and how you selected the text, which is why the behaviour seems random.

Fix 1: Copy from the rendered table

Instead of the copy icon, select the table on screen by dragging from the first cell to the last, then press Ctrl+C. This often copies the HTML table, and Excel or Sheets will paste it as cells. It is worth trying first because it takes five seconds. It fails when the selection grabs surrounding text, when the interface renders the table in a way the browser does not treat as an HTML table, or when the rendered cells carry formatting you do not want. If you get a grid, tidy the formatting with Paste Special, Values, and you are done.

Fix 2: Text to Columns in Excel or Sheets

If you already have the pipe-separated lines in a column, split them in place.

Excel

1. Select the cells that contain the rows.
2. Go to Data, Text to Columns.
3. Choose Delimited, then Next.
4. Untick Tab, tick Other, and type | in the box. Tick Treat consecutive delimiters as one only if your rows have no empty cells, otherwise leave it off.
5. Click Finish.

Google Sheets

1. Select the cells.
2. Go to Data, Split text to columns.
3. In the small separator dropdown that appears, choose Custom and type |.

Both methods leave you with cleanup: the leading and trailing pipe on each row produce an empty first and last column, the separator row of --- becomes a row of dashes to delete, and every cell has a space on either side that you must trim (=TRIM() or Find and Replace). It works, but it is five steps every time.

Fix 3: Convert the markdown first

The Markdown Table to Excel converter does the splitting, trimming and separator-row removal before the text touches the spreadsheet.

1. Copy the ChatGPT table with the copy icon, or select the whole answer. The converter finds the table inside surrounding text.
2. Paste it into the converter. It shows a preview grid so you can check the columns lined up.
3. Click Copy for Excel / Sheets. The clipboard now holds tab-separated rows.
4. Click the destination cell in Excel or Sheets and press Ctrl+V. Each value lands in its own cell.

Escaped pipes inside cells (\|) are handled, alignment markers in the separator row are ignored, bold and other inline markdown inside cells is stripped, and multiple tables in one paste are converted one after another. You can also download the result as a CSV file if you need to import it somewhere that does not accept a paste.

CSV gotchas worth knowing

People often ask the assistant for CSV instead of a table, expecting it to be simpler. It is not, for three reasons.

• Commas inside values. A cell like Smith, John or $1,200 must be wrapped in double quotes, and any double quote inside must be doubled. Assistants frequently get this wrong, so the columns shift on import.
• Locale. Excel reads a CSV using your system's list separator. In much of Europe that is a semicolon, so a comma-separated file opens as one column. The workaround is Data, From Text/CSV, where you can choose the delimiter explicitly.
• Encoding. A UTF-8 file opened by double-clicking can garble accented letters and currency symbols in older Excel versions, because Excel guesses the encoding. Again, From Text/CSV lets you pick UTF-8.

Tab-separated text sidesteps all three: tabs almost never appear inside a value, every spreadsheet treats a tab as a column break regardless of locale, and pasting goes through the clipboard rather than a file, so there is no encoding guess. That is why the converter's copy button uses tabs and reserves CSV for the download.

When numbers refuse to be numbers

After a successful paste, you may find that =SUM() returns zero or that the column is left-aligned, meaning Excel stored the values as text. Look for:

• A currency symbol or percent sign inside the cell. Remove it with Find and Replace, then set the number format.
• A non-breaking space, which assistants sometimes put between a number and its unit. It looks like a space and is not one. Run the table through the AI Text Cleaner, which turns it into a normal space, or strip it from the column with =SUBSTITUTE(A2,CHAR(160),"").
• Curly quotes or apostrophes used as thousands separators in some locales. The smart quotes converter straightens them.
• Invisible characters such as zero-width spaces, which make two identical-looking cells fail a VLOOKUP. See hidden characters in text for how to find and remove them.

Once the cells contain only digits, a decimal point and an optional minus sign, select the column and use Data, Text to Columns, Finish with no changes; that trick forces Excel to re-evaluate the cells as numbers.

Last updated 2026-09-16. Everything on this page runs in your browser. Nothing you type or upload leaves your device.