Exporting Pivot Tables to Excel

You can export your pivot tables to Excel (XLSX). When you export a pivot table to Excel, the data that is exported is the data that is displayed in your widget.

Exporting to Excel maintains your pivot’s layout and structure, and values such as sub-totals, which are not maintained when you export a pivot table to CSV.

The example below shows a pivot table exported to Excel versus CSV:

Note: Up to 1 million cells can be exported.

Excel

CSV

To export a widget to Excel:

• In Dashboard mode, click on the widget’s menu, and select Download > Excel File.
• In Edit mode, click on the download icon, and select Download Excel File.