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:
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.