I am not sure if the question is the right one for my situation, but here is what I want to do:

I've downloaded a .csv file with Chinese characters in it. When opened with MS Excel, the Chinese characters will be displayed as question marks; but if I open it with MacOS's Numbers or Google Sheet, the Chinese characters can display. I then open it with Atom, the characters originally show as question marks, and Atom "auto detect" the encoding to be UTF-8, but if I select encoding as "Chinese(GBK)", they display normally.

I also test it with notepad++, which seems to guess the encoding right as Numbers and Google Sheet do and display the right characters.

Now the question is, what should I do to THIS file so Excel can recognize it? Of course I can change the encoding in a working editor then copy all the content into notepad to create a new .csv file, but I am just wondering if there is anyway to change the original file's encoding?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.