Excel & Unicode (UTF-8)

It would seem that the only way to get Excel to display CSV unicode characters correctly is to use the “Import From Text” feature.

In short,
1. Open a new blank Excel spreadsheet
2. Data -> From Text -> [your CSV]
3. Choose “Delimited”
4. Choose “Unicode UTF-8” under “Encoding”
5. Next
6. Check that everything seems to be in place
7. Finish

 

(See some screenshots over here http://support.mobileapptracking.com/entries/27347804-How-To-Import-a-Unicode-CSV-to-Excel)

Published by

joshuatj

Digital Preservation #digipres. IT guy at @AFA_Archive Asian Film Archive. Malaysian news. PC games.

Leave a Reply

Your email address will not be published. Required fields are marked *