Gemini in Sheets: analysis without the headache.
Google Sheets has long been the underdog to Excel — but Gemini closes that gap fast. Four workflows turn Sheets into a real analytical tool: formula generation in plain English, Smart Fill, data cleaning, and charts from a sentence. We'll start with the one that feels like magic.
Three Sheets changes landed in Google's September 11 Workspace recap that matter for this lesson. Gemini in Sheets now works on Android — tap the Gemini spark icon in the Sheets app to analyze data, ask questions, and build charts on the go (the same asks as the web side panel, smaller screen). The cell limit doubled to 20 million for new, existing, and imported files, which removes the ceiling that used to push big datasets back to Excel. And pivot tables got a dedicated formula editor for calculated fields, so the derived-metric workflow in section 03 no longer means typing formulas into a one-line box. If you also use Gemini on a PC, Google's new Gemini app for Windows puts these same Sheets asks behind an Alt + Space shortcut.
Roughly Excel + Copilot, in your ecosystem.
If you've eyed Excel because Copilot makes data work easier — Gemini does most of the same things in Sheets, with tighter ties to the rest of Workspace. The capabilities are close; the real choice is which ecosystem you already live in.
Type two, get the rest.
Column A has names with the company in parentheses. You've typed the company into column B for the first two rows. Hit Smart Fill and watch Gemini spot the pattern and finish the column.
| A · Full name (Company) | B · Company |
|---|
Your Sheets toolkit.
Describe the result; get the formula. SUMIFS, QUERY(), rolling totals, gnarly IF chains.
Type 2–3 examples in a new column; it fills the rest from the pattern.
Describe what's wrong in the side panel; it suggests the transform.
Skip the chart wizard — describe the chart you want.
Pick the right Sheets workflow.
Spot-check generated formulas on edge cases (month boundaries, empty cells). Work on a copy before cleaning — some transforms aren't cleanly reversible. And Gemini's charts are functional, not magazine-quality, so tidy labels and legends before anything customer-facing.
Rebuild a real spreadsheet with Gemini
Pick a sheet you once spent 60+ minutes building by hand. In a fresh Sheet, rebuild it using only the four workflows — generate the formulas, Smart Fill the derived columns, clean the messy data, chart the result. Time yourself against the original.
What you can do now
- Generate complex formulas by describing the result you want
- Use Smart Fill for any derived-column work — two examples, then go
- Clean messy data with side-panel suggestions (on a copy)
- Build charts from a one-sentence description
- Spot-check Gemini's edge-case errors before trusting the output