CSV Export

CSV is used for data exchange and downstream processing. The following options can be set in the export settings dialog or via the report URL parameters.

Options

Under Settings:

  • Column Delimiter Type: Character or mode that separates fields.
    • Values:
      • Comma
      • Semicolon
      • Tab
      • Other (then set Column Delimiter)
      • Fixed Width (then set Column Widths)
    • Default value: Comma
  • Column Delimiter: Custom delimiter when Other is selected.
  • Column Widths: Comma-separated fixed widths when Fixed Width is selected, e.g. 3,5,5 or 5,5,,4. Default widths apply per type (e.g. String 8, Number 10). When used, the file has no delimiters or text qualifier.
  • Text Qualifier: Character used to quote text. Hidden when Fixed Width is selected.
    • Default value: Quotation mark
  • Codepage: Character encoding for the file. Placeholder: e.g. Cp1252.
    • Default value: Cp1252

Under Data only:

  • Export report data only (no labels etc.): When enabled, exports only data rows, no labels or layout. When enabled, With Column Names is available.
    • Default value: No
  • With Column Names: Include column names in the first row. Only relevant when Export report data only is enabled.
    • Default value: Yes