You can export your pivot tables to Excel (XLSX). When you export a pivot table to Excel, only the displayed (filtered) data is exported according to the currently selected filters and your pivot table’s values and layout structure are exported.

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

Excel

CSV

Exporting to Excel maintains your pivot’s layout and structure, and values such as sub-totals which are not exported into CSV are exported into Excel.

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.