up vote 1 down vote favorite
share [g+] share [fb]

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?
link|improve this question
feedback

1 Answer

up vote 1 down vote accepted

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.

link|improve this answer
I imported the data to mySQL and then worked on it. Thanks to you, now I know how to do it in Excel, too :) – cenk Dec 13 '11 at 23:03
I get 3 options, Mac, Windows(Ansi) or DOS/OS2 - no utf options in Excel 2008 for Mac – mplungjan Jan 3 at 9:44
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.