Export data tips

[DataData2]

Hello,

If your client machine has regional setting with delimiter-value set to a value other than a comma (,), Export data feature might not work well.

It turns out Excel decides to use-regional-setting delimiter instead of a comma as the delimiter for a CSV (Comma separated value) files. I am not really sure what is the reason.

To work around this issue, there are 2 options

Option 1:  change your regional setting in your local machine

Go into control panel -> Regional settings -> Advanced Setting and change your list separator to a comma

Option 2: Open the CSV file in a text editor; specify the delimiter value by adding the following in a new line (top of the file content):

sep=,

NOTE: the instruction is specific to Excel App only and it is not a CSV standard; so other CSV editor might not like it.

hope this helps