AI Text FormatterOpen the tool
Claude → Google Sheets

Claude to Google Sheets

Paste a table from Claude — markdown in the chat, a CSV artifact, or an ASCII grid — and copy it into Google Sheets as real cells with the numbers recognised, or download a .xlsx and import each table from the answer as its own tab.

How do I paste a Claude table into Google Sheets?

Copy the table in Claude, paste it into the box above, click Copy for Sheets / Excel, then click a cell in Google Sheets and paste. The grid lands with the header on that row and numbers, percentages and dates recognised. For an answer with several tables, click Download .xlsx and use File → Import in Sheets to add each one as a tab. Nothing is uploaded; the conversion runs in your browser.

Tip: select the table in ChatGPT (or on any web page) and paste it here. Markdown, tab-separated, CSV and copied web tables are all detected.

How to use it

  1. Copy the answer in Claude

    Use the copy button under the answer or select the text. Claude's copy gives markdown text; either form is read correctly here.

  2. Paste it above

    The table is detected as you paste and shown as a grid. Switch tables with the tabs if the answer had more than one.

  3. Copy for Google Sheets

    Click Copy for Sheets / Excel and paste into Google Sheets, or Download .xlsx for a typed file.

What a copied Claude answer contains

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

Frequently Asked Questions

Can I paste a CSV artifact from Claude into Sheets?

Yes. Copy the artifact with its panel's copy button, paste here, and the comma- or semicolon-separated text is parsed by the CSV rules, quoted fields included. Then Copy for Sheets / Excel and paste into a cell, or download the .xlsx and import it.

My Sheets locale uses a comma for decimals — will Claude's numbers break?

They can on a plain paste, because 12,400 is read as 12.4 in a comma-decimal sheet. Use Download .xlsx and File → Import instead: the numbers are typed by the tool from Claude's American convention, so Sheets does not have to interpret the text.

How do I get several Claude tables into separate tabs?

Paste the whole answer, click Download .xlsx, then in Sheets use File → Import → Upload and choose Insert new sheet(s). Each table becomes its own tab with the header bold and the numbers typed.

Why did a cell with a unit stay text?

Because 12 kg is not a number, and dropping the unit silently would misrepresent the data. Ask Claude to put units in the header, or edit the cell in the preview, and the column becomes numeric.

Is my text uploaded anywhere?

No. The conversion runs in your browser with client-side JavaScript. The Claude answer is never sent to a server, stored or logged.

Related tools