To have access to BigQuery data in Google Sheets, you must have:
- An Enterprise Plus, G Suite Enterprise for Education, Enterprise Standard, or Enterprise Essentials account.
- Access to BigQuery.
- A project with billing setup in BigQuery.
If you don't meet these requirements, the BigQuery sandbox gives you limited access to BigQuery in Google Sheets at no charge without needing to upgrade your account. Learn how to use the BigQuery sandbox or how to upgrade your account.
The sandbox gives you 10 GB of active storage and 1 TB of processed query data per month. Learn more about the limits of the BigQuery sandbox.
If you've met your data limit, learn how to upgrade your account.
Get started with BigQuery data in Sheets
Sort & filter your BigQuery data in Sheets
Analyze & refresh a query with BigQuery data in Sheets
Write & edit a query with BigQuery data in Sheets
Fix problems with BigQuery data in Sheets