AI Text FormatterOpen the tool
Gemini → Excel

Gemini to Excel

Gemini's Export to Sheets button does not reach Excel. Paste the table here and copy it into Excel as real cells, or download a .xlsx with numbers, percentages and currency typed, a bold frozen header and every table from the answer on its own sheet.

How do I get a Gemini table into Excel?

Select the table in Gemini, copy, and paste it into the box above. Click Copy for Sheets / Excel and paste into Excel for separate columns with numbers recognised, or Download .xlsx for a typed workbook. Gemini's bold first column and the units it writes into cells are handled, and several tables become several sheets. Everything runs in your browser; 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 Gemini

    Use the copy button under the answer or select the text. Gemini'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 Excel

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

What a copied Gemini answer contains

Export to Sheets, then Excel? There is a shorter way

Gemini puts an Export to Sheets button under the tables it generates. It works, for Google Sheets. Getting from there to Excel means downloading the sheet as .xlsx, opening it, and copying the table into the workbook you actually wanted it in — three steps and a stray file for one table. Copying the table directly and pasting into Excel is worse: the clipboard holds markdown, Excel sees text with | characters, and each row lands in one cell.

This page is the direct route. Paste the copied table and it is read as a grid: the markdown pipes are split, the dashes row marks the header, the **bold** Gemini puts on the first column is removed from the cells, and the hidden characters are stripped. Then Copy for Sheets / Excel gives Excel an HTML table it reads straight into cells, or Download .xlsx gives you a workbook with the numbers already typed.

What Gemini writes into cells

Gemini's tables are readable rather than tidy. The first column is bold. Figures carry units — 12 kg, ~$4,200, 3–5 days — and a footnote-style qualifier sometimes follows a number. An empty value is N/A or a dash. For a human that is helpful; for Excel it means text where you wanted numbers. The number detection here reads the forms a spreadsheet user expects — thousands separators, a leading $, € or £, a trailing %, negatives in parentheses or with a minus — and types those cells as numbers in the .xlsx. A figure with a unit stays text, deliberately; ask Gemini for "numbers only, units in the column header" and the whole column types.

When you paste rather than download, Excel runs its own recognition on the cell text and will also read dates in your regional format. Either way, the narrow no-break space Gemini sometimes puts between a figure and its unit is removed first; a non-breaking space glued to a number is the usual reason a column refuses to sum.

One answer, several tables

Gemini answers to comparison questions often contain two or three tables with prose between them. Paste the whole answer: each table is detected separately and listed in the tabs above the preview, the prose is ignored, and Download .xlsx writes one sheet per table in the order they appeared. Copy for Sheets / Excel and the CSV download work on the table you have selected. For a workbook you will build on, the .xlsx route is usually the fastest — the header row is bold and frozen, and the columns are already sized to their content.

Gemini inside Excel? Not quite

Gemini lives in Google Workspace, so there is no Gemini side panel in Excel the way there is in Sheets. If you work in Excel and ask Gemini for data, the copied-table route on this page is the equivalent of the Export button you do not have. It also reads CSV, if you asked Gemini for "the data as CSV", and the ASCII tables Gemini draws when it is quoting command-line output.

Pasting into Excel

Frequently Asked Questions

Can Gemini export a table to Excel directly?

No. Export to Sheets makes a Google Sheet; reaching Excel from there means a download and a second copy-paste. Pasting the table here and clicking Copy for Sheets / Excel or Download .xlsx is the direct route.

Why is Gemini's first column bold in the preview?

It is not — the **asterisks** Gemini puts around the first column are removed from the cells. The header row is bold in the .xlsx because it is the header, not because Gemini bolded it.

Do Gemini's percentages and currency come through as numbers?

Yes. 8.5% is stored as 0.085 and formatted as a percentage; $4,200 is stored as 4200 with a dollar format. Figures with units attached stay text, so ask for units in the column header if the column needs to add up.

What if the answer has three tables?

All three are detected. Switch between them with the tabs for copying; Download .xlsx writes them as three sheets in one workbook.

Is my text uploaded anywhere?

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

Related tools