Monday, October 6, 2014

csv - UTF-8 File is not showing Chinese characters in Excel

I am creating a CSV file with UTF-8 encoding.




It displays the Chinese characters properly if I open it using Notepad++.



It displays the Chinese characters properly if I open it using Notepad.



But, if I open it using Excel, I see garbage values.



If I open it using Notepad and press Control+S and close the file and reopen in Excel, it shows the characters perfectly.



Any clues whats going here?




I also tried to create a normal CSV file which has Encoding GB2312. I then used Unix command iconv to convert the file from "GB2312" to "UTF-8"



This command removes all the Chinese characters and shows only English characters. So, this is not a solution.



Please suggest.



Edit -



It doesn't show Garbage value, but shows ANSI encoding. Why does it picks ANSI encoding by default. And why after opening the same file in Notepad/Notepad++ it opens up with UTF-8.




Also, why just Control+s makes it open in Excel correctly.

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...