When downloading Excel / CSV (Comma Separated Values) and opening Microsoft Excel it 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 comma ',' is the most common other are sometimes used outside North America and the UK.

To resolve this issue on a Microsoft PC, 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

Change the separator in all .csv text files

NOTE After you change the list separator character for your computer, all programs use the new character as a list separator. You can change the character back to the default character by following the same procedure.

Did this answer your question?