I facing problem to save chinese characters in CSV file (Excel 2007). After I save and close, then I re-open it, all the chinese character become "?".
I have tried to put my comma separated values into to notepad and save it as CSV format with Unicode encoding, then I open it using Excel 2007, the chinese characters are displayed nicely, but only the first column in excel has values (comma deliminated
I need to create a CSV file with chinese character in it. Can anyone tell me the solution?
I'm not an expert on multi-language programming, but I don't think there is a known solution for this on common search engines. If the language settings are correct and it's still not working, you may have to look for a language pack if it exists.
It might be a bug or simply not included with the general software release. I've seen this question on other forums, none of which seem to have a solution.
The issue is that Excel saves CSV as plain ASCI, not UTF-8, but you are able to save as Unicode Text, which will preserve the UTF encoding; please see my screenshot below of a Unicode Text document saved from Excel and opened in EditPad Pro of the Japanese
words for each day of the week.