Excel 2010 and Unicode CSV files

15 February 2012

As part of Wuxie, I'm creating (or rather, compiling from the internet) a number of different resources to include in the application to populate the word database. So I have a whole bunch of nice .xls spreadsheets with all the characters and information in UTF-8; but someone, for some reason, decided that any time you save a spreadsheet to a .csv, it would force the encoding back to ANSI and you'd just end up with a whole bunch of ??? where your beautiful 漢語 used to be.

Enter Jaimon Mathew to the rescue, who wrote a little Excel Add-In to get around exactly this issue - it works exactly as advertised, and allows a save as Unicode CSV option. Perfect!

Tags: Chinese, csv, Excel, Unicode, Wuxie

Add a Comment

No Comments