Google Sheets Smart Fill — The Complete Guide
Smart Fill is the most underrated AI feature in Google Sheets. It's free, built in, has existed for years, and quietly handles most of the data cleanup tasks people install add-ons for. Type 2-3 examples, accept the suggestion, done. This guide covers everything Smart Fill actually does, when to use it, when it fails, and the 15 patterns you'll use every week.
⚡ Quick Answer
Smart Fill in Google Sheets is pattern-detection AI. Type 2-3 examples of what you want a column to look like — extracted first names, reformatted dates, extracted email domains — and press Ctrl+Shift+Y (or watch for the "Smart Fill" suggestion tooltip) to fill the rest. Free, built-in, no setup. Great for one-off cleanups; use formulas for anything that needs to update over time.
📋 What we'll cover
What Smart Fill actually does
Smart Fill watches the columns to the left of your active column. When you type a value that appears to be a transformation of the leftward data, Sheets infers the pattern and suggests filling the rest of the column with the same transformation.
Example: you have full names in column A. You type "John" in B2 (the first name of A2). Smart Fill guesses you want first names in column B and offers to fill B3:B1000 with the first name of each corresponding A cell.
The key mental model
Smart Fill answers: "Given these input columns and this example output, what's the pattern?" It generalizes from examples. Two or three well-chosen examples usually work; ambiguous ones need more.
How to trigger Smart Fill
Type your example
In the column where you want the transformation, type the desired output for the first row of data.
Watch for the suggestion
After 1-3 examples, a suggestion tooltip appears with the Smart Fill preview. If it doesn't appear, keep typing more examples.
Accept the suggestion
Press Ctrl+Shift+Y (Windows) or Cmd+Shift+Y (Mac) to accept. Or click the checkmark in the suggestion tooltip.
Review the results
Scroll through and check the filled cells. Smart Fill occasionally guesses wrong at the edges of the data — inspect the last few rows and any rows with unusual source data.
Try typing a third example. Smart Fill needs to see enough of the pattern to be confident. If nothing appears after 3-4 examples, the pattern is probably too complex or ambiguous — use a formula instead.
15 patterns Smart Fill handles well
| Task | Source | Smart Fill result |
|---|---|---|
| Extract first name | "John Smith" | "John" |
| Extract last name | "John Smith" | "Smith" |
| Extract email domain | "john@company.com" | "company.com" |
| Extract email username | "john@company.com" | "john" |
| Reformat date | "3/15/2026" | "March 15, 2026" |
| Combine name + email | "John", "j@c.com" | "John <j@c.com>" |
| Extract area code | "(415) 555-1234" | "415" |
| Title case names | "JOHN SMITH" | "John Smith" |
| Extract file extension | "report.pdf" | "pdf" |
| Extract domain from URL | "https://a.com/x" | "a.com" |
| Format phone number | "4155551234" | "(415) 555-1234" |
| Extract initials | "John Smith" | "JS" |
| Get last word | "North Region 2026" | "2026" |
| Split "Firstname, Lastname" | "Smith, John" | "John Smith" |
| Extract number from mixed text | "Order #12345 confirmed" | "12345" |
Smart Fill vs formulas
Smart Fill
Speed: 5-10 seconds.
Skill required: None.
Updates when source changes: No — outputs static values.
Best for: One-off cleanups.
Formula
Speed: 1-5 minutes.
Skill required: Function syntax.
Updates when source changes: Yes.
Best for: Ongoing pipelines.
The rule: use Smart Fill when the transformation is one-time. Use a formula when the transformation needs to react to source updates or be documented for others.
When Smart Fill fails
Failure 1: Complex conditional logic
"If column A contains 'North', use column B, otherwise use column C" — Smart Fill can't infer conditional logic from a few examples. Use IF or IFS.
Failure 2: External data lookups
"Add the customer name from the Customers sheet based on the ID in column A" — Smart Fill doesn't do lookups across sheets. Use VLOOKUP or QUERY.
Failure 3: Inconsistent source data
If your source column has mixed formats (some phone numbers with dashes, some without), Smart Fill's pattern detection may misfire. Clean source data first, then Smart Fill.
Failure 4: Numeric transformations
Smart Fill focuses on text patterns. Numeric operations (multiplication, division, aggregation) need formulas.
Failure 5: Very short data
Smart Fill needs enough source variety to detect a pattern. If you have 3 rows and 2 examples, it might not suggest anything.
Smart Fill can misfire on unusual rows — names with hyphens, emails with subdomains, dates with unexpected formats. Scroll through the results and check the last 10-20 rows plus any that stand out.
Converting Smart Fill to a formula
Once Smart Fill gives you the result you want, sometimes you need to make it dynamic — react to source updates. The pattern:
Common Smart Fill → formula conversions
| Smart Fill task | Formula equivalent |
|---|---|
| Extract first name from "John Smith" | =SPLIT(A2, " ") or =INDEX(SPLIT(A2, " "), 1) |
| Extract email domain | =SPLIT(A2, "@") or =REGEXEXTRACT(A2, "@(.+)") |
| Title case | =PROPER(A2) |
| Extract area code from phone | =REGEXEXTRACT(A2, "\((\d+)\)") |
| Combine columns | =A2 & " " & B2 or =CONCATENATE(A2, " ", B2) |
For arrayformula pattern that reacts across the whole column: wrap in ARRAYFORMULA(...). See our ARRAYFORMULA complete guide.
Sheets Wizard — for the transformations Smart Fill can't do
Smart Fill handles clean pattern-based transformations well. For more complex tasks — conditional logic, cross-sheet lookups, bulk categorization — Sheets Wizard adds cell-level =AI() functions and natural-language formula generation.
Complement to Smart Fill, not a replacement. Use Smart Fill first; reach for Sheets Wizard when you hit a limit.
Install Sheets Wizard →Frequently asked questions
What is Smart Fill in Google Sheets?
Smart Fill is Google Sheets' pattern-detection AI. You type 2-3 examples of what you want a column to look like based on data in adjacent columns, and Sheets suggests filling the rest of the column with the same pattern. It handles things like extracting first names from full names, reformatting dates, extracting email domains, and other common text transformations — all without you writing a formula.
Is Smart Fill free?
Yes. Smart Fill is built into Google Sheets and free for all users — no add-on, no subscription. It works on any Google account including free personal accounts. It's one of the most useful AI features in Sheets and requires no setup.
When does Smart Fill work vs when does it fail?
Smart Fill works best when the pattern is consistent and simple: extract, split, concatenate, reformat. It struggles with: complex conditional logic, patterns that require external data, and inconsistent source data. If Smart Fill doesn't suggest anything after 3 examples, the pattern is probably too complex — use a formula instead.
How is Smart Fill different from Flash Fill in Excel?
Both detect patterns from examples and fill columns. Smart Fill is AI-powered — it can generalize from fewer examples and handle more variations. Flash Fill is rule-based — it's faster but needs more examples for complex patterns. Both are free and built-in to their respective platforms. Functionally they solve the same problem with slightly different approaches.
Does Smart Fill update when source data changes?
No. Smart Fill outputs static values, not formulas. If your source data changes, the Smart Fill results don't update automatically. For dynamic behavior, convert your Smart Fill result into an equivalent formula using SPLIT, REGEXEXTRACT, or ARRAYFORMULA. Smart Fill is best for one-off cleanups; formulas are best for ongoing data pipelines.