Home › Discussions › Questions & Answers › I need CSV output instead of Excel

I need CSV output instead of Excel

Avatar photoCustomer Questions & Answers 7 replies

We need the report output in a standard text format for an interface feed, not the default Excel XLSX. How can I change the output format at runtime?

7 replies

  • Support Enginatics

    The default output format is Excel XLSX. You can change this at runtime using the Options window. Look for the ‘Output Format’ field.

  • What formats are available besides XLSX?

  • Support Enginatics

    The available options are CSV (comma separated values), TSV (tab separated values), or XLSX.

  • Can I set a system-wide or report-specific default format to avoid selecting it every time?

  • Support Enginatics

    Yes, you can define a Default report output format in the Report Options section of the Setup window. Alternatively, you can set a system-wide default using the profile option ‘Blitz Report Output Format’.

  • If I choose CSV, is there any complexity regarding delimiters?

  • Support Enginatics

    Yes, the default delimiter for CSV is a comma. However, in some countries, regional settings use a semicolon instead. You can manage this by setting the profile option ‘Blitz Report CSV File Delimiter’ to match your required separator.

  • You must be logged in to reply to this post.