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.
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.

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.

This article originally appeared on Engadget at https://www.engadget.com/ai/gemini-can-now-do-more-complex-data-analysis-in-google-sheets-191218214.html?src=rss https://www.engadget.com/ai/gemini-can-now-do-more-complex-data-analysis-in-google-sheets-191218214.html?src=rss
Created 1mo | Jan 29, 2025, 9:20:07 PM


Login to add comment

Other posts in this group

XTRIS is a fast-paced arcade-style Playdate game you won’t be able to put down

I love a game that screams things like “neato!” and “godlike!” while I’m feverishly pressing buttons and darting my eyes around the screen, trying to make my fingers work as fast as my brain. My sk

Mar 3, 2025, 1:10:08 AM | Engadget
Lenovo gave its latest 16-inch ThinkBook a bevy of funky concept screen accessories

The ThinkBook line has sort of become Lenovo’s de facto testing ground for far-out ideas and ambitious concepts. See the

Mar 3, 2025, 1:10:07 AM | Engadget
The Lenovo Solar PC Concept feels like a device whose time has come

You might be surprised to learn that the first laptop with built-in solar panels is nearly 15 years old. But to

Mar 3, 2025, 1:10:06 AM | Engadget
Lenovo's new AI laptops for MWC include the Yoga Pro 9i Aura edition and the IdeaPad Slim 3x

Lenovo has announced new laptops with generative AI features for this year's Mobile World Congress (MWC), including the

Mar 3, 2025, 1:10:05 AM | Engadget
Lenovo’s codename Flip is another wild take on a flexible-screen laptop

Lenovo hasn’t even released its futu

Mar 3, 2025, 1:10:04 AM | Engadget
Lenovo is updating its ThinkPad lineup with new chips and form factors at MWC 2025

Lenovo is showing business laptops lovers some attention by announcing several new ThinkPads at Mobile World Congress 2025, including a new form factor for the T-series line, and updated internals

Mar 3, 2025, 1:10:03 AM | Engadget