Google Sheets Now Automates Data Entry With Smart Fill

An illustration of a magnifying glass looking for data.

Google is taking the tedium out of spreadsheets with Smart Fill, an AI-powered feature that automatically retrieves and fills out data based on context. Smart Fill was first announced by Google in June and will roll out to all Sheets users by November 5th.

In Google’s words, Smart Fill makes data entry “quicker and less error-prone.” As you fill out columns, Sheets will automatically detect patterns and autocomplete the rest of the column for you. If you have a column full of addresses and another column for zip codes, for example, Smart Fill will look up the appropriate zip codes and ask for your permission to enter them automatically.

Smart Fill can also fetch data from the Google Knowledge Graph or your contacts list. Enterprise customers with Google Workspace can use Smart Fill to pull data from their business’ address book automatically.

Google is rolling out Smart Fill for Sheets now. The company says that all users, including enterprise customers and free accounts, will have Smart Fill by November 5th.

Source: Google Blog

Andrew Heinzman Andrew Heinzman
Andrew is a writer for Review Geek and its sister site, How-To Geek. Like a jack-of-all-trades, he handles the writing and image editing for a mess of tech news articles, daily deals, product reviews, and complicated explainers. Read Full Bio »

The above article may contain affiliate links, which help support Review Geek.