Excel and UTF-8
Microsoft Excel is unable to properly display UTF-8 compliant CSV files when they contain non-English characters.
The workaround is to import the Epicollect5 csv files as a UTF-8 origin. Let's see how!
The following example was done using a Mac. If your are on Windows or Linux, the procedure might differ.
Open up Excel and import your csv file:
Pick a csv file with data in a UTF-8 language rather than English. Select "Delimited" and set the file origin to Unicode(UTF-8)
Select "comma" and leave all other options unchecked:
Select "General" then click on "Finish" to import your data.
Select which sheet and you are done.
Last updated 7 months ago