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](https://docs.cloud.google.com/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery.md.txt#script), if you have access to Google Workspace,
you can view the results in Google connected sheets. For more information,
see [Using Connected Sheets](https://docs.cloud.google.com/bigquery/docs/connected-sheets.md.txt).

If you don't have access to Google Workspace, you can
[view the reports in Data Studio](https://docs.cloud.google.com/backup-disaster-recovery/docs/monitor-reports/view-reports-lookerstudio.md.txt) or download prebuilt reports in a
CSV file. For instructions, see [Download prebuilt reports](https://docs.cloud.google.com/backup-disaster-recovery/docs/monitor-reports/view-reports-sheets.md.txt#download).

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](https://console.cloud.google.com/)
2. In the **Explorer** panel, click the 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](https://docs.cloud.google.com/bigquery/docs/writing-results.md.txt#downloading-saving-results-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](https://console.cloud.google.com/)
2. In the **Explorer** panel, click the expander arrow to expand a dataset.
3. Select a prebuilt report. For example, `Backup Jobs Summary`.
4. Click **Query** and select either **In new tab** or **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 **Schema** tab. For example, you can use the following query to download the entire report.

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

6. Click **Run** to display the preview of the query results.

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