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
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.
Learning about Mapping APIS
Directly from Excel, using Mapping providers APIs we will learn about
- Mapping and adding markers to maps
- Using Google Earth – creating KML files
- Creating data driven Mapping applications from Excel
- Encoding client keys for Maps
Please let me have your questions, comments and feedback at our forum. Read the summary blog entry comparing Bing, Yahoo, Ovi and Google Maps. For help and more information join our forum, follow the blog, follow me on Twitter