How do I import an Excel file with Chinese characters into a CSV?

You might want to try notepad++, I doubt notepad will support unicode characters.

You might want to try notepad++, I doubt notepad will support unicode characters. notepad-plus-plus.org.

Notepad supports unicode characters if the file starts with something recognized as a byte-order mark, which is a truly ugly thing in UTF-8 (especially given that UTF-8 does not need it in the first place). – Donal Fellows Aug 6 '11 at 7:20 per above, I've tried Notepad++ and jEdit, which both support UTF-8. Again, the question marks still don't turn into the Chinese characters.

Thus, I'm thinking that Excel is simply gargling up the Chinese characters when it imports the spreadsheet into CSV format. I'm still looking for a solution to this. – user534017 Aug 6 '11 at 8:13.

As far as I know Excel doesn't save CSV files in any Unicode encoding. I have had similar issues recently trying to export a file as CSV with the £ symbol. I had the benefit of being able to use another tool altogether.My version of Excel 2010 can export in Unicode format File > Save As > Unicode Text (.txt), but the output is a tab-delimited, UCS-2 encoded file.

I don't know MySQL at all but a brief look at the specifications and it appears to handle tab delimited imports and UCS-2. It may be worth trying this output. Edit: Additionally, you could always open this Unicode output in Notepad++ convert it to UTF-8 Encoding > Convert to UTF-8 without BOM And possibly replace all tab chars with commas too (Use the Replace dialogue in Extended Search mode, \t in the Find box and , in the Replace box.

).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.