Google Sheets Gets AI-Based ‘Smart Fill’ Feature to Autocomplete Data Entries

Oct. 16, 2020

In keeping with anannouncementfrom earlier this year,Google Sheetshas introduced a new ‘Smart Fill‘ feature that the company claims can detect and learn patterns between columns to intelligently autocomplete data entries. The technology behind the AI-based feature is similar to the one that’s used forSmart Composein Gmail to predict what the user will write next, but the algorithm is tweaked in this case to make data entry faster and more effortless.

In an officialblog postannouncing the rollout, Google said that the AI-based feature will start looking for patterns as a user starts typing the first names in a column. If the software does spot a pattern,“it will generate the corresponding formula, and then autocomplete the rest of the column for you”. The GIF below best illustrates the new feature, and it looks incredibly promising.

In addition to using data that’s already in the sheet, Smart Fill will also use data from Google’s Knowledge Graph, thereby using public data to further guess your next entry, especially for names of countries and cities. According to Google, the feature will make it easier to prepare and use data in Sheets.“Similar to how Smart Compose in Gmail helps you write faster with fewer mistakes, Smart Fill makes data entry quicker and less prone to error,”said the company.

The feature has already started rolling out for folks on Rapid Release domains, but it might take up to 15 days for it to show up for everybody. For folks on Scheduled Release domains, it will start rolling out from November 5th. Smart Fill will be available on all personal and enterprise accounts and will be ‘On’ by default.

Passionate techie. Professional tech writer. Proud geek.