1

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

RutgerH
  • 3,285
  • 3
  • 27
  • 55

1 Answers1

1

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

.gml to .txt

and import to excel.

Artec
  • 982
  • 5
  • 14