I started to use Excel VBA to do batch geocoding calls to Yahoo and Google Map API, it works. See Excel sheet attached (xlsm) . However, when I was trying to plot the locations on the map, using KML layer, it turned out that the simplest way to do geocoding and maping is Google Fusion Tables.
Just import the locations / addresses into a new empty Fusion Table, it will take care of geocoding and the maping in one place.
If only I knew this earlier, but isn't that what ought to be anyway?

Ps. Google Fusion Tables won't export the latitude/longitude coordinates, so the excel vba is still useful ;-)

Leave a Reply.