1

I've tried to geocode with MMQgisPlugin a CSV file with addresses (converted from an Excel file) and I get an error:

UnicodeDecodeError: 'utf8' codec can't decode byte 0xf1 in position 0: invalid  continuation byte 

enter image description here

enter image description here

I've tried to save the CSV file with option UTF-8 but didn't found an option like it:

enter image description here

How can I handle this?

  • Are there perhaps invalid utf-8 characters in the content of the CSV table? I've just tried to save a CSV from Excel and use MMQgis geocode plugins and it works – Vale Nov 15 '16 at 11:41
2

Libreoffice calc:
You can choose the encoding with libreoffice calc: Edit filter settings Encoding for CSV file

MS Excel
Follow: https://help.surveygizmo.com/help/encode-an-excel-file-to-utf-8-or-utf-16
When saving as, click tools -> Web options -> Encoding -> choose the right encoding.

Cheers,

  • i work with windows 7 - where i can find this option? – newGIS Nov 16 '16 at 5:55
  • @newGIS You need to download and install the software called "LibreOffice" – Vale Nov 16 '16 at 9:14
  • @newGIS otherwise it should also work with Excel. See the end of the answer. – Victor Nov 16 '16 at 11:12
0

Open CSV file in Notepad and save as with UTF-8 encoding.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.