---
schema_version: "1"
id: 7cddb0460256aaf1bf247949cb59fd80e3ef924915d359c619f05d35b907cbd1
title: Export a Report
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_export.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_export.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 04e19d2e62878a3d03c3903bb3280ac0ce93d4f05c343781f0a37ecc45cd028f
description: You can export report data to a spreadsheet.
products:
  - Cross Cloud
release: "264"
---
# Export a Report

You can export report data to a spreadsheet.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Essentials</strong>, <strong>Group</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d34229e82">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d34229e82 ">To export reports:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d34229e82 ">Export Reports</td>

          </tr>
        </tbody>
      </table>

- When exporting a report in Salesforce Classic using the Details Only option or in Lightning Experience as an XLS or CSV file, you can export an unlimited number of rows and columns. However, most spreadsheet tools have row and column limits. Common limits are 1,048,576 rows by 16,384 columns, or 65,536 rows by 256 columns.
- When exporting a matrix report in Lightning Experience using the Formatted Report option, you can export up to 2,000 rows and 100 columns. When exporting a tabular or summary report in Lightning Experience using the Formatted Report option or as an XLSX file using the Details Only option, you can export up to 100,000 rows and 100 columns. Long text and rich text fields are truncated to 255 characters. The performance for a large export varies depending on where your org resides, the time of the day, the CPU utilization, and the characteristics of the report.

#### See Also

- [Attach Files to Report Subscriptions](https://help.salesforce.com/s/articleView?id=analytics.reports_subscribe_attachment.htm&release=264.0.0&type=5 "When subscribing to a report, choose to receive report results as a formatted spreadsheet (.XLSX) or a comma-separated (.CSV) file attached to the subscription email.")
- [Run Reports in the Background](https://help.salesforce.com/s/articleView?id=analytics.reports_background.htm&release=264.0.0&type=5 "Run large reports in the background so you can keep working in Salesforce without waiting for results to display. This is a good way to run data-intensive reports that might otherwise time out due to the large number of report results.")
- [Print a Report](https://help.salesforce.com/s/articleView?id=analytics.reports_print.htm&release=264.0.0&type=5 "Print a report from the run page of a report using your browser’s print function.")

## Export a Report in Lightning Experience

1. From the Reports or Analytics tab or from the report run page, click ![dropdown icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/dropdown_icon.png) and select **Export**.
2. Select an export view. <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <tbody><tr class="">
              <th style="vertical-align:top;" headers="d34229e182-option" id="d34229e186">Formatted Report</th>

              <td style="vertical-align:top;" headers="d34229e182-desc d34229e186">Export the report as it appears in Salesforce, with the report header,
                groupings, and filter details. You can export the data only to an .xlsx
                file.</td>

            </tr>
            <tr class="">
              <th style="vertical-align:top;" headers="d34229e182-option" id="d34229e195">Details Only</th>

              <td style="vertical-align:top;" headers="d34229e182-desc d34229e195">Export each row without formatting. Use this option if you want to do
                calculations in the spreadsheet.<p>If you're exporting to an .xls or .csv file,
                  select the encoding option appropriate for your language and locale.</p>
              </td>

            </tr>
          </tbody></table>
3. Click **Export**.
    
    If you don't have the export option, ask your Salesforce admin for help.
4. If prompted, select a location and save the file.

## Export a Report in Salesforce Classic

1. From Reports, next to the report that you want to export, click ![the row-level actions menu](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/report_builder_group_menu_arrow.png), and select **Export**.
    
    If you set the “Don't save encrypted pages to disk” option in Internet Explorer, you can’t open your report online in Excel. Instead, save the exported report to your computer, and then open it in Excel. To change this setting in Internet Explorer, deselect “Don't save encrypted pages to disk” under Internet options.
2. Select an encoding appropriate for your language.
3. Select the file type that you want to export to.
4. Click **Export**.
    
    If you don't have the export option, ask your Salesforce admin for help.
5. If prompted, select a location and save the file.