First note that Excel saves CSV files encoded with ASCII which means it will remove all the special characters.
If you are working with Notepad you should use Save As... - Encoding - UTF8.
Attached is a small example.
Please upload the csv file (so I could see the encoding).
|