What a copied Claude answer contains
- Writes in markdown: **bold**, ## headings, - lists two or three levels deep, fenced code with a language tag, pipe tables.
- The copy button under an answer gives markdown text; the copy button inside an Artifact gives the artifact's raw source (markdown, HTML or code).
- Numbered lists restart at 1 after a paragraph break, so word processors merge or renumber them.
- Uses spaced en dashes (–) and em dashes (—) freely; both read as the AI tell.
- Opens with a short preamble ("Here's a version that…") that rarely belongs in the document.
- Numbers and units can carry a narrow no-break space ("3 PM", "5 km") that word processors refuse to wrap on.
The three shapes a Claude table arrives in
Claude produces tables in three different forms, and each pastes into Excel badly in its own way. In the chat, a table is markdown: rows of text with cells divided by | and a line of dashes under the header. Copy it and Excel puts each row into one cell, pipes included. When you ask for data you can import, Claude often answers with a CSV block or a CSV artifact — comma-separated lines with quoted fields — which Excel will open from a file but, pasted, lands in one column. And when Claude is explaining a terminal output or a plain-text report, it draws an ASCII table with +---+---+ borders, which no spreadsheet reads at all.
This page detects all three. Markdown pipes are split on the unescaped | characters and the dashes row identifies the header. CSV is parsed by the RFC 4180 rules, so a quoted field containing a comma, a line break or a doubled quote stays one cell. ASCII borders are treated as separators and the border under the first row marks the header. Whatever the shape, you get the same grid, the same preview and the same three routes into Excel.
Claude's cells: units, notes and the numbers inside them
Claude likes a helpful table. It writes 12 kg rather than 12, ~$4,200 rather than 4200, N/A for a missing value and a footnote marker after a figure it is unsure of. For a reader that is considerate; for a spreadsheet it means the column is text and the total is zero. The number detection here reads the common forms a spreadsheet user expects — thousands separators, a leading $, € or £, a trailing %, parentheses or a minus for negatives — and types those cells as numbers in the .xlsx. A value with a unit attached stays text, which is the honest choice; ask Claude for a separate unit column, or strip the units in the preview, and the column adds up.
Claude also bolds the first column of a comparison table and occasionally the header cells, with **asterisks**. The markers are removed from the cells on paste, and the header row is written bold in the .xlsx regardless. Hidden characters — the narrow space Claude puts between a number and its unit, non-breaking spaces from a copied web source — are stripped before the number detection runs, which is the usual reason a pasted figure refuses to sum.
Analyses with several tables
A Claude analysis often contains more than one table: a summary, then a breakdown by month or by region, then a sensitivity table. Paste the whole answer. Every table is found separately and listed in the tabs above the preview; prose between them is ignored. Copy for Sheets / Excel and the CSV download work on the table you have selected, and Download .xlsx writes all of them, one per sheet, in the order Claude wrote them. That is usually the fastest way to turn a Claude analysis into a workbook you can build on.
Asking Claude for a better table in the first place
Two prompts make the conversion cleaner. "Give me the table as CSV with a header row, numbers only in numeric columns, units in the column name" produces data that types perfectly. And "one table per section, no notes inside cells" keeps footnotes out of the figures. Claude follows both reliably, and the result pastes into Excel with every column numeric and nothing to fix.
Pasting into Excel
- Copy for Sheets / Excel puts an HTML table on the clipboard; Excel reads it into cells and recognises numbers, percentages and dates itself.
- Download .xlsx writes typed numeric cells with thousands, percent and currency formats, a bold frozen header and one sheet per table.
- Codes with leading zeros and digit strings over fifteen characters are kept as text on purpose.
- Dates stay text in the .xlsx; paste instead if you want Excel's date recognition in your regional format.
- A cell starting with = is evaluated as a formula on paste; the .xlsx keeps it as text.