Hello,

We noticed you're browsing in private or incognito mode.

To continue reading this article, please exit incognito mode or log in.

Not an Insider? Subscribe now for unlimited access to online articles.

Intelligent Machines

Google Sprinkles AI on Its Spreadsheets to Automate Away Some Office Work

Want to turn boring numbers into a cool chart? Just ask, and Google’s algorithm will do the rest.

In Google’s commercial for its virtual assistant, people ask it to play dance music, videos, and set a timer. A new feature from the search giant that lets you ask questions of its online spreadsheets is less flashy, but it could be the start of something that has a huge impact on how some companies operate.

Instead of creating charts from data the way office drones have done it for decades, you can now simply ask for what you want—for example by typing “histogram of 2017 ice cream sales.” Google’s machine-learning algorithms do the rest.

The new feature joins one introduced last year called Explore that allows you to type phrases such as “what are average sales on Sundays” instead of creating formulas. Together they are an example of advances in machine learning that are transforming office work and the economy.

How exactly those advances are changing the job market is subject to some debate. Some predictions have it that machine learning has become so capable, and is improving so quickly, that it won’t be long before many jobs, such as driving trucks, are completely eliminated.

A milder view suggests that jobs will be radically changed, but not eradicated, as software takes over certain tasks. A study from McKinsey published in January predicted that half of today’s workplace tasks could be automated by 2055—but that only 5 percent of jobs would no longer need humans at all.

Sign up for The Download
What's important in technology and innovation, delivered to you every day.
Manage your newsletter preferences

Google will surely add more automation features to Sheets and the rest of its office suite. Arguing that features powered by machine learning make its customers more productive has become a core part of the company’s effort to win market share away from Microsoft.

Not even Google can have much idea of how companies will use the time saved using its new feature. In a large company, it might be enough to shrink a team of analysts, or avoid expanding it. Or it might free those already on staff to do deeper explorations that have a bigger impact on the bottom line.

What seems more certain given the many limitations of today’s machine-learning technology is that spreadsheets themselves will be here for a good while longer. Automating the act of making a chart out of data in neatly labeled columns is one thing. Creating a machine that can generate the kinds of questions and ideas that we need charts to answer and explore is quite another.

(Read more: “How Technology Is Destroying Jobs,” “China Is Building a Robot Army of Model Workers,” “Basic Income: A Sellout of the American Dream,” “As Goldman Embraces Automation Even the Masters of the Universe Are Threatened,” “The Missing Link of Artificial Intelligence”)

Hear more about machine learning from the experts at the EmTech Digital Conference, March 26-27, 2018 in San Francisco.

Learn more and register
More from Intelligent Machines

Artificial intelligence and robots are transforming how we work and live.

Want more award-winning journalism? Subscribe and become an Insider.
  • Insider Plus {! insider.prices.plus !}* Best Value

    {! insider.display.menuOptionsLabel !}

    Everything included in Insider Basic, plus the digital magazine, extensive archive, ad-free web experience, and discounts to partner offerings and MIT Technology Review events.

    See details+

    What's Included

    Unlimited 24/7 access to MIT Technology Review’s website

    The Download: our daily newsletter of what's important in technology and innovation

    Bimonthly print magazine (6 issues per year)

    Bimonthly digital/PDF edition

    Access to the magazine PDF archive—thousands of articles going back to 1899 at your fingertips

    Special interest publications

    Discount to MIT Technology Review events

    Special discounts to select partner offerings

    Ad-free web experience

  • Insider Basic {! insider.prices.basic !}*

    {! insider.display.menuOptionsLabel !}

    Six issues of our award winning print magazine, unlimited online access plus The Download with the top tech stories delivered daily to your inbox.

    See details+

    What's Included

    Unlimited 24/7 access to MIT Technology Review’s website

    The Download: our daily newsletter of what's important in technology and innovation

    Bimonthly print magazine (6 issues per year)

  • Insider Online Only {! insider.prices.online !}*

    {! insider.display.menuOptionsLabel !}

    Unlimited online access including articles and video, plus The Download with the top tech stories delivered daily to your inbox.

    See details+

    What's Included

    Unlimited 24/7 access to MIT Technology Review’s website

    The Download: our daily newsletter of what's important in technology and innovation

/3
You've read of three free articles this month. for unlimited online access. You've read of three free articles this month. for unlimited online access. This is your last free article this month. for unlimited online access. You've read all your free articles this month. for unlimited online access. You've read of three free articles this month. for more, or for unlimited online access. for two more free articles, or for unlimited online access.