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

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

When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.

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

AnnouncingSimple ML for Sheetsin aposton the TensorFlow blog, the team claimed that small businesses, students, and even scientists and analysts at large corporations can find uses for thespreadsheet 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 fromproductivityboosts 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 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 companyOpenAI’s neural network GPT-3, for example, powers any number of third-partyAI writersand image generation services, including those provided byOpenAIitself, such asPlaygroundandDALL·E.

Those looking to learn more about machine learning’s possibilities, limitations, and how it works are well provided for withGoogle’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 libraryTensorFlow Decision Forests. It also promises that no prediction data is shared or owned by Google or any other company.

Are you a pro? Subscribe to our newsletter

Are you a pro? Subscribe to our newsletter

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

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.

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.

LG Electronics sets ambitious B2B revenue goal to offset declining consumer demand

New fanless cooling technology enhances energy efficiency for AI workloads by achieving a 90% reduction in cooling power consumption

Phishing attacks surge in 2024 as cybercriminals adopt AI tools and multi-channel tactics