Get started with BigQuery data in Google Sheets

You can access, analyse, visualise and share billions of rows of data from your spreadsheet with Connected Sheets, the new BigQuery data connector. You can also use Connected Sheets to: 

  • Collaborate with partners, analysts or other stakeholders in a familiar spreadsheet interface. 
  • Ensure a single source of truth for data analysis without additional .csv exports.
  • Streamline your reporting and dashboard workflows.

Connected Sheets runs queries on BigQuery on your behalf either when manually requested or on a defined schedule. Results of those queries are saved in your spreadsheet for analysis and sharing.

Watch a video tutorial to learn more about working with BigQuery data in Google Sheets.

Tip: If you used the historical data connector, you can use extracts to create the same table view you see in your previous workflow. You can also set up scheduled refreshes to automatically update your data.

Work with sample BigQuery data in Google Sheets

To understand how Connected Sheets works, you can explore connected sheet examples with public data. 

  1. On your computer, open the Google Sheets template gallery.
  2. Choose one of the connected sheet Examples.

What you need

To access BigQuery data in Google Sheets, you need to meet all of the following requirements:

Add a BigQuery project

Important: You can’t change BigQuery data from within Google Sheets.
  1. On your computer, open a spreadsheet in Google Sheets.
  2. In the menu at the top, click Data and then Data connectors and then Connect to BigQuery.
  3. Choose a project.
  4. Choose a table or view.
    • You can pick from any company table you have access to or from public data sets.
  5. Click Connect and then Start analyzing.

Use Connected Sheets on the Google Sheets app 

Using the Google Sheets app on your mobile device, you can:

  • View Connected Sheets data.
  • View calculated column formulas, filters and sorts, and connection settings.
  • Copy and paste data from Connected Sheets.

To create, edit or refresh data in Connected Sheets, open Google Sheets on a computer.

Next: Sort & filter your BigQuery data in Sheets

Related articles

Was this helpful?
How can we improve it?