We are doing a csv export from SAP MII. We use the below format for achieving this
The csv files gets successfully downloaded but when we open it does not display the right Chinese characters in the excel file. The data is displayed correctly in the SAP MII report.
If we try to import the csv file in excel and use UTF-8 encoding in the option it displays the right Chinese words but when I directly open the csv file it opens in UTF-7 encoding.
Can someone please help how we can fix this.