Exporting Insights

You can use your insights as they are or export them and analyze them further.

In Data Explorer, you can export your insights as XLSX or CSV files.

To export insights:

Open or create the insight you want to export.

Click the three dots in the top right corner.

In the Export To dropdown list, select XLSX or CSV.

Save the file.

Export File Types

The following export file types are supported:

•

XLSX

•

CSV

XLSX

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

XLSX with Unmerged Cells

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

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

XLSX with Active Filters Displayed

If you have any filter enabled in the insight, you can add the description of the filters to the exported XLSX file. To do so, select Include applied filters in the Export to XLSX dialog.

Custom Headers

You can add up to five rows of additional text when exporting data to an XLSX file.

Custom Number Format

By default, when an insight is exported to XLSX, the number formats applied to the cells containing metrics are propagated to the result XLSX file exactly as defined in the insight. For example, if some metrics in an insight have a number format that displays negative numbers in red and positive numbers in green, this format will be applied to the cells with these metrics in the XLSX file.

Note:The number format defined in the platform setting is applied only to XLSX files. The number formats in the insights themselves do not change.

CSV

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

Note:When you export to CSV, formulas in attribute and attribute header cells are automatically escaped using quotation marks.