| title |
|---|
Exporting results |
You can export the results of a question or dashboard.
To export the results of a questions, click on the Download button in the lower right of a question.
You can export the results of a question as:
- .csv
- .xlsx
- .json
If you don't see this option, you may not have permissions to download results.
You can download up to 1 million rows.
You can export the unformatted results of a question by holding the option key on a Mac or the Alt key on PC when selecting the file format for your download.
Metabase will export the raw results of a question without applying any of the formatting you applied to the columns in the question. For example, if you formatted a floating point number to display only the first two decimal digits in the table results, exporting the unformatted results would include additional decimal digits (if any) found in the raw results.
You can also create a public link that people can use to download data in a specific format, as well as raw, unformatted question results.
You can also export data by setting up an alert.
You can export the results of a dashboard and its cards in different ways.
You can export a dashboard as a PDF. Click on the three dot menu (...) and select Export as PDF.
The PDF will only include screenshots of the charts as they are visible on the dashboard.
To export the results of a particular card, hover over the dashboard card, click on the three dot menu (...), and select Download results.
From here you can select:
- .csv
- .xlsx
- .json
- .png (if a chart)
To export the raw, unformatted results, hold down the option key for Macs, or Alt key for Windows, then click on the download file format.
If you don't see this option, you may not have permissions to download results.
You can use dashboard subscriptions to regularly export data from all questions on a dashboard, and include those results as an attachment.