Gemini can now do more complex data analysis in Google Sheets

If you love nothing more than good data visualization, Google’s latest Sheets update will be right up your alley. The company has begun rolling out an upgrade to the app’s Gemini side panel, a feature it introduced this past summer, to give its AI agent the ability to generate more in-depth insights about the data in your spreadsheets.

Tapping the new “Analyze for insights” shortcut in Sheets will prompt Gemini to offer insights on “contextual trends, patterns, and correlations between different variables in your data,” according to Google. The agent will also create charts based on your data, which you can insert as static images in your document. Depending on the complexity of the prompt, Gemini will use Python code to complete the request.

On the right hand side, the Gemini side panel uses Python to analyze the data in the user's spreadsheet. On the right hand side, the Gemini side panel uses Python to analyze the data in the user's spreadsheet.

Google

There are a few notable limitations to the feature’s current implementation. For instance, Google notes that once you’ve inserted a chart it cannot be modified. Additionally, any charts Gemini generates won’t be directly linked to your data, so they won’t automatically update after you make changes.

ADVERTISEMENT

Advertisement

Separately, Google recommends users be as specific as possible when prompting Gemini to provide data insights. “For the most accurate results, ensure your data is in a consistent format, with clear headers and no missing values,” the company adds.

You can use the updated Gemini side panel in Sheets if you pay for Google One AI Premium, or if your company is a Business or Enterprise Workspace customer with a Standard or Plus plan. Anyone with a Gemini Education, Gemini Education Premium, Gemini Business or Gemini Enterprise add-on will also receive access. Google expects to complete the rollout of this feature by February 20, so you might not see in your version of Sheets right away.

Related Posts

5 Of The Best 4-Door Sports Cars, Ranked By Horsepower

When most people think about the highest echelon of performance cars, they are most likely to think about two-seater coupes or roadsters. Due to their typical formula of stuffing the…

Read more

What Is The Chevy High Country Package & How Is It Different Than The Silverado LTZ?

With more than 2.7 million vehicles sold in 2024, General Motors (GM) cemented its place as the largest automobile company in the U.S. While GM sells a plethora of cars under its…

Read more

What The Numbers & Letters On Your Car’s Windshield Actually Mean

KELENY/Shutterstock Ever wondered what the series of numbers and letters on your car’s windshield means? These markings or codes that are either etched, printed, or affixed to your windshield on…

Read more

What The Cameras Didn’t Show Us About Top Gear

Faith Moran/Getty Images From 2002 to 2015 (and again from 2016 to 2023), the BBC gave audiences one of the greatest car-themed programs of all time: “Top Gear.” The show…

Read more

Who Makes The Pinecil Smart Soldering Iron & How Much Does It Cost?

Wladimir Bulgar/Getty Images We live in an era where everything from lightbulbs to kettles is available in smart forms. Now, thanks to a company that’s as innovative in its approach…

Read more

Vision Pro will reportedly get Apple Intelligence as soon as April

Apple Vision Pro may soon get an update bringing Apple Intelligence to the headset, according to a new report from Bloomberg. The first Apple Intelligence features started rolling out to…

Read more

Leave a Reply