IT Pro is supported by its audience. When you purchase through links on our site, we may earn an affiliate commission. Learn more

Google Sheets adds machine learning for natural language charts

New tools should make Google Sheets easier to use and more powerful

Pulling data out of complicated spreadsheets isn't easy for amateur data scientists, but such analysis is a requirement for many modern roles. 

Google has stepped in to help by adding machine learning tools to Sheets to let you ask questions about your spreadsheet in natural language, rather than using complicated calculations or understanding jargon. 

"Explore in Sheets, powered by machine learning, helps teams gain insights from data, instantly. Simply ask questions in words, not formulas to quickly analyse your data," said Daniel Gundrum, Sheets product manager, in a post in the Google blog. "For example, you can ask 'what is the distribution of products sold?' or 'what are average sales on Sundays?' and Explore will help you find the answers." 

Now, we're using the same powerful technology in Explore to make visualising data even more effortless. If you don't see the chart you need, just ask," Gundrum said. "Instead of manually building charts, ask Explore to do it by typing in 'histogram of 2017 customer ratings' or 'bar chart for ice cream sales.' Less time spent building charts means more time acting on new insights."

There are more updates to make life in Sheets easier. Charts made in Sheets will automatically sync in Docs and Slides, saving you that extra step when you have fresh figures. Just click the "update" button to sync data. 

Other changes include new keyboard shortcuts - you can now delete a row with "Ctrl+-" - as well as a revamped printing interface for easier settings management, new chart editing tools, and more spreadsheet functions. 

Featured Resources

The state of Salesforce: Future of business

Three articles that look forward into the changing state of Salesforce and the future of business

Free Download

The mighty struggle to migrate SAP to the cloud may be over

A simplified and unified approach to delivering Enterprise Transformation in the cloud

Free Download

The business value of the transformative mainframe

Modernising on the mainframe

Free Download

The Total Economic Impact™ Of IBM FlashSystem

Cost savings and business benefits enabled by FlashSystem

Free Download

Most Popular

Cyber attack on software supplier causes "major outage" across the NHS
cyber attacks

Cyber attack on software supplier causes "major outage" across the NHS

8 Aug 2022
Why convenience is the biggest threat to your security
Sponsored

Why convenience is the biggest threat to your security

8 Aug 2022
Electrical explosion reported at Google's Iowa data centre
data centres

Electrical explosion reported at Google's Iowa data centre

9 Aug 2022