Output UTF-8 encoded CSVs

Community
1

When I open my output csvs in excel the special characters (ā,ē,ī,ō,ū, etc.) do not display correctly. They do work if I open it in notepad++ and then copy and paste into excel and save as a UTF-8 csv.
Is there a way to get the riskscape output to work without the extra step?

image
image146×227 1.3 KB

2

Hi John,

It looks like Excel only checks for a BOM to figure out a file’s encoding. We don’t currently include a BOM, because it’s not a required (or even recommended) part of the CSV standard. We’ll look at adding it to CSV outputs so Excel will open them nicely.

In the meantime, you should try importing your CSV into Excel using Data → From Text/CSV which seems to detect the encoding better (and will allow you to change it if not).

Hope that helps,
Freddy

3

Thanks Freddy,

Would be great to have this as an option in RiskScape. In the meantime I have found that

sed '1s/^/\xef\xbb\xbf/' input.csv > input-UTF8.csv

works well and can be included in my work flow.

Cheers
John