It is possible to open CSV files directly in Excel by just double clicking on them in an explorer window. But doing this does not allow Unicode characters to display correctly. CSV files with Unicode characters should be imported into Excel and have the encoding set to UTF-8.
To import a file into Excel and change the encoding follow these steps:
If you open the CSV file directly, the cells will appear like this:
This is what you will see if you import as UTF-8: