AI tables into Excel or Sheets
Paste the answer, copy the table, and paste it into a sheet. Each value lands in its own cell, and Excel keeps codes like 007 as written.
This text is long, so only the first part is shown here. Copying and downloading use all of it.
This text is long, so only the first part is shown here. Copying and downloading use all of it.
How to paste it
- Paste the AI answer above. If it has more than one table, pick the one you want.
- Tap Copy table.
- In Excel or Google Sheets, click the cell where the table should start, such as A1 on a new sheet, and paste.
The header row comes through in bold. Formatting inside cells, like bold words or links, is dropped so each cell holds a clean value.
Leading zeros, long numbers and dates
Excel changes some values as you paste them. 007 becomes 7, 1/2 or 2024-01-05 becomes a date, a 13-digit order number turns into 1.23457E+12, and anything starting with = runs as a formula.
MDMelt marks those cells as text, so Excel keeps them exactly as written. Ordinary numbers like 1,280 or 37.5% stay numbers, so you can still add them up.
Date-like values are kept as text too, because Excel can read 03/04 as March 4 or April 3 depending on your settings. If you need real dates for sorting or math, select the column and use Data → Text to Columns, or the DATEVALUE function.
Google Sheets ignores Excel’s text marker. If Sheets changes a value, select the column, choose Format → Number → Plain text, and paste again.
If the table doesn’t split into columns
The answer probably didn’t contain a Markdown table. Copying an answer by selecting it with the mouse often turns the table into spaces or tabs, which can’t be read back reliably.
Use the copy button under the answer instead. If the AI wrote the table as a list, ask it to “put this in a Markdown table” and copy again.
Questions
Can I copy several tables at once?
One at a time. When an answer has more than one table, buttons above the preview let you switch between them.
Why did 007 turn into 7 in Google Sheets?
Sheets doesn’t read the text marker Excel uses. Set the column to Plain text first (Format → Number → Plain text), then paste.
Can I download an .xlsx file?
Not yet. Paste the table into Excel or Sheets and save it from there.
Guides
- How to keep AI formatting in Word and Google Docs
Getting headings, lists and tables from ChatGPT, Claude or Gemini into Word or Google Docs. The built-in options first, then when a converter helps.
- How to paste AI text into Slack, WhatsApp, Telegram and Discord
Chat apps each read their own formatting marks, and Markdown's double asterisks only work in some. App-by-app rules, plus LinkedIn's fake bold.
- What is an .md file, and how do you open one?
An .md file is plain text written in Markdown. How to open one on Windows, Mac, iPhone and Android, and why AI tools keep handing them to you.
- Why ChatGPT answers are full of asterisks
The asterisks and # signs in a pasted AI answer are Markdown. What each symbol means, why it survives the paste, and how to clean it up.