MacOS РHow to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X

chinesecsvmacosmicrosoft excelutf-8

I have a CSV file which I can open and view the column with Chinese letters normally with TextMate.

However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. When I copy and paste this into a text-only software (TextMate again or even this textarea box) I see that it is shown correctly.

Maybe my trouble will be solved if I could select the appropriate font in Excel, I'm not sure. As I do not speak Chinese, I do not know what to choose.

I kindly request some help from Chinese speakers out there, do I need to:

  • install special fonts?
  • choose the appropriate font (which is already on my computer perhaps)?
  • install the chinese input capability to my OS?

Best Answer

You don't need special fonts. It sounds like you have a problem in which excel is misunderstanding what the encoding of the file is.

Here's how to solve it. On the data menu, choose "get external data", navigate to the file. Now, in addition to the usual csv import options, you can tell excel what the file origin is. UTF-8 would be a good guess.