Google Sheets’ new Smart Autofill will save you precious time entering data
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 organization-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.