It would seem that the only way to get Excel to display CSV unicode characters correctly is to use the “Import From Text” feature.
1. Open a new blank Excel spreadsheet
2. Data -> From Text -> [your CSV]
3. Choose “Delimited”
4. Choose “Unicode UTF-8” under “Encoding”
6. Check that everything seems to be in place
(See some screenshots over here http://support.mobileapptracking.com/entries/27347804-How-To-Import-a-Unicode-CSV-to-Excel)