Export shapefile with "non standard" characters to csv and read in excel

Question

Macbook air mid 2011 running OSX 10.10.5 QGIS 2.8.2 - Wien Excel 15.13.1 (O365)

When I export a shapefile containing non-ascii characters to a csv file using QGIS (setting encoding to utf-8) and importing to excel I end up with weird characters. What encoding (export and import) should I use?

for example: Darién becomes Darién

A workaround is uploading the QGIS exported csv file with utf-8 encoding to google docs and download it as an xlsx file but there must be a more elegant solution

The way I export the shapefile is by using right mouse button on the layer and choose save as. In the dialog window I choose csv

• gene: look at Solved: Editing a CSV with UTF-8 encoding on a Mac

Answer 1

Maybe try export to other format: gml, after that rename

.gml to .txt

and import to excel.