[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC):2025-08-18。"],[],[],null,["# View prebuilt reports in Google connected sheets\n\nThis page explains how to view view reports in Google connected sheets. It also\nexplains how to download reports to a local file.\n\nAfter you [set up prebuilt reports](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#script), if you have access to Google Workspace,\nyou can view the results in Google connected sheets. For more information,\nsee [Using Connected Sheets](/bigquery/docs/connected-sheets).\n\nIf you don't have access to Google Workspace, you can [view the reports in Looker Studio](/backup-disaster-recovery/docs/monitor-reports/view-reports-lookerstudio)\nor download prebuilt reports in a CSV file. For instructions, see [Download prebuilt reports](#download).\n\nTo view prebuilt reports in Google connected sheets, do the following:\n\n1. In the Google Cloud console, go to the **BigQuery Studio** page:\n\n [Go to BigQuery Studio page](https://console.cloud.google.com/bigquery)\n2. In the **Explorer** panel, click the arrow_rightexpander arrow to expand a dataset.\n3. Select a prebuilt report. For example, `Backup Jobs Summary`.\n4. From **Export** , click **Explore with sheets**.\n\n A new tab opens in connected sheet with the report data.\n\nDownload prebuilt reports\n-------------------------\n\nAfter you set up the prebuilt reports, you can download them to a local file. For more information, see\n[Downloading and saving query results from the Google Cloud console](/bigquery/docs/writing-results#downloading-saving-results-console).\n\nTo download prebuilt reports in BigQuery, do the following:\n\n1. In the Google Cloud console, go to the **BigQuery Studio** page:\n\n [Go to BigQuery Studio page](https://console.cloud.google.com/bigquery)\n2. In the **Explorer** panel, click the arrow_rightexpander arrow to expand a dataset.\n3. Select a prebuilt report. For example, `Backup Jobs Summary`.\n4. Click **Query** and select either **In new tab** or **In split tab**.\n\n A new tab opens with a sample query.\n5. 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.\n\n SELECT * FROM `\u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e.BackupandDR_reports.Backup Jobs Summary`.\n\n6. Click **Run** to display the preview of the query results.\n\n7. From **Save results** , select **CSV (local file)** to download report to a local file."]]