Integrating Excel with Maps and Earth

Geocoding, Mapping and creating data driven applications straight out of Excel get it now

This article will cover 3 main topics. I wrote all this stuff a few years ago, and some of the services may have changed or been deprecated. Certainly the Google Maps stuff still works as before, but of the others may not. I need to do a refresh on all this material to take advantage of all the newer great MAPS stuff. Watch this space.
  • How to use the most common APIs for GeoCoding (clean up an address and find it's co-ordinates)
  • How to plot Excel data directly on a map using a variety of mapping providers
  • How to create rich, data driven applications that integrate Maps, Earth, Visualizations and Twitter straight from Excel parameter data, without needing to write any javaScript.
If you are interested in how all this is coded, or how the APIS compare, you can read this and subsequent pages.  Read the summary blog entry comparing Bing, Yahoo, Ovi and Google Maps. If you are more interested in choropleth maps in Excel, see Coloring maps and other shapes

Try it out first ?

If you just want a to take a look at some generated applications, then you can download and generate an example application (googleMapping.xlsm) and come back here later, or try some of these applications that have already been generated straight out of excel. For a quick start, try Step by Step Guides