you use a UTF-8-compatible spreadsheet program such as OpenOffice, then
you should enter unencoded characters (é, not Ã©) into the spreadsheet
and then use that program to convert to UTF-8 when you export to the
.csv format. Do NOT encode the characters manually. |
spreadsheet is incompatible with UTF-8 conversions (e.g., Excel), then
you must encode each international character in the City fields of the spreadsheet with the codes shown below. For example, the town of "Köln" would be entered as "KÃ¶ln".
that some characters display incorrectly as question marks or as
invisible characters and will be problematic. It is possible that these
strange characters can be generated with the Excel function CHAR() using
the character numbers in the last column and CONCATENATEing them with
the rest of the city name.