Reverse geocoding in Excel without loosing money

Reverse geocoding in Excel

The previous 3 articles concentrated on the geocoding process in Excel for free. I considered the Google Sheets option and also the VBA Excel tools applicable to Bing, Nominatim, and others. Now it’s the best time to explain the process from another way around. Sometimes we have a situation when reverse geocoding is more needed … Read more

The costless way to geocoding addresses in Excel – part 3, bulk data geocoding with Nominatim and other geocoding tools

Nominatim address geocodinmg Excel

The 3rd part of this vast article about geocoding is slated for discussion about another free geocoding tool for MS Excel, namely the OpenStreetMap Nominatim geocoding and other remaining tools, which could be worth attention. NOMINATIM GEOCODING TOOL The usage of this small tool is very simple, even simpler than Bing Maps API geocoding, however, … Read more

The costless way to geocoding addresses in Excel – part 2, via Bing Maps API

Bing geocoding addresses in excel

It’s been a while since the previous part of this article when I showed you the way of geocoding the addresses via Google Sheets.  Here you will get the knowledge of geocoding straight from the Excel sheet, without launching external platforms. A front of your eyes you have another two options. These ways were mentioned … Read more

Excel Spreadsheet batch data geocoding for GeoJSON and JSON files

GeoJSON output in Leaflet

Recently I was dealing with geotagging single addresses in Google Maps and other easily accessible tools. However, the stuff, that I focused on is playing around with single placemarks only. I believe, that this operation is much more useful when we take into account not only the address but other details, related to this place. … Read more

The fastest way to execute UK address list using MySQL and PostgreSQL

UK Address list SQL

The United Kingdom addresses are specific because usually, a single postcode applies to a single building or at most a compact group of properties. It means, that these objects can be found very quickly, even when we are facing a bulk of addresses. Imagine, that under one unique postcode, you have a dozen or so … Read more

Input multiple address list to Google Maps and Google Earth – the quickest way

Excel address list in Google MyMaps

Google Maps, as well as Google Earth, are very useful tools in terms of location finding. A user can find a proper address quickly in any place in the World. Sometimes we are obligated to find multiple locations for different purposes. Then it can be a problem for someone, who must have a multitude of … Read more