How to configure CSV exports to use UTF-8 charset ?

Lo_c Sabio1
Tera Contributor

Hi dear community !

In our instance we have incidents description written in non-western alphabet (Cyrillic, etc.)
When users export incidents in XLS format, these characters appears properly.
However, when exporting in CSV format, they are replaced by question marks.

I think this is because the encoding of the CSV file generated by ServiceNow is not UTF-8, so unable to support non-western alphabet.

Hence the question: is there a way to configure CSV export charset ?

Thanks in advance for your responses !

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

please check and change the charset here

Left nav type Import export and then set the value as UTF-8 and save

By default it is windows-1252

find_real_file.pngOR

Note: 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 (starting with the Calgary release).

Troubleshooting export - Determine whether the encoding setting is wrong

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

please check and change the charset here

Left nav type Import export and then set the value as UTF-8 and save

By default it is windows-1252

find_real_file.pngOR

Note: 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 (starting with the Calgary release).

Troubleshooting export - Determine whether the encoding setting is wrong

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Thanks a lot ! I was not able to spot this one in docs.servicenow.com !

You are welcome

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Even I tired to implement and followed same instructions but doesn't helped me, PFB added to comment. This is happening in Rome version.