Integrating Excel with Maps and Earth

Deprecated

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also been either removed or changed. Therefore, I had to remove all examples of VizMap applications I had created. I didn’t remove the entire topic as I thought some of the code may still be useful with some modifications.

Page Content hide

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

2 Try it out first ?

3 Learning about Mapping APIS

3.1 Summary

3.2 Zooming and Bounds

3.3 Encoding client keys for Maps

3.4 Using Google Earth – creating KML files

3.5 Calculate lat/lon from distance

3.6 Radians Versus Degrees

3.7 VizMap Dictionary

3.8 Tailoring Output

3.9 Adding markers to Ovi Maps from Excel

3.10 Adding markers to Bing Maps from Excel

3.11 Adding markers to Yahoo Maps from Excel

3.12 Adding markers to Google Maps from Excel

3.13 Complete Excel Address Data with Bing Maps API

3.14 GeoCoding

3.15 Complete Excel Address Data with Yahoo Placemaker Maps API

3.16 Mapping and adding markers to maps

3.17 Data Driven Mapping applications

3.18 Complete Excel Address Data with Google Mapping API

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.

Learning about Mapping APIS

Directly from Excel, using Mapping providers APIs we will learn about

Summary

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

Subpages