---
schema_version: "1"
id: 05c49397d6c3cf95fc685ec9948c2ae9033414c7dda839a87e82a1f382809736
title: Export a Pivot Table in Intelligence Reports
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_dat_export_a_pivot_table.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_export_a_pivot_table.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e90d576ffffe916417477191519c630b6fafb6c663d3436761751b22aeba3d66
description: You can export a pivot table as a report and run it as part of a workflow in real time or on a defined schedule. You can also export to an Excel file, for example, and share it with others.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Export a Pivot Table in Intelligence Reports

You can export a pivot table as a report and run it as part of a workflow in real time or on a defined schedule. You can also export to an Excel file, for example, and share it with others.

### 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: Intelligence Reports and Intelligence Reports Advanced</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="d31676e57">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d31676e57 ">To schedule an export: </td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d31676e57 ">Schedule/ Create &amp; Edit</td>

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

1. In Analytics Builder, select **Intelligence Reports**.
2. On the Pivot Tables tab, select the pivot table.
3. Click **More Actions** and then select the export option.
    
    - **Schedule Export** — If you want to export to a report with a defined schedule, for example create a report every Monday at 8 AM, you have two options. When you select an option, the report format and options change according to the selected format.
        - **Pivot Table (Excel)** — Exports the pivot table to an Excel file as a pivot table object without including the totals.
        - **Flat Table** — Creates a report in an Excel format.
    - **Export** — If you want to export to a flat file, you have two options:
        - **Pivot Table (As Is)** — Exports the pivot table to an Excel file as is.
        - **Flat Table** — Exports the pivot table to an Excel file as a flat table.

#### See Also

- [Create a Flat Table Report](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_create_a_flat_table_report.htm&release=264.0.0&type=5 "You can create a flat table report when you want a report that extracts your raw data into a CSV or Excel file.")
- [User Roles and Permissions in Intelligence Reports](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_user_roles_and_permissions.htm&release=264.0.0&type=5 "To use Intelligence Reports for Engagement, your account must be assigned the Intelligence Reports for Engagement user role. The user role has the following permissions: Access, View and Export, Schedule, and Create and Edit.")