(v24) Export Raw Data in CSV or XLSX Format

Export Raw Data in CSV or XLSX Format

This applies to: Visual Data Discovery

When you export raw data from your visuals, numeric and boolean fields are exported as numbers and dates.

Export raw data in CSV format

1. Select Export from the visual drop-down menu. Select an export option for your visual.

2. Select a file format on the submenu, Raw Data > CSV.

3. The Export as CSV dialog opens.

   

4. Accept or change the default settings:

   • Accept or change the file name.

   • Specify the Number of Records to include in the export. The default is 1,000.

     Note: The number of records you can specify is limited by the setting of the zoomdata.export.data.max.rows property in the zoomdata.properties file. See Configuration Property Files.

   • Select a field to sort the data included in the export. The default for Sort by field is none. Depending on the field type selected, you have sort order options you can use to organize your data.

5. Select Export. Symphony prepares a CSV file downloaded by your browser.

Note: The number of records included is limited by the setting of the zoomdata.export.data.max.rows property in the zoomdata.properties file. See Configuration Property Files.

Export raw data in XLSX format

1. Select Export from the visual drop-down menu. Select an export option for your visual.

2. Select a file format on the submenu, Raw Data > XLSX.

3. The Export as XLSX dialog opens.

   

4. Accept or change the default settings:

   • Accept or change the file name.

   • Specify the Number of Records to include in the export. The default is 1,000.

     Note: The number of records you can specify is limited by the setting of the zoomdata.export.data.max.rows property in the zoomdata.properties file. See Configuration Property Files.

   • Select a field to sort the data included in the export. The default for Sort by field is none. Depending on the field type selected, you have sort order options you can use to organize your data.

   • Select Add Time Bar filter description to exported file to include in the export.

   • Select Add Visual filter description to exported file to include in the export.

5. Select Export. Symphony prepares an XLSX file downloaded by your browser.

Note: The number of records included is limited by the setting of the zoomdata.export.data.max.rows property in the zoomdata.properties file. See Configuration Property Files.