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.


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:


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?