Work with billions of rows of BigQuery data in Sheets. No SQL necessary.
Introducing the connected sheet: a new type of spreadsheet that activates only when using the Sheets data connector, allowing you to access, analyze, visualize, and collaborate on up to 10 billion rows of BigQuery data — no SQL scripts needed. Beta coming soon.
SQL can still be used when connecting BigQuery data to Sheets. However, with the new connected sheet, it's even easier for you to surface insights in Sheets without the need for a BigQuery or SQL expert, saving time for both users and experts. You can make sense of that data with spreadsheet formulas or perform deeper analysis with features like pivot tables and charts. It's that easy.
- Access and refresh large volumes of connected data without CSVs
- Streamline reporting workflows
- Simplify collaboration with other analysts and stakeholders
Get more information on the connected sheets beta
We've been previewing the connected sheet with a small set of Google Cloud Platform and G Suite customers, and we plan to extend this capability to more customers through our beta program by the end of 2019. The connected sheet will be open to customers of both BigQuery and G Suite (Business, Enterprise, Drive Enterprise, Education, Enterprise for Education and Nonprofits editions,). BigQuery admins may apply with their primary domain on behalf of their organization.