Skip to main content
Known Participant
Aug 20, 2025 3:09 PM UTC
Question

Issues with Process HQ CSV Export Formatting

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
    Brainy
    Aug 20, 2025 4:56 PM UTC

    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.

    Known Participant
    Aug 20, 2025 8:19 PM UTC

    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
    Brainy
    Aug 21, 2025 6:30 AM UTC

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