Export to Sheets works for one table into a new spreadsheet. For a Gemini table going into a sheet you already have, an answer with several tables, or figures that arrived as text, paste the table here and copy it as real cells with the numbers typed.
Gemini's Export to Sheets creates a new spreadsheet. For a table going into a sheet you already have, copy the table in Gemini, paste it into the box above, click Copy for Sheets / Excel, then click a cell in your sheet and paste: the grid lands with the header on that row and numbers recognised. For several tables, Download .xlsx and use File → Import to add each as a tab. Nothing is uploaded.
Use the copy button under the answer or select the text. Gemini's copy gives markdown text; either form is read correctly here.
The table is detected as you paste and shown as a grid. Switch tables with the tabs if the answer had more than one.
Click Copy for Sheets / Excel and paste into Google Sheets, or Download .xlsx for a typed file.
Export to Sheets is the best table button any assistant has, and when a Gemini table is the whole answer and you want it in a fresh spreadsheet, use it. It falls short in three everyday cases. First, an existing sheet: the export always creates a new spreadsheet, so getting the table next to your other data means a second copy-paste between two sheets. Second, several tables: an answer with a summary table and a breakdown exports one at a time, each into its own new file. Third, text numbers: when a Gemini cell says ~$4,200 or 12 kg, the export carries it as text, and the column does not sum.
This page covers those three. Paste the table — or the whole answer — and every table is detected. Copy for Sheets / Excel hands your sheet an HTML grid that pastes at the cell you click, with the header on that row. Download .xlsx writes all the tables as one workbook that File → Import adds to your spreadsheet as tabs. And the number detection types the figures that Export leaves as text.
Gemini bolds the first column of its tables and writes units into cells. The bold markers are removed on paste. Units are kept, because 12 kg is not a number and dropping the unit would misrepresent the data — ask Gemini for "numbers only, units in the column header" and the column types cleanly. Thousands separators, a leading $, € or £, a trailing % and negatives in parentheses are read as numbers; in the .xlsx they are written as numeric cells with the matching format, and on paste Sheets recognises them itself.
Locale matters in Sheets. A sheet set to a comma-decimal locale (File → Settings) may read Gemini's 12,400 as 12.4 on a plain paste. The .xlsx route avoids the guess: the tool types the numbers from Gemini's American convention and Sheets imports typed cells. ISO dates are recognised in any locale; ambiguous ones stay text until you set the format.
Paste the whole Gemini answer. Each table appears in the tabs above the preview, with the prose between them ignored. Click Download .xlsx and you have one workbook with one sheet per table, header rows bold and frozen, numbers typed. In Google Sheets, File → Import → Upload, choose the file, and pick Insert new sheet(s): every 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.
If you have Gemini in Google Workspace, the side panel in Sheets can build a table in place from a prompt, which skips the clipboard entirely for simple data. The Gemini app and website are still where the longer research answers come from, and those are the ones with several tables and cells full of qualifiers. Use Export to Sheets for a single clean table into a new file, the side panel for quick in-place data, and this page for everything headed into a sheet that already exists.
Export makes a new spreadsheet with one table. Use this page when the table is going into a sheet you already have, when the answer has several tables, or when Export left figures with units or symbols as text.
Paste the table here, click Copy for Sheets / Excel, click the cell in your sheet and paste. The header lands on that row and the data below it.
Yes. Paste the whole answer, Download .xlsx, then File → Import → Upload in Sheets and choose Insert new sheet(s). Each table becomes its own tab.
Export carries cell text as written. Here the number detection reads currency, thousands separators and percentages and types them, so the column sums; a figure with a unit attached stays text on purpose.
No. The conversion runs in your browser with client-side JavaScript. The Gemini answer is never sent to a server, stored or logged.