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

Learn more about G Suite

The BigQuery data connector is only available for eligible work or school accounts, and you’re not signed in. 

Sign in to your work or school account

View query results

To view query results, on your iPhone or iPad, open a spreadsheet in Google Sheets.

Write, change, or run queries

To write, edit, or run a query, on your computer, open a spreadsheet in Google Sheets.

Was this helpful?
How can we improve it?