Issue: After downloading Excel/CSV (Comma Separated Values) and opening Microsoft Excel, the screen does not display correctly and the data is not formatted in the cells.
​

Answer: Depending on your location in the the world, your computer will have 'Region' settings which define what character is used as a separator value. While the comma ',' is the most commonly used, other characters are sometimes used outside North America and the UK.
​

To resolve this issue on a Microsoft PC, simply do the following:
​

https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba?CorrelationId=82cfec68-5f59-4fd9-82f6-9e5fc170305c&ui=en-US&rs=en-US&ad=US&fromAR=1
​

Nb. Once you've changed the list separator character for your computer, all programs will use the new character as a list separator.

You can change the character back to the default character by following the same procedure.
​