Export Insights

In Analytical Designer, you can export your insights as XLSX or CSV files.

Steps:

  1. Open or create the insight you want to export.
  2. Click the three dots in the top right corner.
  3. In Export to, select XLSX or CSV.
  4. Save the file.

Export file types

XLSX

Export your data to an XLSX file if you want to analyze the formatted data in a spreadsheet. 

By default, insights that are grouped by attributes contain merged cells in the exported XLSX file. To export without merging, unselect Keep attribute cells merged in the Export to XLSX dialog.

The following image shows the difference between exported data with merged and unmerged cells in the Date (Date) column.

By default, the Keep attribute cells merged option in the export dialog is selected. To change the default status, set the cellMergedByDefault platform setting to false. For details, see Platform Settings.

You can add up to five rows of additional text when exporting data to an XLSX file. For details, see Configure Custom Headers for XLSX Report Exports.

CSV

If you want to process report data in more detail in another application, and do not need formatting, export the report as a CSV file.