UTF-8 Encoding in MS-excel

[banerjee...@gmail.com]

Hi Team,

In my application, in the reports there are some UTF-8 characters, now in the applications its working fine, but while i am trying to open it in excel after exporting through csv, the utf characters are not coming as expected,in the excel.

Could you please tell me any solution regarding this..

[Pankaj Kumar]

Hi Somjit,

This is the known bug of the excel, though this is fixed in Excel2013. You can try this Excel version or use another editor to open the exported csv file.

Please find the reference comment below:-

"There is a known bug where Excel, upon opening a UTF8 csv files via file association, assumes that they are in a single-byte encoding, disregarding the presence of the UTF8 BOM. This can not be fixed by any system default codepage or language setting. The BOM will not clue in Excel - it just won't work. (A minority report claims that the BOM sometimes triggers the "Import Text" wizard.) This bug appears to exist in Excel 2003 and earlier. Most reports (amidst the answers here) say that this is fixed in Excel 2007 and newer."

Or you can follow the below steps to open the UTF-8 characters csv file:-

Thanks & Regards,

Pankaj Kumar

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/32e4c57b-57af-4e37-84d5-3e63a3aa3be6%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Pankaj Kumar]

Hi Somjit,

Please find the below steps to open the UTF-8 characters csv file:-

1. Open Excel
   
2. Import the data using Data-->Import External Data --> Import Data
   
3. Select the file type of "csv" and browse to your file
   
4. In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
   
5. Change the Delimiter to comma
   
6. Select where to import to and Finish
   

Thanks & Regards,

Pankaj kumar

[Somjit Banerjee]

Hi Pankaj,

Thanks for the information.

Regards
Somjit.