In Excel, I tried to import (using Data > Import) a CSV file with Chinese characters. The characters are represented as Unicode numeric character references (NCR); for example 香辣猪. Although I have set the "File Origin" to "65001: Unicode (UTF-8)", but seems like it doesn't do anything.
Please note that:
香辣猪 is supposed to display as 香辣猪
The following is a screenshot of the import screen. You can see the column "Product Title" has Chinese characters in Unicode, but the characters are not being displayed properly. I have also tried almost all other Unicode, and Chinese related "File Origin", but all without success.
Please help, how can I import the CSV file with Chinese characters in Unicode, successfully in Excel?