Google Sheets - how do you open a CSV with Chinese characters in Unicode?-CodePudding

I have a CSV file with Chinese characters in it. The Chinese characters are encoded in Unicode (for example 香).

How can I open or import this CSV file in Google Sheets, and have the Chinese characters display correct, I mean to have the Chinese characters display as the actual Chinese characters (for example 香 should be displayed as 香)?

If Google sheets cannot decode and display the Unicode in actual Chinese characters, then, can Excel do it?

The following is a very simple example, of such a CSV file content, just two lines.

Product Title
&#39321;&#36771;&#29482;

CodePudding user response：

Decode with

function decode(code = '&#39321;'){
  var char = String.fromCharCode(code.match(/&#(\d );/)[1]);
  console.log(char)
}