Increased row limits in Connected Sheets for BigQuery

What’s changing

Connected Sheets provides the power and scale of a BigQuery data warehouse in the familiar context of Google Sheets. Starting today, we’re increasing the maximum number of rows of results returned from BigQuery for pivot tables and for data extracts: 
  • Pivot tables have been expanded to 50,000 rows (previously 30,000) 
  • Data extracts have been expanded to 50,000 rows (previously 25,000) 
With the increase in row limits, you can now analyze even more rows of results in Sheets from the petabytes of data in BigQuery. Additionally, we’ve made performance improvements for pivot tables and extracts in Connected Sheets, including updates to creating a pivot table, deleting an extract, cut/copy/pasting data in a pivot table, inserting a row, deleting a column, and more.


Getting started 

Rollout pace 

Availability 

  • Available to all Google Workspace customers and users with personal Google Accounts 

Resources