ChatGPT table to Excel converter
Free: copy ChatGPT table to Excel, Google Sheets, Word or Google Docs, or download CSV or XLSX — the text is never uploaded.
Pasting into a prompt instead?
Nothing is uploaded: the text stays in this browser tab. Drop a .md, .txt or .csv file anywhere on the page to open it.
How to convert ChatGPT table to Excel online
- Copy the table from ChatGPT, Claude or Gemini — or the whole answer; the text around the table is ignored.
- Paste it into the box; every table in the text gets its own tab and its own sheet in the XLSX.
- Click Copy for Excel / Sheets, Copy for Word / Docs, Download XLSX or Download CSV.
- In the spreadsheet, click the cell where the table should start and paste (Ctrl+V / ⌘V).
- Optional — how to paste as table in Excel: select a pasted cell, pick a style under Home › Format as Table and tick My table has headers (Microsoft).
How to paste ChatGPT table into Excel (and why it lands in one column)
Pasted into Excel as plain text, each line of a Markdown table can land in a single cell of column A, because its cells are separated by pipes, while Excel's delimited text files typically separate fields with a TAB (Microsoft). Excel's own fix is Data › Text to Columns › Delimited (Microsoft), with the Other check box ticked and | typed next to it (Microsoft). This page does the split for you: Copy for Excel / Sheets puts tab-separated text on the clipboard, drops the dashes line and keeps the header in the first row.
Markdown table to Excel converter — not only for ChatGPT
The same page is a free Markdown to Excel converter for GitHub Flavored Markdown tables — "a single header row, a delimiter row separating the header from the data, and zero or more data rows" (GFM spec 0.29) — whether they come from a README on GitHub, an Obsidian note, VS Code, or an answer from Claude, Gemini or Copilot. Alignment colons in the delimiter row are kept in the Markdown output; rows with fewer cells than the header are padded with empty cells, as in the spec, and rows with more cells keep the extra cells instead of dropping them. Tables inside a > quote block or a list item are read too.
Copy table from ChatGPT to Word or Google Docs
Copy ChatGPT table to Google Docs or Word as a real table with Copy for Word / Docs: the clipboard gets an HTML table with a header row, plus the same rows as tab-separated text. To bring a ChatGPT table to Word, paste with Ctrl+V (⌘V): Word keeps the pasted table's source formatting by default (Microsoft); if a paste still arrives as plain text, select it in Word and use Insert › Table › Convert Text to Table with Separate text at: Tabs (Microsoft). If the browser blocks the clipboard, the tab-separated text appears in a box under the buttons for you to copy by hand.
Excel to Markdown table — for a prompt
The same box works the other way round: paste cells copied from Excel or Google Sheets, or a CSV, and Copy as Markdown under the buttons gives a padded GitHub-style table, ready to paste into a prompt for ChatGPT, Claude or Gemini.
What the XLSX contains
One sheet per table, named Table 1, Table 2 and so on, with the header in row 1, column widths fitted to the text, and no formulas, styles or macros. Percentages get a percent format, and ISO dates before 1900-03-01 stay text, because Excel's 1900 date system has no serial numbers for them. Numbers with a leading zero, such as a ZIP code (02134), and runs of 12 or more digits, such as long IDs, stay text, because Excel keeps 15 significant digits: "any numbers past the 15th digit are rounded down to zero" (Microsoft).
The CSV is UTF-8 with a byte-order mark and comma separators. When Excel opens a .csv from File › Open, it "uses the current default data format settings to interpret how to import each column of data" (Microsoft), so 007 can become 7 there while the XLSX keeps it as text; the status line under the buttons tells you when a copy or a CSV contains such values. In the CSV and in Copy for Excel / Sheets, a cell that starts with =, +, - or @ and looks like a formula gets a leading apostrophe, so that Excel shows it as text instead of running it; plain numbers such as -7 or +44 are left alone.
Facts checked on 24 September 2026 against the publishers' own documentation: GitHub Flavored Markdown Spec 0.29 — Tables (extension), Microsoft — Excel specifications and limits, Microsoft — Keeping leading zeros and large numbers, Microsoft — Split text into different columns, Microsoft — Text Import Wizard, Microsoft — Import or export text (.txt or .csv) files, Microsoft — Create and format tables, Microsoft — Control the formatting when you paste text (Word), Microsoft — Convert text to a table or a table to text (Word), Google Docs Editors Help — Split text, remove duplicates, or trim whitespace, Google Docs Editors Help — Keyboard shortcuts for Google Docs, Gemini Apps Help — Export responses from Gemini Apps. TableGale is an independent tool, not affiliated with OpenAI, Anthropic, Google, GitHub or Microsoft.
Going the other way? Paste cells from Excel or Google Sheets into the converter and click Copy as Markdown — the same page turns a spreadsheet into a Markdown table for ChatGPT and Claude. All TableGale tools · About the site
FAQ
How to copy table from ChatGPT to Excel?
Paste the table (or the whole answer) into the TableGale converter, click Copy for Excel / Sheets, then click cell A1 in Excel and press Ctrl+V (⌘V on a Mac). The clipboard holds tab-separated text, so each cell gets its own column and the header stays in row 1. If you prefer a file, Download XLSX gives a workbook in which numbers, percentages and ISO dates are already stored as numbers.
Is my table uploaded to a server?
No: the text is read and converted by JavaScript in your browser, no server receives it, nothing is stored, and the page sets no cookies — on the Network tab of your browser's developer tools, no request carries your text. The only extra download is the XLSX writer (280 KB), fetched from tablegale.top the first time you click Download XLSX. Once the page has loaded, copying and Download CSV work offline; Download XLSX does too after its first use in that tab.
Why does a ChatGPT table paste into one column in Excel?
Usually because the copied text is a Markdown table, with cells separated by | and a line of dashes under the header, while Excel's delimited text files typically separate fields with a TAB, as Microsoft's import help says. To repair a paste that sits in column A, use Data › Text to Columns › Delimited, tick Other and type |, then delete the empty first column and the row of dashes. Copy for Excel / Sheets in the TableGale converter skips these steps.
How to paste ChatGPT table into Google Sheets?
Paste the table into the TableGale converter, click Copy for Excel / Sheets, then select a cell in Google Sheets and press Ctrl+V or ⌘V. If a paste still lands in one column, use Data › Split text to columns and pick the separator in the dropdown, as Google's help describes. You can also download the CSV and import it.
Copy table from Claude to Excel — does it work the same way?
Yes, when the table is written in GitHub Flavored Markdown: a header row, a delimiter row of hyphens and cells separated by pipes, as the GFM spec defines it. Paste the answer from Claude, Gemini or Copilot into the TableGale converter and click Copy for Excel / Sheets or Download XLSX, where several tables in one answer become separate sheets. Gemini also has its own Export to Sheets button at the bottom right of a table when you are signed in, which saves the table as a new spreadsheet in Google Drive; tables with images can't be exported that way (Gemini Apps Help).
Markdown to Excel table: does it read Obsidian, GitHub and VS Code tables?
Yes, if they use the GitHub Flavored Markdown table syntax — pipes between cells and a dashes row under the header. Paste the Markdown, or drop or open the .md file, then copy the result or download XLSX or CSV. A pipe escaped as \| stays inside its cell, and bold, italics, links, images and code marks are removed unless you untick "Remove bold, links and code marks".
Are numbers and dates kept as numbers in the XLSX?
Yes: plain numbers (1,240.5 or -7), percentages (12.5%) and ISO dates from 1900-03-01 onwards (2026-09-24) become numeric cells in the format they were written in, so sums and sorting work at once. Numbers with leading zeros such as 007, runs of 12 or more digits such as barcodes, card or account numbers (Excel keeps only 15 significant digits) and currency signs or units (€12, 5 kg) stay text. Untick "Numbers and dates as numbers" to keep every cell as text.
How to copy table from ChatGPT to Word without losing formatting?
Paste the table into the TableGale converter, click Copy for Word / Docs and paste the HTML table it copies into Word with Ctrl+V (⌘V): Microsoft states that "by default, Word preserves the original formatting when you paste content", so avoid Keep Text Only, which turns tables into "a series of paragraphs". In Google Docs, use Ctrl+V rather than Ctrl+Shift+V, which is Paste without formatting. Bold, italics and links inside cells are not kept.
How to paste Excel table into ChatGPT?
Copy the cells in Excel or Google Sheets, paste them into the TableGale converter — it recognises tab- and comma-separated text — and click Copy as Markdown. You get a padded Markdown table with a header row and a dashes row; paste it into your prompt for ChatGPT, Claude or Gemini.
How big a table can I convert?
Everything runs in your browser, so the limit is your device's memory rather than a quota: tens of thousands of rows convert in well under a second on a laptop. The preview shows the first 50 rows; copies and downloads include every row. Excel itself takes up to 1,048,576 rows by 16,384 columns and 32,767 characters in a cell, according to Microsoft's specifications page.