What a copied Gemini answer contains
- Markdown with asterisk bullets (* item), **bold** lead-ins on list items and heading levels that jump from ## to ####.
- The copy button gives markdown text only, so Word, Docs and email show the symbols.
- Has its own Export to Docs and Export to Sheets buttons under answers and tables, for Google accounts.
- Tables often have a bold first column and cells that mix numbers with units ("12 kg").
- Nested lists use four-space indents that some editors ignore.
- Emoji and "Here's a breakdown" openers in casual answers; em dashes in formal ones.
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
- Copy for Sheets / Excel puts an HTML table on the clipboard; Excel reads it into cells and recognises numbers, percentages and dates itself.
- Download .xlsx writes typed numeric cells with thousands, percent and currency formats, a bold frozen header and one sheet per table.
- Codes with leading zeros and digit strings over fifteen characters are kept as text on purpose.
- Dates stay text in the .xlsx; paste instead if you want Excel's date recognition in your regional format.
- A cell starting with = is evaluated as a formula on paste; the .xlsx keeps it as text.