Latest in Gear

Image credit: Paul Hanna / Reuters

Google Sheets uses machine learning to build you better charts

You can request custom charts from Sheets using natural language.
408 Shares
Share
Tweet
Share

Sponsored Links

Paul Hanna / Reuters

Google spent plenty of time at its I/O developer conference earlier this month talking about how we're entering the age of AI. Today, the company's humble spreadsheet app Sheets is getting an upgrade thanks to Google's machine learning smarts. Sheets has long had an "explore" tool that analyzes your spreadsheets and builds charts automatically, but as of today you'll be able to ask for charts using natural language.

Hitting the "explore" button brings up some default charts based on your particular spreadsheet. But if you want to get custom, you can just type things like "histogram of 2017 customer ratings" or "bar chart for ice cream sales" (two examples Google provided).

Another handy new feature closely links Sheets with Google's presentation app Slides. Last year, Google added the ability to automatically update data from Docs into Slides with one click. Now, Google's adding similar syncing features that go from Sheets into both Docs and Slides. That is, if you're using the same table for data between these apps, you can just click an "update' button to pull in the latest information from the master source.

Google also added a bunch of new functions to Sheets, bringing the total to more than 400. There's also a new chart editor sidebar that should make building the right graph a little bit easier; this will also be available on Sheets for iPad and iPhone today as well. And for those of you who still need to put your spreadsheets on dead trees, there are a few new tools that make it easier to print your document. If you want to give these new features a shot, Google says they're live today.

All products recommended by Engadget are selected by our editorial team, independent of our parent company. Some of our stories include affiliate links. If you buy something through one of these links, we may earn an affiliate commission.
Comment
Comments
Share
408 Shares
Share
Tweet
Share

Popular on Engadget

Judge says Instacart likely misclassified California workers

Judge says Instacart likely misclassified California workers

View
Fujifilm's new flagship X-T4 camera has in-body stabilization

Fujifilm's new flagship X-T4 camera has in-body stabilization

View
Virgin Galactic will let people hop to the front of the line for tickets

Virgin Galactic will let people hop to the front of the line for tickets

View
Fujifilm's slimmer Instax Mini 11 features automatic exposure

Fujifilm's slimmer Instax Mini 11 features automatic exposure

View
Grimes details her character's backstory in 'Cyberpunk 2077'

Grimes details her character's backstory in 'Cyberpunk 2077'

View

From around the web

Page 1Page 1ear iconeye iconFill 23text filevr