Public
For Report Builder information refer to Exporting a report.
Looker resource: Downloading content
Downloading and exporting a report from within Looker
If the report has custom dimensions, measures or table calculations, there is a row limit of 5000. There is no limit when downloading a report which is using the standard dimensions and measures.
- Load the relevant report.
- From the top right, click the cog icon.
- Click Download.
- The Download pop up displays with a range of options, including the ability to save in the following formats: TXT, Excel, CSV, JSON, HTML, Markdown, PNG.
-
Values - select either:
- Formatted - for the data to resemble what displays on the Explore screen.
- Unformatted - to exclude special formatting. Select this if exporting to Excel and the data contains currency fields where both comma's and full stops are used, for example: 100,000.00.
-
Limit - select either:
- Results in Table to download the data that is displayed on screen when viewing the report.
- All Results to download all rows of data which meet the criteria of a report. This wont be available where a Custom Table Calculation is included in the report. This is because table calculations are not compatible.
-
Values - select either:
- Once finalised, click Download to save the report data.
The report will be saved to your default downloads location.
Report templates
If you have associated a report template with your report, the template will only be attached when a report is delivered by email using the Send or Schedule option. It will also be available from the job card's Reports tab, then on relevant report card click Download.
Templates will also be applied when selecting Download from the actions menu in the Enhanced Reporting list page, against a report that has a template associated with it.
Sending a report
You can email a copy of the report by using the Send feature. This also allows you to see the results of the report within a linked report template.
- Load the relevant report.
- From the top right, click the cog icon.
- Click Send.
- In the Send pop up:
- enter the recipient's Email address
- for Format data as select XLSX
- set the other fields as required.
- Click Send.
Downloading and exporting a report from within Enhanced Reporting
You can download a report from within the Enhanced Reporting homepage as well.
From the Actions list on the right hand side choose Download.
If the report has an Excel template associated, the populated Excel file will be downloaded - if not, the raw data results will be downloaded in Excel format.