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. 

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 lateror 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

Zooming and Bounds

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More

Encoding client keys for Maps

If you have a business account for Google Mapping, you'll need to provide your client id and crypto key. These ...
Read More

Using Google Earth – creating KML files

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More

Calculate lat/lon from distance

Given a start point, a distance and a heading, it is possible to work out the resulting latitude and longitude ...
Read More

Radians Versus Degrees

A radian is the ratio of an arc's length to its radius. See the wiki diagram below Radians tend to ...
Read More

VizMap Dictionary

Deprecated Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have ...
Read More

Tailoring Output

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More

Adding markers to Ovi Maps from Excel

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More

Adding markers to Bing Maps from Excel

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More

Adding markers to Yahoo Maps from Excel

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More

Adding markers to Google Maps from Excel

Deprecated Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have ...
Read More

Complete Excel Address Data with Bing Maps API

GeoCode Excel Data with Bing Maps If you haven't read about Bing rules on doing this, please do. Since we have done ...
Read More

GeoCoding

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More

Complete Excel Address Data with Yahoo Placemaker Maps API

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More

Mapping and adding markers to maps

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More

Data Driven Mapping applications

Deprecated Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have ...
Read More

Complete Excel Address Data with Google Mapping API

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also ...
Read More