JSQ, LLC

Mobile and Web Applications

  • Increase font size
  • Default font size
  • Decrease font size
Home FAQ DianHua Dictionary When I export from DianHuaDictionary.com and import into Excel, the Chinese characters are mangled. How do I import properly?

When I export from DianHuaDictionary.com and import into Excel, the Chinese characters are mangled. How do I import properly?

E-mail Print PDF

Though I have not tested this procedure myself, I found several references to it on the Internet.  Apparently, Excel does not support UTF-8 character encoding for CSV files.  However, it DOES support UTF-8 encoding for TXT files.  So, you should be able to rename files from .CSV to .TXT file extensions and open in Excel.  Excel should prompt you for the character encoding during import at which time you should select UTF-8. 

Another option employed by some users is to import into OpenOffice, NeoOffice, or Google Docs and save the result as an Excel document.