How to Paste a ChatGPT Table into Google Sheets™

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:

| 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™:

• Paste a ChatGPT table into Google Docs™
• Paste a ChatGPT table into Google Slides™

Get the Add-On#

Get the Add-On - Free

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™.

Install free

Next Step: Understand Why AI Output Breaks#

• Why ChatGPT Output Looks Broken When You Paste It into Google Docs™ - The Markdown explanation behind the pipes and asterisks, and every fix in one place.
• Google Docs™ Has No 'Convert Text to Table' — 3 Ways to Do It - The hub guide: every way to turn plain text into a real table.