--- title: "Exporting results" description: "Exporting your Metabase questions and dashboards as CSV, Excel, JSON, PDF, or PNG files." url: "https://www.metabase.com/docs/latest/questions/exporting-results" version: "65" --- # Exporting results You can export the results of a question or dashboard. ## Exporting results of a question To export the results of a question, click on the **Download** button in the lower right of a question. ![Exporting results of a question](https://www.metabase.com/docs/latest/questions/images/exporting-the-results-of-a-question.png) You can export the results of a question as: - .csv - .xlsx - .json - .png (if a chart) You can choose between downloading the results as: - **Formatted**: With any [formatting changes](https://www.metabase.com/docs/latest/data-modeling/metadata/formatting.md) you've applied in Metabase. - **Unformatted**: Metabase will export the raw results of the question without applying any of the [formatting you applied](https://www.metabase.com/docs/latest/data-modeling/metadata/formatting.md) 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. If you don't see the option to export results, you may not have [permissions to download results](https://www.metabase.com/docs/latest/permissions/data.md#download-results-permissions). ## Exporting pivot tables By default, Metabase will export the pivoted results, but you'll have the option to export the unpivoted results. **Pivot table in Metabase** ![Pivot table in Metabase](https://www.metabase.com/docs/latest/questions/images/pivot-table-in-metabase.png) **Exported unpivoted results** ![Unpivoted results](https://www.metabase.com/docs/latest/questions/images/unpivoted-results.png) **Exported pivoted results** ![Pivoted results](https://www.metabase.com/docs/latest/questions/images/pivoted-results.png) The pivoted results will display as a flat table in Excel, not a native [Excel PivotTable](https://support.microsoft.com/en-us/excel/overview-of-pivottables-and-pivotcharts). If you want to use a native Excel PivotTable, you'll instead want to export the raw, unaggregated rows of data that you'll need. That is, you'll want to undo any of the summarizations and groupings in your question, _then_ export the results. One thing to watch out for: some summarizations in Metabase include implicit joins, so when you drop the summarizations, you may need to join tables to include all of the columns you'll need. **Raw table** (Orders table including joined Products table): ![Raw table](https://www.metabase.com/docs/latest/questions/images/raw-table.png) The reason Metabase doesn't try to export results as a native Excel PivotTable is that Excel doesn't support all of Metabase's aggregation functions. Trying to reconstruct Metabase pivot tables as Excel PivotTables without these functions can lead to correctness issues, which defeats the purpose of looking at the data in the first place. ## Export limits ### Row limit By default, Metabase will export the first 1048575 rows of results. - For CSV exports, you can increase this limit with an environment variable: [`MB_DOWNLOAD_ROW_LIMIT`](https://www.metabase.com/docs/latest/configuring-metabase/environment-variables.md#mb_download_row_limit). Increasing this limit, however, may impact your Metabase's performance. - XLSX exports will always be limited to Excel's maximum of 1048575 rows (plus the header row). ### Cell character limit in Excel exports When exporting results to an Excel document (.xlsx), Metabase will limit the number of characters per cell to 32,767, which is the [character limit enforced by Excel](https://support.microsoft.com/en-us/excel/excel-specifications-and-limits). If you have a bonkers number of characters in a single cell, Metabase will truncate the content to fit within that limit. ## Exporting results from document cards You can download results from charts embedded in [documents](https://www.metabase.com/docs/latest/documents/introduction.md). To export results from a chart in a document: 1. Hover over the chart in the document. 2. Click on the three dot menu (**...**). 3. Select **Download results**. 4. Choose your format: .csv, .xlsx, or .json. You can export results as formatted or unformatted (hold `Option` on Mac or `Alt` on Windows when clicking the format). If you don't see the **Download results** option, you may not have [permissions to download results](https://www.metabase.com/docs/latest/permissions/data.md#download-results-permissions). ## Exporting data via a public link You can create a [public link](https://www.metabase.com/docs/latest/embedding/public-links.md#public-link-to-export-question-results-in-csv-xlsx-json) that people can use to download data in a specific format, as well as [raw, unformatted question results](https://www.metabase.com/docs/latest/embedding/public-links.md#exporting-raw-unformatted-question-results). ## Exporting question data via alerts You can also export data by setting up an [alert](https://www.metabase.com/docs/latest/questions/alerts.md). ## Exporting results of a dashboard You can export the results of a dashboard and its cards in different ways: - [Export dashboard as PDF](#export-dashboard-as-pdf) - [Exporting dashboard card](#exporting-results-of-a-dashboard-card) - [Exporting via dashboard subscriptions](#exporting-results-of-a-dashboard-via-dashboard-subscriptions) ### Export dashboard as PDF To export a dashboard as a PDF, click **Share**, then select **Export as PDF**. On dashboards with multiple tabs, select **Export tab as PDF** to export the current tab. ![Exporting a dashboard as a PDF](https://www.metabase.com/docs/latest/questions/images/export-dashboard-as-pdf.png) The PDF will only include screenshots of the charts as they are visible on the dashboard. To get a PDF of a dashboard delivered on a schedule, [attach a PDF to a dashboard subscription](https://www.metabase.com/docs/latest/dashboards/subscriptions.md#attach-a-pdf-of-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**. ![Export results of a dashboard card](https://www.metabase.com/docs/latest/questions/images/download-card-results.png) 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](https://www.metabase.com/docs/latest/permissions/data.md#download-results-permissions). ### Exporting results of a dashboard via dashboard subscriptions You can use [dashboard subscriptions](https://www.metabase.com/docs/latest/dashboards/subscriptions.md) to regularly export data from all questions on a dashboard, and include those results as an attachment. You can also [attach a PDF](https://www.metabase.com/docs/latest/dashboards/subscriptions.md#attach-a-pdf-of-the-dashboard) of the entire dashboard. ## Remove Metabase branding from exports By default, data exports (PDFs, PNGs, alert and subscription emails, etc.) feature Metabase branding, like this "Made with Metabase" logo: ![Question with Metabase logo](https://www.metabase.com/docs/latest/questions/images/question-with-metabase-logo.png) To remove the Metabase logo and branding on exports, you'll need to subscribe to a [Pro or Enterprise plan](https://www.metabase.com/pricing). ## Further reading - [Alerts](https://www.metabase.com/docs/latest/questions/alerts.md) - [Dashboard subscriptions](https://www.metabase.com/docs/latest/dashboards/subscriptions.md) - [Tables](https://www.metabase.com/docs/latest/questions/visualizations/table.md)