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

I need CSV output instead of Excel

Avatar photoCustomer May 9, 2023 at 8:31 am

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?

Viewing 6 reply threads
  • Author
    Replies
    • Support May 10, 2023 at 2:47 pm  

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

    • Avatar photoCustomer May 12, 2023 at 7:56 am  

      What formats are available besides XLSX?

    • Support May 13, 2023 at 4:28 am  

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

    • Avatar photoCustomer May 13, 2023 at 12:28 pm  

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

    • Support May 14, 2023 at 10:19 pm  

      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’.

    • Avatar photoCustomer May 15, 2023 at 1:24 am  

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

    • Support May 16, 2023 at 8:30 pm  

      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.

Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with: