Skip to main content
M
monicav9844
August 20, 2025
Question

Issues with Process HQ CSV Export Formatting

  • August 20, 2025
  • 8 replies
  • 0 views

Hello Appian Community,

I am currently working with Process HQ reports, and when exporting the data, the files are automatically downloaded in CSV format.

I have two questions regarding this export:

  1. Some fields that are numeric are being exported as text format. Is there a way to ensure they are downloaded directly as numeric values instead of text?

  2. In some cases, exported numbers include a strange prefix character (for example: $~118.331.052.083.617,56). Is there a recommended configuration or workaround to prevent these characters from appearing?

Any guidance or best practices would be greatly appreciated.

Thank you in advance for your support.

Regards,

Monica Vela,

    8 replies

    stefanhelzle0001
    stefanhelzle0001
    August 20, 2025

    In a CSV, there is no such thing like data types. Everything is just text, and data type interpretation is up to the application you use when opening the CSV.

    I suggest to open the CSV in a text editor like Notepad++ and check the values there.

    M
    monicav9844Author
    August 20, 2025

    Thank you Stefan.

    Do you know about topic 2?

    2. In some cases, exported numbers include a strange prefix character (for example: $~118.331.052.083.617,56). Is there a recommended configuration or workaround to prevent these characters from appearing?

    stefanhelzle0001
    stefanhelzle0001
    August 21, 2025

    Which character do you mean? Do you see it in the CSV in the text editor? What does "in some cases" mean?

    Terms & ConditionsAccessibility statement