Wednesday, January 28, 2009

Adding Images & IFrames to your Map Points

What are we talking about here?

So let’s say you have a map that depicts all of the countries you have visited.  It’s one thing to have a pin in France and show “Paris, 2008” in the pop up bubble, but it would be a heck of a lot cooler if you could click on that pin and see an image of you next to the Eifel Tower.

Alternatively, maybe you’re looking to provide some information about France to the person looking at the map.  The ability to integrate an IFrame into the pin pop up bubble makes it easy to show the user a fully functional website about French tourism when they click on the pin.

If you followed the couple tutorials that talked about hyperlinks, e-mail and Skype this should be a piece of cake…

What does it look like from a spreadsheet perspective?

Just like our last 2 tutorials, the key here is all in the way you enter data into your Google Spreadsheet.  Again, a bit of HTML is all you need.  

Take a look at the second column in the spreadsheet titled Image.  It contains the HTML required to place an image in your pin pop up bubble.

The third column (you will have to scroll right), titled IFrame, contains the HTML required to display an IFrame in your pin pop up bubble.  

Feel free to us the CONCATENATE function to make life easier if you want as explained in the a previous post (Adding Hyperlinks to Your Map Points).

The HTML, while a bit more complex than that needed to produce e-mail and Skype links, is still relatively self explanatory.  In both cases, all you are doing is providing the location of the Image/IFrame.  The IFrame requires some sizing – feel free to play with that to make it appear how you like it. 

You guessed it - from here, all you have to do is assign your fields in Step 2b of the map creation process and you're good to go.  If you have questions feel free to post to the help forum.

What does it look like from a map perspective?

As you might expect, we see the 2 pins plotted on the map below.  When you click on the pin in France you will see an image of the French flag (sorry, I didn’t have a picture of you next to the Eifel Tower).  

Okay, now try clicking on the other pin – which happens to be in Israel.  Give it a second because just like any web page it takes a second to load.  Cool, right – you actually see a website in the bubble with tourist info.

Your toolbox should be starting to fill up now…have fun with it,

--The Map Commissioner (E-mail)


  1. Hi,
    Would it be possible to create an expiry date for all the lines of the spreadsheet? We're a volunteer centre in Canada, and want to use this software to map out where all of our volunteer positions are located, but the tricky bit is that our positions are always expiring. They autimatically expire on our database, but they wouldn't on a spreadsheet. Is there a way to link our closed source database's constantly updating volunteer positions to your mapping software? Is there a fee we could pay for this?

    Thank you, and please email akislenko at if you have any advice on the situation.

  2. I would establish a column for the expiry dates for each row. Then enter those dates. I another new column I would add a formula to check the date such as:
    where F2 is the expiry date and B2 is the address column that you want to expire when that date passes.
    Then, you would use this same formula column for the address. It will be null if the date has past, and contain the address cell info when it has not.

  3. How can I can get a small dot for a pin? I need to plot 1000 cities on the world map.