AI Text FormatterOpen the tool
DeepSeek → Google Sheets

DeepSeek to Google Sheets

Paste a DeepSeek table — or the whole answer with its reasoning — 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. The <think> block is ignored.

How do I paste a DeepSeek table into Google Sheets?

Copy the table in DeepSeek, 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 the numbers recognised; a <think> block in the copy is ignored. For several tables, click Download .xlsx and use File → Import in Sheets to add each as a tab. Nothing is uploaded.

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 DeepSeek

    Use the copy button under the answer or select the text. DeepSeek's copy gives markdown text, sometimes with the reasoning block in front; 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 DeepSeek answer contains

Why DeepSeek pastes need a filter first

Paste a DeepSeek table straight into Sheets and the markdown pipes put each row into one cell; Data → Split text to columns repairs that, slowly. The DeepSeek-specific problem is upstream of the pipes. When the copy includes the model's <think> reasoning — a drag-select from above the answer, the API, a local model through Ollama or LM Studio, a third-party client — it includes the model's draft tables too, and a split-and-clean routine cannot tell a draft from the answer. This page discards the reasoning block before it looks for tables, so what you see in the preview is the table DeepSeek gave you, not the three it considered.

From there the route is the same as for any table: Copy for Sheets / Excel hands Sheets an HTML grid that pastes at the cell you click, header on that row, with Sheets recognising the numbers itself; Download .xlsx gives you a typed workbook for File → Import.

Numbers, locale and DeepSeek's cells

DeepSeek's cells are mostly plain numbers, which is good news for typing. Thousands separators, a leading currency symbol, a trailing % and negatives in parentheses are read as numbers; the **bold** on the first column is removed; figures with units or LaTeX stay text, deliberately. Sheets reads pasted numbers by the spreadsheet's locale (File → Settings); in a comma-decimal locale a plain paste of 12,400 may be read as 12.4, so the .xlsx route is safer there — the tool types the numbers from the American convention DeepSeek uses and Sheets imports typed cells.

Watch for a full-width Chinese comma or colon in an otherwise English table, which DeepSeek emits occasionally; it is not read as a separator and the preview makes it visible. ISO dates are recognised in any locale; ambiguous ones stay text until you set the format.

Several tables into one spreadsheet

DeepSeek's analytical answers often hold a summary table and several breakdowns. Paste the whole answer — reasoning and all — and every table in the answer is detected and listed in the tabs above the preview. Download .xlsx writes one sheet per table, headers bold and frozen, numbers typed. In Google Sheets, File → Import → Upload, choose the file, pick Insert new sheet(s), and each table becomes a tab in the spreadsheet you already have. The workbook is built in your browser; the import is the only upload, and you make it.

A cleaner table from the prompt

DeepSeek follows formatting instructions reliably. "Final table as CSV, header first, numbers only, units in the column names, no LaTeX" produces data that pastes as columns and types without help, and "no reasoning" keeps the <think> block out where the client supports it. The paste here reads whatever it is given — CSV, markdown pipes, an ASCII grid — so the prompt is an optimisation, not a requirement.

Pasting into Google Sheets

Frequently Asked Questions

Will the draft tables from the <think> block show up?

No. The reasoning block is discarded before tables are detected, so only the answer's tables are listed, copied and written to the .xlsx.

My Sheets locale uses comma decimals — is that a problem?

On a plain paste it can be. Use Download .xlsx and File → Import: the numbers are typed by the tool from DeepSeek's American convention, so Sheets does not interpret the text.

How do I get several DeepSeek tables into separate tabs?

Paste the whole answer, Download .xlsx, then File → Import → Upload in Sheets with Insert new sheet(s). Each table becomes its own tab.

What happens to LaTeX in a cell?

It stays as text. Ask DeepSeek for plain-text maths if the column needs to compute, or edit the cell in the preview.

Is my text uploaded anywhere?

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

Related tools