Google brings new AI, machine learning features to Sheets

With an infusion of AI, Sheets will now suggest a pivot table based a simple natural language query.
Written by Natalie Gagliordi, Contributor
Image via Google

Google is adding new machine learning and AI tools to its Sheets app that aim to simplify the way users work with large data sets in spreadsheets.

One of the key updates relates to the creation of pivot tables. The powerful data analysis tool is used to find insights from large, detailed data sets, but creating one can be challenging.

With an infusion of AI, Sheets will now suggest a pivot table based a simple natural language query. Sheets will also now suggest relevant tables in the pivot table editor for users that create them from scratch, and then auto-suggest formulas that are specific to the data.

Google Sheets product manager Beri Lee said the update, which also includes a refreshed user interface, stems from last year's introduction of Explore in Sheets, which enabled users to run natural language searches inside the app.

"Last year, we launched 'Explore' in Sheets to help you decipher your data easily using the power of machine learning, and since then we've added even more ways for you to intelligently visualize and share your company data," Lee said in a blog post.

"Today, we're announcing additional features to Google Sheets to help businesses make better use of their data, from machine learning-powered pivot tables and formula suggestions to even more flexible ways to help you analyze your data."

In addition to the pivot table upgrade, the app was also retuned with a simplified way to create waterfall charts, and a faster process for importing formatted data files.


Google adds G Suite security tool to protect data from third party apps

Following this year's Gmail phishing attack, Google introduces a way for its enterprise customers to better secure which third-party apps can get access to user data.

Box integrates with Google Docs, Springboard

The companies are aiming to make Box a third-party repository for content stored in Google Docs, Sheets, and Slides.

Google Docs, Sheets finally get iPad Pro support

An obvious feature has finally come to the iPad Pro -- Apple's "business iPad". However, there's still one feature missing.

Google Docs aims to up its presentation template game

Google is adding to its template library as it aims to court education and small businesses and close a historical gap with Microsoft's Office.

Editorial standards