These are the docs for the Metabase master branch. Some features documented here may not yet be available in the latest release. Check out the docs for the latest version, Metabase v0.50.
Exporting results
You can export the results of a question or dashboard.
Exporting results of a question
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.
Maximum number of rows you can download
You can download up to 1 million rows.
Exporting unformatted results
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.
Exporting data via a public link
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.
Exporting question data via alerts
You can also export data by setting up an alert.
Exporting results of a dashboard
You can export the results of a dashboard and its cards in different ways.
Export dashboard as PDF
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.
Exporting results of a dashboard card
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.
Exporting results of a dashboard via dashboard subscriptions
You can use dashboard subscriptions to regularly export data from all questions on a dashboard, and include those results as an attachment.
Further reading
Read docs for other versions of Metabase.