Google Sheets Gets Smart Fill Feature, Helps Autocomplete Data Entry

Smart Fill can be used for tasks like extracting the first name of a person and finding values in a table.

Share on Facebook Tweet Snapchat Share Reddit Comment
Google Sheets Gets Smart Fill Feature, Helps Autocomplete Data Entry

Smart Fill on Google Sheets will make data entry quicker and less prone to error

Highlights
  • Smart Fill on Google Sheets will help make data entry quicker
  • It will detect and learn patters and autocomplete data
  • Smart Fill will be on for default for users on Sheets, once rolled out

Google has brought a Smart Fill feature to Google Sheets, letting the spreadsheet app detect and learn patterns between columns in order to autocomplete data entry. The tech giant said that Smart Fill will make data entry quicker and less prone to error. The feature can be used for tasks like extracting the first name of a person and finding values in a table. Smart Fill will be on by default for users. The feature has started rolling out for those on the Rapid Release schedule; other users will get the feature from November 5 onwards.

Announcing the new feature in a blog post, Google said that Smart Fill will make data entry on Google Sheets quicker, similar to how Smart Compose helps users write faster with fewer mistakes. If you have a column of full names, you may want to split it into a column with the first names and another with the last names. Smart Fill will automatically look for patterns and will generate the corresponding formula, going on to autocomplete the rest of the column.

Besides using data that's in a sheet, Smart Fill will also use data from Google's Knowledge Graph. It can, for example, use public data to autocomplete a list of countries where a list of cities is located.

Smart Fill can also use information from your company's people directory to autocomplete data. For example, it can use organisation-only data to fill in email addresses for company employees. This feature, however, will be limited to Enterprise Plus customers.

The main Smart Fill features will be available for all business, education, enterprise, non-profit, and personal Google Account users. Smart Fill integration with people directory is available only for Enterprise Plus customers.

Google also launched Sheets Smart Cleanup recently, which uses similar intelligence to help prepare and analyse data in Sheets.

How to use Smart Fill

Smart Fill will be on by default. To use the feature, open a spreadsheet in Google Sheets and enter data. To use Smart Fill, Mac users should press + Shift + Y. Windows/Chromebook users should press Ctrl + Shift + Y. Click a cell to see the formula used. Users should note that the extended rollout of the feature will take a few more weeks.

If you want to turn off the Smart Fill feature, follow these steps: Open a spreadsheet in Google Sheets. Click on Tools > deselect Enable autocomplete.


Flipkart, Amazon have excellent iPhone 11, Galaxy S20+ sale offers, but will they have enough stock? We discussed this on Orbital, our weekly technology podcast, which you can subscribe to via Apple Podcasts, Google Podcasts, or RSS, download the episode, or just hit the play button below.

Comments

For the latest tech news and reviews, follow Gadgets 360 on Twitter, Facebook, and Google News. For the latest videos on gadgets and tech, subscribe to our YouTube channel.

Further reading: Google Sheets, Smart Fill, Google
Tanishka Sodhi Tanishka Sodhi is a sub-editor at Gadgets 360. As a journalist, she has covered education, culture, and media and mental health. She is interested in the intersection of technology and culture, and its impact on everyday lives. Tanishka is a staunch advocate of gender equality, and the correct use of commas. You can get in touch with her via Twitter at @tanishka_s2 or drop a mail at tanishkas@ndtv.com. More
Samsung Galaxy Note 9 Gets One UI 2.5 Update With Wireless DeX Support, Camera Features: Report

Related Stories

 
 

Advertisement

Advertisement

© Copyright Red Pixels Ventures Limited 2020. All rights reserved.
Listen to the latest songs, only on JioSaavn.com