How to use Markdown Table to Excel
A table copied from ChatGPT, Claude or Gemini is a Markdown pipe table: plain text with a | between values and a row of dashes under the header. Excel splits pasted text on tabs, not pipes, so the whole table stacks into column A. Paste it here and the preview shows the exact cells the workbook will contain. Download saves a genuine .xlsx, and Copy puts tab-separated cells on the clipboard that paste straight into Excel, Google Sheets or Numbers as a grid. Every table in the text becomes its own sheet, blank cells stay blank, an escaped \| becomes a pipe, the alignment row and the padding spaces are dropped, and plain numbers become numeric cells you can sum, while codes such as 007 or 1,024 stay text so nothing is silently changed.
- Copy the text or table you want to fix.
- Paste it into the input above. The result updates instantly.
- Copy, download, share, or embed the finished result.
Frequently asked questions
Why does a ChatGPT table paste into one column in Excel?
Because the clipboard holds a Markdown pipe table: plain text with | characters between the values and a row of dashes under the header. Excel and Google Sheets split pasted text on tab characters, not pipes, so each line is treated as one value and the whole table stacks into column A. Converting it first produces real cell boundaries.
Do numbers stay numbers in the .xlsx file?
Plain integers and decimals such as 412, -3.5 or 16.2 become numeric cells you can sum and sort. Anything where the exact characters carry meaning stays text: codes with leading zeros like 007, values with thousands separators like 1,024, currency and percent signs, and exponents. The preview right-aligns exactly the cells that will be numeric.
What happens to blank cells, escaped pipes and the row of dashes?
A blank cell becomes an empty cell rather than shifting the row. A pipe written as \| inside a cell becomes a plain | in the output. The alignment row of dashes and colons is formatting, not data, so it is dropped, and the spaces Markdown pads cells with are trimmed so lookups match.
Can it convert several tables at once?
Yes. Paste the whole answer, prose included. Every pipe table in it is found and becomes its own sheet in the workbook, named Table 1, Table 2 and so on, and the preview shows each sheet before you download.
Can I paste the result into Google Sheets or Numbers without downloading a file?
Yes. Copy puts the cells on the clipboard as tab-separated text, which Excel, Google Sheets and Numbers all paste as a grid with one value per cell. Download is for when you want a file to keep or send.
Is Markdown Table to Excel free, and is my table uploaded?
It is free, with no account and no usage limit. Parsing and the .xlsx file are built in your browser; the table is stored only if you explicitly create a share link.