View prebuilt reports in Google connected sheets

This page explains how to view view reports in Google connected sheets. It also explains how to download reports to a local file.

After you set up prebuilt reports , if you have access to Google Workspace, you can view the results in Google connected sheets. For more information, see Using Connected Sheets .

If you don't have access to Google Workspace, you can view the reports in Looker Studio or download prebuilt reports in a CSV file. For instructions, see Download prebuilt reports .

To view prebuilt reports in Google connected sheets, do the following:

1. In the Google Cloud console, go to the BigQuery Studio page:

   Go to BigQuery Studio page

2. In the Explorerpanel, click the arrow_right expander arrow to expand a dataset.
3. Select a prebuilt report. For example, Backup Jobs Summary .

4. From Export, click Explore with sheets.

   A new tab opens in connected sheet with the report data.

Download prebuilt reports

After you set up the prebuilt reports, you can download them to a local file. For more information, see Downloading and saving query results from the Google Cloud console .

To download prebuilt reports in BigQuery, do the following:

1. In the Google Cloud console, go to the BigQuery Studio page:

   Go to BigQuery Studio page

2. In the Explorerpanel, click the arrow_right expander arrow to expand a dataset.
3. Select a prebuilt report. For example, Backup Jobs Summary .

4. Click Queryand select either In new tabor In split tab.

   A new tab opens with a sample query.

5. Write a query based on the field names that are populated in the Schematab. For example, you can use the following query to download the entire report.

    SELECT * FROM ` PROJECT_ID 
   .BackupandDR_reports.Backup Jobs Summary` 
   . 
   

6. Click Runto display the preview of the query results.

7. From Save results, select CSV (local file)to download report to a local file.