When exporting data from ServiceNow to CSV. Japanese &Korean Chars are not displayed correctly

dileep0146
Tera Contributor

Hi All,

 

I'm having an issue when exporting data from ServiceNow to CSV. Japanese and Korean characters are not displayed correctly and appear as question marks (???).

Even though after updating the Export Properties CSV from windows-1252 to UTF-8

Please refer the screenshots

Please suggest

Thank you

 

1 ACCEPTED SOLUTION

Ehab Pilloor
Giga Sage

Hi @dileep0146,

 

Please refer: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0870228

 

Issue

Japanese Contents in the Incidents like Description, Notes when exported to CSV does not remain and appears as garbled.

This issue is not occurring when exported to .xlsx format.

Cause

Note that by default, ServiceNow exports all CSV files in Windows-1252 encoding. If you need to export translated data, set the glide.export.csv.charset system property to UTF-8.

Resolution

In order to see the report exported from the instance with the Japanese characters, you will have to change the file origin to UTF-8 from the default Western European which is set on the Microsoft excel which you are using.

Please follow the below step for the process of the same.

1. open up a blank Excel sheet.
2. Click on Data.
3. Click on Get Data and select 'From text'.
4. select the file which you wish to open.
5. On the next tab Change the File Origin to (UTF-8).

After following the steps above, the CSV file will display the Japanese character as expected.

 

Please Accept this response as Solution if it assisted you with your question & Mark this response as Helpful.

 

Kind Regards,

Ehab Pilloor

View solution in original post

2 REPLIES 2

Ehab Pilloor
Giga Sage

Hi @dileep0146,

 

Please refer: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0870228

 

Issue

Japanese Contents in the Incidents like Description, Notes when exported to CSV does not remain and appears as garbled.

This issue is not occurring when exported to .xlsx format.

Cause

Note that by default, ServiceNow exports all CSV files in Windows-1252 encoding. If you need to export translated data, set the glide.export.csv.charset system property to UTF-8.

Resolution

In order to see the report exported from the instance with the Japanese characters, you will have to change the file origin to UTF-8 from the default Western European which is set on the Microsoft excel which you are using.

Please follow the below step for the process of the same.

1. open up a blank Excel sheet.
2. Click on Data.
3. Click on Get Data and select 'From text'.
4. select the file which you wish to open.
5. On the next tab Change the File Origin to (UTF-8).

After following the steps above, the CSV file will display the Japanese character as expected.

 

Please Accept this response as Solution if it assisted you with your question & Mark this response as Helpful.

 

Kind Regards,

Ehab Pilloor

Tanushree Maiti
Tera Patron

Hi @dileep0146 

 

I encountered a similar issue where certain special characters were not displaying correctly when the data was exported to CSV or Excel, even though UTF-8 encoding was configured.

https://www.servicenow.com/community/developer-forum/article3-tm-few-specific-special-character-gett...

 

We raised a case with the ServiceNow vendor, and they suggested that the issue was related to the viewer. The problem occurred only when opening the exported files in Microsoft applications such as Excel, while the same files worked correctly in other viewers they tested.

 

Based on their recommendation, we submitted an idea through the Idea Portal; however, it was not considered for implementation.

 

For your case, you can raise a case with your servicenow vendor for the assistance.