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. 

Put addresses on a map as markers

We’ve already looked at how to geoCode addresses using various APIs and how to create maps with Google Maps from Excel data.  Now let’s look at using Yahoo Maps  to put markers on a Map using an Excel worksheet as input. As usual you can find the completed example in the googleMapping.xlsm download. Before running this please check the parameter worksheet and change the filename value  for the place that the application will generate a web page to something relevant for your machine. Look for the  filename in the Yahoo Marker html section of the Parameter Worksheet.

Yahoo Maps versus Google Maps

Actually there is really not much difference in basic capability. In fact I was able to handle any difference in the javaScript in the Parameter Worksheet, so the only difference in Excel code between Yahoo Maps and Google Maps is to use a different parameter block

Here is the Google

versus the Yahoo code

It doesn’t get any easier than that. Since Yahoo Maps needs a key, I had to also pick up the Yahoo Key from the parameter sheet. The zoom level is also different – I set a default of 16 which seems to be equivalent to a Google Maps zoom level 2.

How does it look

Actually the Yahoo Maps are prettier, but they do take longer to load.

Compare Yahoo Maps to others

I’ve implemented this exact same thing on other APIs as below.  Take a look to compare. My recommendation is to stick with Google Maps.

The generated file is shown below for Yahoo. This is created automatically by the Excel Application and needs no tweaking.


Well that was pretty easy to implement – about half an hour with just some tweaking of the Google Mapping parameters and some small javaScript changes and it’s done. Yahoo Maps seems very clean to use – however they are closing the service – see below from their website. I will head over to Ovi Maps and see how that works later.

Announcement from Yahoo back then: “We are shutting down this service on September 13, 2011. We suggest using maps from our partner Nokia. Please visit the Ovi Maps API for more information.”

For help and more information join our forum, follow the blog, follow me on twitter