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