I want to transform about 750 adresses into geocoded points. I´ve tried the plugins MMQGIS (Geocode) and Geopunt4Qgis but none of the things I´ve tried worked. Maybe its because the adresses are german or the table is not formatted correctly before I export it to a CSV file.

the table looks like this:

[![Table][1]][1]

this is what I type in MMQGIS (the City is at the time a state, there is also no option for housenumbers)

[![picture][2]][2]

this is the error I get

[![enter image description here][3]][3]

this is in Geopunt4Qgis (there is an option for housenumbers but I don´t have the postal code)

[![picture 2][4]][4]

I don´t necessarily need this to be done in QGIS - I just need a point shapefile so any solutions apart from Qgis are also welcome.

Any ideas?


  [1]: https://i.sstatic.net/QYLqH.png
  [2]: https://i.sstatic.net/hSsvC.png
  [3]: https://i.sstatic.net/Y8Dkl.png
  [4]: https://i.sstatic.net/CZteo.png