Data Export

Choose elements

Enable Data Export on each report element that should contribute to the generated XLSX or CSV output.

1. Select the ancoreShare button on your Qlik Sense sheet.

2. Go to Report Elements.

3. Select the element you want to export.

4. Open Data Export and enable Data Export.

Repeat this for all elements that should be part of the export.
After this basic enablement you can proceed to set the file type, filename, and the sheet title when exporting to Excel.

File Type

You can choose between Excel and CSV as an output format for your data exports. 

XLSX (Excel) is a rich format and allows to add multiple tables to a singe file, putting each element on a separate Excel sheet. 

Whereas CSV (Delimiter Separated) always creates a separate file for each table element, but all of them are generated at once (your browser might ask you to allow the download of multiple files).

Filename (Element)

By default all data export files are named after the Qlik Sense object ID of the respective table element. This also means that by default each table element is exported in a separate Excel or CSV file, named after its ID.

Only set the custom name for the file here without the file extension (i.e. ".xlsx" or ".csv"), it will then be applied to both Excel and CSV exports.

In order to put multiple table elements in a single Excel sheet, set the same filename for each. Table elements with the same filename property will be collectively exported in one Excel file.
However, when the export type is set to CSV, each table element will create a separate CSV file regardless of the filename. 

There is also the option to set a filename for the data export globally for the whole report in Export Settings. You can then choose to exclude certain table elements from this setting by giving a different filename here in its element properties.

Worksheet Title

This setting only applies to Excel exports, as CSV files don't have sheets and only appears if the File Type is set to XLSX. 

Use this to control the worksheet where the element is written.
By default the worksheets are populated with the Qlik Sense object IDs of the table elements they represent. 

Freeze Panes

Freeze Panes prepares the worksheet for users who open the export in Excel.

Use it for large tables where headers or key columns should stay visible while scrolling.

At Object Start is useful when the freeze position should follow the exported element. Use a row offset of 1 to freeze above the table body.

Custom Cell gives full control. For example, A2 freezes the first row, B1 freezes the first column, and B2 freezes both.

Destination Type - Element Positioning

Destination Type controls where an element is placed in the worksheet.

Use Destination Cell for fixed Excel layouts, especially when working with templates.

Use relative placement when several elements should be arranged automatically. For example, place a text title first, then place a table below it, or place another element to the right of the previous one.

Destination Cell

Defines the start cell for the element, for example A1, B5, or D12.

Row and Column Offset

Offsets are used with relative placement. They add space between the previous element and the current one.

File Format

This setting applies to CSV exports and only appears if the File Type is set to CSV.

BOM (Byte Order Mark) is an invisible character used to indicate the encoding of a text file or stream. When a file is encoded in UTF-8 with BOM, the BOM character is placed at the beginning of the file to indicate that the file is encoded in UTF-8. This allows text editors and web browsers to correctly interpret the file as UTF-8, and display the characters correctly.

This might for example be important if your CSV export is opened in Excel (which is also an editor), to make sure all potential symbols and characters are interpreted correctly.

Field Separator

This setting applies to CSV exports and only appears if the File Type is set to CSV. 

You can choose and set a custom delimiter for your CSV data exports. It is a character which separates the columns in each data row.
The default delimiter is a semicolon ";" (set in Export Settings).

If you want to separate your data by a tabulator, just enter the word "tab" in this field.

In cases where the set delimiter is also part of the field value in your data export, this data entry will automatically be put in quotes, for example: North Area, "10,000" (the delimiter is set to comma "," but is also part of the field value "10,000")

There is also the option to set a CSV Field Separator globally for the whole report in Export Settings. You can then choose to exclude certain table elements from this global setting by setting a different delimiter here in its element properties.

Data exports only

When choosing the Export Type PDF or PPTX, the data export is being generated additionally to that, but you can also choose to only export the data from all table elements of your report where this feature is enabled by choosing the option Data export only.

1. On your Sense sheet, select the ancoreShare button for which you want to enable the data export.

2. On the properties panel, click Report Elements > Select Export Type and choose Data Exports only

Learn more about how to export your report here.

Enable Download

This feature is enabled by default and only refers to the download of the generated data export files in your browser. When user clicks on the ancoreShare button and 

If this feature is disabled, the data export is still getting generated (stored in your browser session cache) and can be exported otherwise, for example via custom JavaScript API.

1. On your Sense sheet, select the ancoreShare button for which you want to enable the download of your data export.

2. On the properties panel, click Export Settings > Data Export and Enable Data Export Download

Filename (globally)

By default all data export files are named after the Qlik Sense object ID of the respective table element. This also means that by default each table element is exported in a separate Excel or CSV file, named after its ID.

The filename you set here will be applied globally to this report and when choosing the export file type XLSX all table elements will be put in one Excel file.
If there is an other filename set within the table element properties, then this table will be excluded from this file pool and exported in a separate Excel file with the given name. This here is the global setting and the table element setting will override it. 

However, when the export type is set to CSV, each table element will create a separate CSV file regardless of the filename.

Only set the custom name for the file here without the file extension (i.e. ".xlsx" or ".csv"), it will then be applied to both Excel and CSV exports.

CSV Field Separator

Set a global delimiter for CSV data exports (default is a semicolon ";"), it will then be applied to all table elements of this report, where the data export is enabled.
You can choose and set a different custom delimiter for your CSV data exports within each Table Element. This here is the global setting and the table element setting will override it.

The delimiter it is a character which separates the columns in each data row. If you want to separate your data by a tabulator, just enter the word "tab" in this field.

In cases where the set delimiter is also part of the field value in your data export, this data entry will automatically be put in quotes, for example: North Area, "10,000" (the delimiter is set to comma "," but is also part of the field value "10,000")