Know-HowAI ToolsGoogle Sheets™MarkdownTables

How to Paste a ChatGPT Table into Google Sheets™

Google Sheets™ has no 'Paste from Markdown', so ChatGPT tables land in a single column full of pipe characters. Here are two reliable ways to turn them into proper rows and columns.

Travis

Travis

Google Sheets™ cannot interpret Markdown on paste. A ChatGPT table either lands in one column or scatters pipe characters across cells. The two fixes: split the text on the `|` delimiter with 'Split text to columns', or convert the selection in one step with the Text To Table Converter Add-On.

Paste a ChatGPT table into Google Sheets™ and you'll typically see each row crammed into a single cell:

markdown
| Product | Q1 | Q2 |
|---------|----|----|
| Widgets | 120 | 145 |
| Gadgets | 80 | 95 |

Unlike Google Docs™, Sheets™ has no 'Paste from Markdown' command, so you need one of the following approaches.

Method 1: Text To Table Converter Add-On (one step)

  1. Paste the ChatGPT table anywhere in your sheet (a normal Ctrl+V / Cmd+V paste is fine).
  2. Select the pasted cells.
  3. Go to Extensions > Text To Table Converter > 🔤 ➜ 🔡 Selected Text to Table.
  4. The Add-On splits the data into proper rows and columns and drops the |---| separator line for you.

For quick styling, select the result and choose a preset under Extensions > Text To Table Converter > Table Styles.

Method 2: 'Split text to columns' (built into Google Sheets™)

  1. Paste the table into a column of cells.
  2. Select those cells and go to Data > Split text to columns.
  3. In the small separator dropdown that appears, choose Custom and type | (the pipe character).
  4. Sheets™ splits each row at the pipes.

You'll still need to clean up by hand: delete the --- separator row, trim stray spaces, and remove the empty columns created by the leading and trailing pipes. It works, but it's several steps every time.

Which method to choose?

Use Split text to columns if this is a one-off and you don't want to install anything. Use the Add-On if you paste AI output regularly — it handles the delimiter, the separator row, and the cleanup in a single action, and works the same in Docs™ and Slides™:

Get the Add-On

Text To Table Converter

免費取得外掛程式

Text To Table Converter

Convert AI tables for free: Use the free Text To Table Converter add-on to turn Markdown into clean rows and columns in Sheets™ — and real tables in Docs™ and Slides™.

免費安裝

Next Step: Understand Why AI Output Breaks