Gemini in Google Sheets just upgraded and can now analyze across multiple tables

The Gemini assistant in Google Sheets has been rapidly evolving into a powerful tool for data analysis and manipulation. But until now, its capabilities have been largely confined to working within a single, defined table at a time. In a significant new update, Google is breaking down those barriers.

Starting today, Gemini in Sheets can now understand and analyze data across multiple tables within a single tab of your spreadsheet. This is a massive improvement that dramatically increases the power and accuracy of your AI-powered queries, allowing for more complex, real-world analysis.

Connecting the dots across your data

This new multi-table awareness unlocks a host of powerful new workflows:

• Generating Complex Formulas: Gemini can now write formulas that reference and perform calculations across several tables at once. Think writing XLOOKUP functions to pull data from one table into another, or aggregating data from multiple tables into a single summary calculation – all with a simple natural language prompt.
• Holistic Analysis and Charting: You can ask Gemini to analyze data scattered across different tables to uncover insights or create visualizations. For example, you could ask it to identify top performers by combining sales data from different regional tables, or create a single chart comparing performance metrics from separate product tables.
• Multi-Table Editing: Apply formatting or structural changes to multiple tables simultaneously with a single request. Need to apply consistent conditional formatting across all tables on your sheet? Or build a single pivot table that summarizes data from several sources? Gemini can now handle that.

More control with selections

Beyond just working across tables, Gemini now also understands selections within tables. You can highlight a specific range of cells or an entire column and ask Gemini to focus its analysis just on that data. Want to know the trends in a specific column you’ve selected? Just ask. You can also select or deselect entire tables to help focus Gemini’s attention for broader queries.

The feature is currently in a gradual roll-out (starting October 20, 2025) and will be available to most paid Workspace subscribers, customers with Gemini Education add-ons, and Google AI Pro and Ultra subscribers over the next few weeks.