Analyze BigQuery data within Sheets
You can access and analyze your BigQuery data within Google Sheets using data connectors.
You can analyze and share large datasets from your spreadsheet with the BigQuery data connector. You can also use the data connector to:
- Collaborate with partners, analysts, or other stakeholders in a familiar spreadsheet interface.
- Ensure a single source of truth for data without having to create additional .csv exports.
- Streamline your reporting and dashboard workflows.
What you need
To connect with BigQuery, you’ll need one of the following account types:
- G Suite Business
- G Suite Enterprise
- G Suite for Education
- G Suite Enterprise for Education
- Drive Enterprise
The BigQuery data connector is only available for eligible work or school accounts, and you’re not signed in.
View query results
To view query results, on your Android device, open a spreadsheet in Google Sheets.
Write, change, or run queries
To create, edit, or run a query, on your computer, open a spreadsheet in Google Sheets.