Use enhanced Smart Fill with Gemini in Google Sheets

Important: This feature is available to users on work or school accounts through a Gemini for Google Workspace add-on, and to users on personal accounts through Google One AI Premium. Learn about Gemini features and plans.

This feature is also available through our early access testing program, Google Workspace Labs

On Google Sheets, enhanced Smart Fill suggestions makes manual text processing tasks easier. It automatically detects the relationship between incomplete column pairs. It also uses AI to predict the remaining values, which allows them to be instantly filled.

This feature is available on desktop.

Use AI to fill out your Sheets

An animated GIF showing AI in Google Sheets auto-populating multiple rows in a spreadsheet with star ratings for restaurant reviews

You can see enhanced Smart Fill suggestions in two ways:

  • Once an edit has been made in the file.
  • Live suggestions: Enhanced Smart Fill can appear while you're doing manual text entry. It appears as soon as Sheets sees it has a prediction available.

Important: The outline indicates the range Sheets can predict and you can hover over the icon to see the fill suggestions.

When you see enhanced Smart Fill suggestions, you can:

  1. Accept the suggestion by clicking the suggestion bubble.
  2. Reject the suggestion by clicking the cancel icon on the expanded suggestion pill to reject that suggestion for the range.

Example use cases of enhanced Smart Fill:

  •  Categorize feedback by theme
  •  Organize news articles by topic
  •  Convert address data to consistent format
  •  Extract phone numbers from text fields

Tips:

  • Enhanced Smart Fill can only detect and support English values.
  • To trigger enhanced Smart Fill detection, a table must have at least 3 example rows with 2 distinct column values to be filled with suggested values.
  • Enhanced Smart Fill can only be triggered on text columns. It will not run on numeric and date columns.

Give feedback on generated suggestions

Gemini for Google Workspace is constantly learning and may not be able to support your request. 

If you get a suggestion that’s inaccurate or that you feel is unsafe, you can let us know by submitting feedback. Your feedback can help improve AI-assisted Workspace features and broader Google efforts in AI.

To submit feedback:

  1. Click the three dot menu in any suggestion.
  2. Click Send feedback to send feedback.

To provide general feedback on this feature, at the top, go to Help and then Help Sheets improve.

To report a legal issue, create a request or go to Send feedback and then Report an issue or Suggest an idea and then click Legal Help at the bottom of the sidebar.

Learn about Gemini feature suggestions

  • Gemini feature suggestions don’t represent Google’s views, and shouldn’t be attributed to Google.
  • Don’t rely on Gemini features as medical, legal, financial or other professional advice.
  • Gemini features may suggest inaccurate or inappropriate information. Your feedback makes Gemini more helpful and safe.
  • Enterprise end users can submit feedback about their experience using this feature. End users are informed before they submit feedback that the feedback data shouldn’t contain personal, sensitive, or confidential information.
Search
Clear search
Close search
Google apps
Main menu