How do you open/import a CSV file with Unicode characters?

Anonymous
2022-03-24T05:47:09+00:00

I tried to import a CSV file with Chinese characters in Unicode (for example 香辣猪) in Excel, although I have set the "File Origin" to "65001: Unicode (UTF-8)", but seems like it doesn't do anything.

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.

How can I import the CSV file with Chinese characters in Unicode, successfully in Excel?

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

17 answers

Sort by: Most helpful
  1. Anonymous
    2022-03-25T10:08:44+00:00

    Hi GeriSK,

    This works absolutely brilliantly, and is what I am looking for! Thank you so much.

    Kind regards,

    PuppyMeow

    0 comments No comments
  2. Anonymous
    2022-03-25T10:59:19+00:00

    You're welcome!

    0 comments No comments