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
Vytvorené 1mo | 29. 1. 2025, 21:20:07


Ak chcete pridať komentár, prihláste sa

Ostatné príspevky v tejto skupine

Apple's 'Friday Night Baseball' is back on March 28 with a World Series documentary in tow

Apple's offered Major League Baseball games through the Apple TV app since 2022, and that's continuing in 2025, with new programming at no additional cost.

4. 3. 2025, 0:20:04 | Engadget
Mercedes-Benz GLC with EQ Technology prototype drive: Better when chilled

Before a new car comes to market, it's subjected to many months, sometimes years, of rigorous testing around the world. Sweden often hosts a big part of that journey, its cold northern expanses off

4. 3. 2025, 0:20:03 | Engadget
MWC 2025: Everything announced in Barcelona so far

Mobile World Congress is taking place in Barcelona this week, offering manufacturers an opportunity to show off new gear without needing to hold their own splashy event. So far, we've learned about

3. 3. 2025, 19:30:23 | Engadget
Gemini live video and screensharing arrive on Android devices later this month

Mobile World Congress 2025 has officially kicked off in Barcelona. Google is on the ground pre

3. 3. 2025, 17:20:21 | Engadget
UK watchdog investigates chidren's safety on TikTok and Reddit

The UK's Information Commissioner's Office (ICO) has announced it's

3. 3. 2025, 17:20:20 | Engadget