We have a Web based application which generates a .CSV file. The file is generated using UTF-8 encoding. When we Try to open the CSV file in excel, the Chinese Characters are displayed as junk in the excel.

But, We are able to see Chinese characters properly when we open the .CSV file in Notepad.

Can you pls. let us know what might be the problem and let us know how we can display Chinese in Excel.