Sunday, 10 September 2017

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


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




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...