I’ve been using an excel spreadsheet with a VBA macro to take both international and domestic cities and states (or regions) as an input and give back longitudes and latitudes for each location so that I could then import and map them in Tableau. Set up like this:
City Region Longitude Latitude
Pittsburgh PA (PittLongitude) (PittLatitude)
The geocoding service I’ve been using doesn’t seem to be responding anymore or has crashed on my computer. Does anyone know of any service or solution to be able to batch geocode like this?
Why not use the built in geocoding in Tableau? International and domestic cities were added in 6.1. States or regions have been there much longer. If there is something missing, please let us know.