Google adds multi-table AI analysis to Sheets with Gemini upgrade
Google announced an update for Google Sheets, enabling its Gemini AI to understand and analyze multiple tables within a single tab. The feature allows users to query and process data from several sources by selecting specific tables for analysis.
This enhancement builds upon existing Gemini integrations that assist users with tasks such as creating charts, correcting errors, and explaining formulas. The new update specifically improves how the artificial intelligence comprehends and analyzes distinct tables located on the same sheet. Users can now ask questions and analyze data from multiple tables by picking which tables to use. The functionality also permits focusing on specific data subsets within a table for more granular queries.
Video: Google
The update introduces several new capabilities accessible through single prompts:
- Generating formulas: Users can create complex formulas that are based on data from several tables.
- Analyzing and generating charts: Gemini can be instructed to analyze data across the multiple tables to uncover insights and produce related visualizations.
- Editing your data: Changes can be applied to multiple tables at the same time through a single user command.
- Targeting analysis with selections: Selections can be made within tables to direct Gemini’s focus, allowing it to summarize specific data or generate formulas from highlighted information.
This update is scheduled to roll out to several user tiers. It will become available for customers on Business Standard and Plus plans, as well as Enterprise Standard and Plus. The feature will also be accessible to users with a Gemini Education or Gemini Education Premium add‑on. Additionally, individuals with a Google AI Pro or Ultra subscription will receive access to the new multi-table analysis capabilities.