UPDATED 18:43 EDT / JUNE 01 2017

EMERGING TECH

Google Sheets now lets you build charts with machine learning

Google Sheets may not have the same clout with businesses as Microsoft Excel, but Google Inc.’s spreadsheet software may have one-upped Microsoft Corp. today with the introduction of charts powered by machine learning.

Creating charts from spreadsheet data is relatively simple, but according to Google, creating a chart with the right data organized in the right way is a little more difficult, which is why the company is turning to machine learning. Google Sheets’ new feature allows users to ask questions in simple, human readable text rather than having to input complicated formulas or manually format data.

The machine learning tools are an extension of the existing Explore with Sheets feature, which already made it easy for users to get answers to questions like “what are average sales on Sundays.” Now users can build charts with Explore just by telling Sheets what they need to see.

“If you don’t see the chart you need, just ask,” Daniel Gundrum, a product manager for Google Sheets, said in a blog post. “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.”

Google also added a few feature other features today, including customizable keyboard shortcuts, improved printing options, a better chart interface and new formulas for data. Sheets also now lets users sync table data between with Google Docs and Google Slides, which should make building presentation from spreadsheets a little easier.

Gundrum said that all of the new features are rolling out to Sheets today.

Images: Google

Since you’re here …

… We’d like to tell you about our mission and how you can help us fulfill it. SiliconANGLE Media Inc.’s business model is based on the intrinsic value of the content, not advertising. Unlike many online publications, we don’t have a paywall or run banner advertising, because we want to keep our journalism open, without influence or the need to chase traffic.The journalism, reporting and commentary on SiliconANGLE — along with live, unscripted video from our Silicon Valley studio and globe-trotting video teams at theCUBE — take a lot of hard work, time and money. Keeping the quality high requires the support of sponsors who are aligned with our vision of ad-free journalism content.

If you like the reporting, video interviews and other ad-free content here, please take a moment to check out a sample of the video content supported by our sponsors, tweet your support, and keep coming back to SiliconANGLE.