More powerful pivot tables in Connected Sheets
WorkspaceOctober 30, 2025
More powerful pivot tables in Connected Sheets
What’s happening
We are rolling out two significant updates to Connected Sheets pivot tables backed by BigQuery, designed to increase analytical capacity and streamline your workflow.
First, we’re doubling row capacity for pivot tables backed by BigQuery in Connected Sheets, from 100,000 to 200,000 rows. This change will allow users to bring in substantially larger views of BigQuery datasets in a single pivot table, enabling wider, more comprehensive analyses within the familiar Sheets environment.
Second, we’re launching the ability to “drill down” into Connected Sheets pivot tables, allowing you to immediately access the granular data making up any aggregated value. Users can now double-click on a pivot table cell or use the right-click > Show details menu option to instantly create a pre-configured extract, focusing on the specific records that make up that summary metric.
Getting started
- Admins: This feature will only be available to users with appropriate BigQuery permissions. Visit the Help Center to learn more about using Connected Sheets in your organization.
- End users: This feature will be available by default for users with appropriate BigQuery permissions. Visit the Help Center to learn more about analyzing BigQuery data using Connected Sheets.
Rollout pace
- Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on October 30, 2025
Availability
- Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts
