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. This means that any active filters, layout structure, and masks that you have applied in Sisense to your data are exported as well. For example, if you have modified how currency, percentages, or numbers are formatted in the widget in Sisense, these will be reflected in your exported Excel file.

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 maintained when you export a pivot table to CSV.

To export a widget to Excel:

Exporting to Excel via the REST API

In addition to exporting to Excel via the Sisense Web Application, you can export binary content via the Sisense REST API through the POST /engine/excelExport endpoint. You can then convert this content to an Excel file (.xlsx).

Note: This endpoint is not available from Sisense’s interactive REST API. For more information about the endpoint, see the POST /engine/excelExport in Version 1.0 of the REST API.