The cause of this is problem is that Excel opens the CSV files with an incorrect encoding. In the CSV files in French, there are some particular characters (example: “é”, “à”) that, to be correctly visualized, need the encoding UNICODE UTF-8. This encoding is not that of default of Excel, so the file is codified in a non-opportune way.
To correctly visualize the characters it is necessary (*):
- open Excel;
- select from the menu bar the tab “Data” and then the entry “From text”;
- in the window that displays, select the CSV file that you want to open;
- a window of file settings opens; select the entry “Delimited” and in the field “File origin” select “65001: Unicode (UTF-8)” and push “Forward”;
- in field “Delimiters” select “Comma” and push “Forward”;
- in the new screen push “End”
- in the window “Import data” push “OK”
* example executed on Microsoft Excel 2010