Google Sheets want to use AI to flag and fix your mistakes

A humanoid robot thinking about a chalkboard of mathematical equations
(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 in a post 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’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 and DALL·E.

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.

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. It also promises that no prediction data is shared or owned by Google or any other company.

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.

Luke Hughes
Staff Writer

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

Read more
Gemini in Sheets
Gemini can now use Python code to create charts about your Google Sheets data
AITable
What is AITable? Everything we know about the AI productivity tool
Google Sheets
Google Sheets is getting faster and more effective, and I can't wait to ditch Excel for good
Google NotebookLM on a MacBook
What is NotebookLM: Power-up your research skills
Someone using a laptop for SEO analysis.
What is Predictive analytics?
The Google Gemini logo against a black background.
What is Google AI Studio? Everything we know about Google's AI builder
Latest in Pro
A man holds a smartphone iPhone screen showing various social media apps including YouTube, TikTok, Facebook, Threads, Instagram and X
A worrying Apple Password App vulnerability reportedlyleft users exposed for months
DeepSeek
Fake DeepSeek installers are infecting your device with dangerous malware
AI tools.
Not even fairy tales are safe - researchers weaponise bedtime stories to jailbreak AI chatbots and create malware
Adobe Firefly
Adobe launches game-changing GenAI tools for video editing
Adobe AI agents
Adobe launches 10 new AI agents to automate key marketing workflows
Data leak
Top California sperm bank suffers embarrassing leak
Latest in News
Stability AI 3D Video
Stability AI’s new virtual camera turns any image into a cool 3D video and I’m blown away by how good it is
The Google Wallet app with a mode for kids shown on-screen.
Google Wallet’s new kid-friendly payment system is a win for parents
A man holds a smartphone iPhone screen showing various social media apps including YouTube, TikTok, Facebook, Threads, Instagram and X
A worrying Apple Password App vulnerability reportedlyleft users exposed for months
Google Pixel 9a
Google is delaying the Pixel 9a to fix a mystery “component quality issue”
The bottom left corner of an Android phone, showing the Phone, Messages, Google icons and Google Search bar
Google Messages remote delete will soon save you from texting embarrassment – and here's how it works
ExpressVPN mobile app and Aircove
ExpressVPN ‘reduces workforce’ for the second time in two years