I'm struggling with geocoding on QGIS3 on a Mac 10.14.1.

When I try to import a CSV file from Excel via MMQGIS->Geocode->Geocode CSV with Google/Open Street Map, I get the error:

enter image description here

My guess is that Microsoft Excel is not saving the file correctly in UTF-8, even though I'm saying that it should save it like this. I have found a workaround, that takes a bit time unfortunately.

I'm uploading the CSV file to google spreadsheet and export it as a csv file.

However, now I'm getting another error and I don't find a workaround for this...

enter image description here

Do you have an idea how I can fix this problem?

I fear that the problem might be something with German Umlauts like üäö, but I really need this for joining tables etc...

Here is a simple excel table for you to test my issue.

Google Spreadsheets

Your Answer

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

Browse other questions tagged or ask your own question.