Google Sheets is getting a smart autofill feature


Many people know Google first and foremost as a search engine company. But really it’s a machine-learning company, using data to make predictions that get incorporated into applications like search and advertising without people even realizing it. Today Google is announcing in a blog post that people can now choose to apply its machine-learning savvy to Google Sheets, the company’s spreadsheet app, to make educated guesses and fill in blank cells.

Google Sheets, the company’s online spreadsheet, is getting quite a bit smarter today with the launch of the Smart Autofill add-on. Smart Autofill can look at the existing values in a spreadsheet and then, with the help of the Google Prediction API, automatically divine the data for missing values in a column. Essentially, the algorithm learns as much as it can about the information that is already available in a spreadsheet and then it looks for patterns to build a model based on this information. Say you have a spreadsheet with a number of data points about vehicles (this is Google’s default example). Maybe you have pricing for some, but not for all. Google will look at the data in the spreadsheet and then try to predict the right values for the missing prices. Or maybe you are slightly OCD and keep a spreadsheet for the restaurants you visit with data about their cuisine, ambiance, cost and other data. Now when you add a new place, Google will try to predict how much you will like this one.

Leave a Reply

Your email address will not be published. Required fields are marked *

Sign Up for Techi's Special Newsletter

Newsletters are not just for grabbing attention. I promise to deliver the best disruptive technologies in your inbox once or twice a month.

You May Also Like

The Google barge mystery is over

After all the hoopla and speculation about the mystery barge on the bay, the truth is finally revealed.  Google’s mysterious floating barge on San Francisco Bay will feature luxury showrooms and a…