ChatGPT table to Excel converter

How to convert ChatGPT table to Excel online

1. In ChatGPT, Claude or Gemini, copy the table — or the whole answer; the text around the table is ignored.
2. Paste it into the box. Every table in the text gets its own tab, and its own sheet in the XLSX.
3. Click Copy for Excel / Sheets, Copy for Word / Docs, Download XLSX or Download CSV.
4. In the spreadsheet, click the cell where the table should start and paste (Ctrl+V / ⌘V).
5. Optional — how to paste as table in Excel: select a cell of the pasted range, choose Home › Format as Table, pick a style and tick My table has headers (Microsoft).

How to paste ChatGPT table into Excel (and why it lands in one column)

If the text you copied shows | between the cells and a line of dashes under the header, it is a Markdown table. Pasted into Excel as plain text, each line can land in a single cell of column A, because the cells are separated by pipes. In Excel's delimited text files, "the TAB character (ASCII character code 009) typically separates each field of text" (Microsoft). Excel's own fix is Data › Text to Columns › Delimited (Microsoft): tick the Other check box and type | next to it (Microsoft). You then still delete the empty first column and the row of dashes. Google Sheets has Data › Split text to columns, with the separator chosen from a dropdown (Google). 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: a table written with pipes and a dashes row is read the same way whether it comes from a README on GitHub, an Obsidian note, VS Code, or an answer from Claude, Gemini or Copilot. Paste the Markdown or drop the .md file, then copy the table or download XLSX or CSV — a Markdown table to Excel online conversion with nothing to install. The converter reads 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). Cells are "separated by pipes", and the delimiter row holds hyphens with optional colons for alignment, which the Markdown output keeps. A pipe escaped as \| inside a cell is kept as a pipe. Rows with fewer cells than the header are padded with empty cells, as in the spec; rows with more cells keep the extra cells instead of dropping them. Tables inside a > quote block or a list item are read too. Bold, italics, links, images and code marks inside cells are removed by default — untick "Remove bold, links and code marks" to keep the raw text.

Copy table from ChatGPT to Word or Google Docs

Copy ChatGPT table to Google Docs or Word as a real table: paste it into the converter and click Copy for Word / Docs. The clipboard gets an HTML table with a header row, plus the same rows as tab-separated text. In Word, paste with Ctrl+V (⌘V). Microsoft says that "by default, Word preserves the original formatting when you paste content" (Microsoft), so Word keeps the pasted table's source formatting; the Keep Text Only option would instead turn it into "a series of paragraphs". In Google Docs, paste with Ctrl+V (⌘V), not Ctrl+Shift+V, which is "Paste without formatting" (Google). 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). Bold, italics and links inside cells are not kept. 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: the page recognises the tab- or comma-separated text, shows the grid and points you to Copy as Markdown under the buttons. The result is a padded GitHub-style table with a header row and a dashes row, 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 and column widths fitted to the text. Plain numbers such as 1,240 or -7 become numeric cells in the format they were written in; percentages such as 12.5% become numbers with a percent format; ISO dates from 1900-03-01 onwards, such as 2026-03-01, become date cells (earlier dates stay text, because Excel's 1900 date system has no serial numbers for them). Values that would lose information stay text: numbers with a leading zero (007, a ZIP code such as 02134) and runs of 12 or more digits — barcodes, long IDs, card and account numbers — because Excel keeps 15 significant digits: "any numbers past the 15th digit are rounded down to zero" (Microsoft). Currency signs and units (€12, 5 kg) also stay text. There are no formulas, styles or macros. Excel itself accepts up to "1,048,576 rows by 16,384 columns" and "32,767 characters" in a cell (Microsoft). The CSV is UTF-8 with a byte-order mark and comma separators. Excel opens a .csv file directly from File › Open and "uses the current default data format settings to interpret how to import each column of data" (Microsoft), so 007 can become 7 there; the XLSX keeps it as text, and the status line under the buttons tells you when a copy or a CSV contains such values. One safety rule applies to the CSV and to 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.

FAQ