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
