Anyone can now use AI to make predictions about their Google spreadsheet data

software

(Image credit: Shutterstock / Blue Planet Studio)

Google’s artificial intelligence (AI) research team has released a free machine learning (ML) add-on for Google Sheets that it claims can help anyone use predictions to fill gaps in their data without previous experience of ML or code.

Announcing Simple ML for Sheets (opens in new tab) in a post (opens in new tab) on the TensorFlow blog, the team claimed that small businesses, students, and even scientists and analysts at large corporations can find uses for the spreadsheet software’s new feature to make valuable predictions, or even just save themselves time in spotting errors.

It also suggested that those familiar with ML could also benefit from productivity boosts provided the add-on, with “training, evaluating, interpreting and exporting a model” takes “5 clicks and as little as 10 seconds.”  

Machine learning possibilities

Machine learning algorithms are trained on vast collections of data to be able to make human-readable predictions without being explicitly programmed to. As they predict, they become better at making predictions.

It is the latest example of AI-driven machine learning trickling down into consumer level applications. AI deployment company OpenAI (opens in new tab)’s neural network GPT-3, for example, powers any number of third-party AI writers and image generation services, including those provided by OpenAI itself, such as Playground (opens in new tab) and DALL·E (opens in new tab).

Those looking to learn more about machine learning’s possibilities, limitations, and how it works are well provided for with Google’s foundational and advanced courses (opens in new tab).

Even so, newcomers and enthusiasts alike stand to gain from leveraging the “state-of the art ML technology” inside the extension for Sheets, which Google claims is already powering data classification library TensorFlow Decision Forests (opens in new tab). It also promises that no prediction data is shared or owned by Google or any other company.

Read more

 > Check out our list of the best free office software right now
> What is artificial intelligence and how can it help your DevOps practices today?
> How AI is coming into its own

Once users have installed the extension, users can leverage the technology by opening the Extensions tab in their open Sheets spreadsheet, starting Simple ML, and using the simple UI to design the most appropriate task. From there, the data can be applied in the same way any manually-sourced data would in a given use case.

Even Google, however, is keen to stress that ML-driven predictions are just that, and shouldn’t be taken as guarantees of factual information. As such, it’s worth double checking all predictions made for accuracy.

    Are you a pro? Subscribe to our newsletter

    Sign up to theTechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!

    By submitting your information you agree to the Terms & Conditions (opens in new tab) and Privacy Policy (opens in new tab) and are aged 16 or over.

    Luke Hughes

    Graduate Writer

    Luke Hughes holds the role of Graduate Writer at TechRadar Pro, producing news, features and deals content across topics ranging from computing to cloud services, cybersecurity, data privacy and business software.

    TECH NEWS RELATED

    Xiaomi phone with Samsung E6 OLED breaks Android display brightness record

    Samsung recently showcased its newest OLED panel—E6 Super AMOLED—for smartphones that can reach up to 2,000 nits of peak brightness. It is the same panel used in the iPhone 14 Pro and the iPhone 14 Pro Max. Now, Android smartphone makers have started using the same panel, and Xiaomi’s ...

    View more: Xiaomi phone with Samsung E6 OLED breaks Android display brightness record

    Pixel 7 bug causes phone to freeze while watching YouTube and YouTube TV

    Despite being one of the best Android smartphones on the market, Google’s Pixel 7 suffers from several annoying bugs and problems that users have to contend with. One such bug has actually been plaguing users since the phone launched, but complaints continue to spring up. 9to5Google reports that the ...

    View more: Pixel 7 bug causes phone to freeze while watching YouTube and YouTube TV

    How to Install Any Add-on in Firefox for Android

    When Mozilla launched a re-designed version of Firefox for Android a few years back, it only came with support for a few add-ons – just for the sake of compatibility. Fast forward to present day and the restoration of full add-on support is not yet complete. The good news, ...

    View more: How to Install Any Add-on in Firefox for Android

    Newest Android version installed on a mere 5% of devices

    Android 13 is out of the reach of most users. In contrast, virtually all iPhone owners can install iOS 16. Photo: Ed Hardy/Cult of Mac It’s considered somewhat controversial that iOS 16 has been installed on only about 70% of iPhones four months after its release. But that’s a ...

    View more: Newest Android version installed on a mere 5% of devices

    Just How Popular Is Mobile Gaming on Android Devices?

    Mobile gaming exceeded any expectations regarding its profitability and popularity. Today is considered one of the fastest-growing entertainment sectors. It continues to attract new mobile gamers and expand the demographic of the gaming sector. In fact, it is one of the main reasons why gaming has become globally popular. ...

    View more: Just How Popular Is Mobile Gaming on Android Devices?

    Malware is Sneaking Into Google Search Ads

    Malware and viruses always, always, find a way. You need to be extra careful while browsing online, but sometimes, malware can still pop up in the places you least expect it — including in Google Search ads. Hackers and malware developers have set up fake websites for popular pieces ...

    View more: Malware is Sneaking Into Google Search Ads

    Five months after launching, Android 13 is running on 5.2% of devices

    In the past five months we’ve seen smartphone brands update their handsets to Android 13 as well as launch new models running this latest version of Android out of the box. While the likes of Samsung are leading the charge when it comes to issuing OS updates, there are ...

    View more: Five months after launching, Android 13 is running on 5.2% of devices

    You can now sign up for Twitter Blue on Android for $11 a month

    Ahh, Twitter. Gone are the days of applying for and failing to get verification for unspecified reasons, with Musk’s vision of Twitter Blue you can now sign up and pay your way to a verified tick. And from today onwards, you can even do so via the official Twitter ...

    View more: You can now sign up for Twitter Blue on Android for $11 a month

    Amazon, Meta and Google are actually spending big on clean energy

    Galaxy Tab S6 Lite (2020) gets Android 13 One UI 5.0 update

    10 Best Android Travel Apps To Plan Your Next Trip

    First post-Android 13 update to Galaxy A72 brings January 2023 security patch

    Galaxy A02 gets a new update but it’s not Android 12

    Google is testing way to measure distance between devices via Bluetooth

    Only 5.2% of devices running Android 13 five months after launch

    Galaxy S10 Lite Android 13 (One UI 5) update reaches the USA

    Everything you need to know on how to unlock Bluetooth support on the Stadia Controller

    How to back up and delete your Gmail so you don’t have to pay for storage

    Google’s rumored AirTag rival could be an Android moment for Bluetooth trackers

    US unlocked Galaxy S20 is finally getting Android 13 One UI 5

    OTHER TECH NEWS

    Top Car News Car News