Exporting to CSV File

The Comma-Separated Values (CSV) format is a well-established data file format and a widely-accepted method of transferring data.

The following topics discuss how to export Logi report data to CSV files:

About Exporting Data to CSV

The CSV data format is useful because of its relative simplicity and universal cross-platform accessibility. CSV files are simple text files that are generally used to represent tabular data: each row of text in the file represents one data record and, in the typical format, each column of data is enclosed in double-quotes and delimited by a comma. The first row may represent the column names. Here's an example:

Logi Info provides Export CSV elements that make it easy to export report data into CSV files.

The data exported to CSV files is only the data in the report's datalayers. Summary Rows, for example, are not included in the export. Logi developers can give users the ability to export a data manually via user interaction at runtime or developers can automate data exports based on an event or a schedule. Manual exports are configured within Report definitions and automated exports are configured within Process definitions.

All features or functions or upgrades for 12.8 use this image. For a list of all the new features, see the release notes or search on new features for 12.8 For large data sets, we recommend using the rapid CSV export option. Below is a formal list of the differences between native CSV and rapid CSV exports:

Native CSV Export Rapid CSV Export
Can export Crosstab Tables Cannot export Crosstab Tables
Can use Field Delimiter, Row Delimiter, and String Column attributes Cannot use Field Delimiter, Row Delimiter, and String Column attributes
Can have a null value for the "Export Data Table ID" Cannot have a null value for the "Export Data Table ID" parameter
Can export a Data Table created with the "Auto Columns" element Cannot export a Data Table created with the "Auto Columns" element
Can use group or count info (like "Header Row" or "Summary Row" elements) Cannot use group or count info (like "Header Row" or "Summary Row" elements)
Can support Data type attribute in “Excel Column Format” element Can support Data type attribute in “Excel Column Format” element
Cannot use format setting "Excel column format" Can use format setting "Excel column format"

For more information on the rapid export feature, see Rapid CSV Export.

Back to top