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.
Claude has no Export to Sheets button — this is it
Gemini puts an Export to Sheets button under the tables it generates. Claude does not, and neither does ChatGPT. Copy a Claude table and paste it into Sheets and you get one cell per row with the | characters still inside, or, if your browser copied a rich version, a grid with stray spaces glued to the numbers. The built-in repair is Data → Split text to columns with a custom separator, then trimming, then deleting the dashes row, then converting the number-shaped text. This page does that in one paste and hands Sheets the table as an HTML grid, which Sheets reads straight into cells.
The paste works for every form Claude uses: the markdown table in a chat answer, the CSV it writes when you ask for importable data, the CSV artifact in the side panel, and the ASCII table with +---+ borders it draws for plain-text output. Each is parsed by its own rules and shown in the same preview before you copy.
Locale, units and the numbers Claude writes
Sheets reads pasted numbers according to the spreadsheet's locale (File → Settings). Claude writes numbers the American way — 12,400.50 — and in a sheet set to a comma-decimal locale that text may be read as 12.4 or left as a string. If your locale is European, the .xlsx route is safer: the tool types the numbers itself from Claude's convention, writes them as numeric cells, and Sheets imports them without guessing.
Claude's habit of putting units in cells — 12 kg, ~$4,200, 3–5 days — keeps those cells as text in either route, because a unit is information the tool should not throw away. Percentages, currency with a leading symbol, thousands separators and negatives in parentheses are all read as numbers. Ask Claude for "numbers only, units in the column header" and every column types cleanly; otherwise, edit the cells in the preview before copying. The hidden characters Claude's copy carries, including the narrow space between a figure and its unit, are removed before the number detection runs.
Several tables, several tabs
A Claude analysis rarely stops at one table. Paste the whole answer and every table is detected and listed in the tabs above the preview, with the prose between them ignored. Copy for Sheets / Excel acts on the selected table. For all of them at once, click Download .xlsx: the workbook has one sheet per table, with the header row bold and frozen and the numbers typed. In Sheets, File → Import → Upload, choose the file, and pick Insert new sheet(s) — each Claude table becomes its own tab, formats included. The workbook is built in your browser; the only upload is the one you make into Drive.
After the paste
Because the cells arrive typed, you can add SUM rows, sort, filter and chart immediately. Dates in ISO form (2024-03-01) are recognised everywhere; ambiguous dates like 03/01/2024 are kept as text by the .xlsx route until you confirm the format with Format → Number → Date. A cell that begins with = is treated as a formula on paste, which is handy when Claude has written a total row as a formula and a surprise when it has not; prefix it with an apostrophe in Sheets if you want the text.
Pasting into Google Sheets
- Copy for Sheets / Excel puts an HTML table on the clipboard; click a cell in Sheets, paste, and the grid lands with the header on that row.
- Several tables: Download .xlsx, then File → Import → Upload in Sheets and choose Insert new sheet(s) for one tab per table.
- Sheets reads numbers by the spreadsheet's locale (File → Settings); the .xlsx route types them so a comma-decimal locale cannot misread 12,400.
- ISO dates (2024-03-01) are recognised everywhere; ambiguous ones (03/01/2024) stay text in the .xlsx until you set the format.
- A pasted cell beginning with = is treated as a formula.