What is Smart Fill in Google Sheets?
Smart Fill watches columns next to your edit and suggests completing a pattern when it recognizes one. Type a couple examples in a new column beside source data and Sheets may offer to fill the rest with names, emails split from full text, or formatted dates. It is Google's answer to flash fill for quick cleanup without formulas.
When to use it
Use Smart Fill during imports when you need derived columns fast: first name from full name, domain from email, or consistent casing on a one-time cleanup.
When to skip it
Skip Smart Fill for recurring pipelines that must update when source changes. Use formulas like SPLIT, REGEXEXTRACT, or ARRAYFORMULA for repeatable logic.
How it works
-
1
Enter a few example outputs in a column beside source values showing the pattern you want.
-
2
When Sheets detects a pattern, a Smart Fill chip or suggestion appears; accept to fill down.
-
3
Review every suggested row on critical data before accepting large fills.
-
4
Paste values after fill if you do not want later source edits to confuse the column.
-
5
Fall back to formulas when Smart Fill misses irregular rows or mixed locales.
-
6
Combine with Data > Trim whitespace before pattern detection on messy CSV paste.
Examples in Google Sheets
Split names
Column A has Full name; you type first names in B2 and B3; Smart Fill proposes the rest of column B.
Email local part
After two manual examples extracting user from email, Smart Fill completes the column for a mailing prep tab.
SKU prefix
Add a constant prefix to legacy codes by example; verify outliers before accepting the batch.
Better Sheets resources
Common mistakes
-
Accepting Smart Fill on ten thousand rows without spot-checking middle and tail rows.
-
Expecting Smart Fill to update when column A changes later; it is static values unless formulas.
-
Using Smart Fill instead of validation on columns that must stay machine-readable for APIs.
-
Mixed languages in source confusing pattern detection into wrong splits.
-
Smart Fill on merged cells or ragged ranges that break the adjacent column assumption.
Frequently asked questions
- Smart Fill vs autofill drag?
- Autofill extends simple series like 1,2,3. Smart Fill infers transformation patterns from examples.
- Smart Fill not appearing?
- Add clearer examples, remove blanks, ensure adjacent column layout, try another browser session.
- Undo Smart Fill?
- Ctrl+Z immediately after accept. Later use version history if values were saved.
- Smart Fill vs formula?
- Formulas recalc. Smart Fill writes values once unless you convert to a formula manually.
- Smart Fill on mobile?
- Limited. Do pattern fills on desktop for reliable suggestions.
- Regex replace instead?
- For complex patterns use REGEXREPLACE in a column; more verbose but auditable.
- Smart Fill multiple columns?
- Work one derived column at a time with clear examples beside stable source data.
- Smart Fill and privacy?
- Processing follows Google Sheets cloud behavior for your account type; treat sensitive data accordingly.
Related Tutorials
Watch how Smart fill works
Related blog posts
Guides that explain Smart fill in more depth.
Related terms
Autofill
Autofill copies a cell or selection downward or sideways using the small blue square fill handle. Sheets detects simple series like 1,2,3 or Mon,Tue,Wed and continues the pattern. Formulas copy with relative references adjusting per row unless you locked absolute refs. Autofill is the fastest way to propagate a working formula across hundreds of rows when ARRAYFORMULA is not needed.
Read guide →regex in Google Sheets
Regular expressions (regex) describe text patterns. Google Sheets exposes them through REGEXMATCH (test), REGEXEXTRACT (pull a substring), and REGEXREPLACE (swap text). They shine when TRIM and SPLIT are not enough for inconsistent labels, URLs, or log lines.
Read guide →normalizing data in Sheets
Normalizing means making inconsistent inputs follow one reliable shape: same date format, trimmed text, unique keys, one fact per row, and separate columns for categories that were crammed into one field. Clean data makes VLOOKUP, QUERY, and dashboards dependable.
Read guide →importing data into Sheets
Importing means pulling external data into a spreadsheet tab: from a file upload, another Google Sheet, a published CSV URL, or a function like IMPORTRANGE. The import dialog controls separator, locale, and whether new rows replace or append existing data.
Read guide →Done reading about Smart fill?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.