You can access, analyze, visualize, 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.
Important: When you accessBigQuery data inConnected Sheets, entries are recorded in Cloud Audit Logs. The logs show who accessed the data and when. Only people with proper authorization can access log records.
You can find thespreadsheet ID in the audit log. Every spreadsheet has a unique spreadsheet ID value containing letters, numbers, hyphens, or underscores. You can also find the spreadsheet ID in a Google Sheets URL.
Learn more about Cloud Audit Logs.
To restrict access to Google Cloud resources, you can use VPC Service Controls. Because VPC Service Controls does not support Sheets, you might not be able to access BigQuery data that VPC Service Controls protects. If you have the required permissions and meet the VPC Service Controls access restrictions, you can use the VPC Service Controls to allow queries issued through Connected Sheets.
Work with sample BigQuery data in Google Sheets
To understand how Connected Sheets works, you can explore connected sheet examples with public data.
- On your computer, open the Google Sheets template gallery.
- 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:
- Access to the Google Cloud platform. If you're an admin, learn how to turn on GCP for your organization.
- BigQuery access. Learn how to get BigQuery.
- A project with billing setup in BigQuery. Learn how to set up Google Cloud billing.
- If you don't have a project with billing setup, you can work with BigQuery data in a trial environment. Learn how to try BigQuery.
- Learn more about the permissions and roles needed to access a BigQuery table or dataset.
Add a BigQuery project
Important: You can’t change BigQuery data from within Google Sheets.
- On your computer, open a spreadsheet in Google Sheets.
- In the menu at the top, click Data
Data connectors Connect to BigQuery. - Choose a project.
- If you don’t find any projects, you need to add one.
- Choose a table or view.
- You can pick from any company table you have access to or from public data sets.
- Click ConnectStart analyzing.
Data connectors 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.
Related articles
Fix problems with BigQuery data in Sheets
Share files from Google Drive
Need more help?
Try these next steps:
Visit the Learning Center
Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.
