Skip to main content

Adding Hyperlinks to Your Map Points

What are we talking about here?
The ability to visualize a list of addresses on a map is definitely useful - and it's what we're all about here at MapAList.  Leveraging hyperlinks within maps makes them even more interactive for you and your users.  

In this first post about hyperlinks, the goal is to show you how to associate a link to a website with a pin on your map.  This will allow whomever is viewing your map to click on a pin and see hyperlinks in the bubble that pops up. Furthermore, it will enable the viewer to click on the hyperlinks to navigate to a URL directly from the map. 

Sound cool?  It is.  Sound hard?  Don't worry, we'll walk you through it...

What does it look like from a spreadsheet perspective?
There are 2 approaches to making this work, one certainly more efficient if you are dealing with multiple address records.

In the sample spreadsheet below, you can see a column called Site which is used to associate the address with a website (URL).  You can see that in the Site column the MapAList URL has been inserted (  The next column is called Site Link (you'll have to scroll to the right on the IFrame below to see it).  Here's where those 2 different approaches come in...

1. You can simply enter the HTML in the cell.  In other words,  you can type in the following:

<a target='_new' href=''>MapAList HQ</a>

2. In order to avoid typing the HTML out for every record, you can use the CONCATENATE function and reference the cell in the Site column that contains the URL.  Instead of entering the HTML in cell D2 (column 4 row 2), you would enter the following:

=CONCATENATE("<a target='_new' href="', C2,'">", A2,"</a>")

So what the heck do those HTML tags mean?
This isn't a HTML tutorial, but we can still break it down for you briefly...

<a target='_new' href=''>MapAList HQ</a>

target='_new' - the target attribute tells your browser to open the link in a new window

href='' - the link URL tells your browser what URL to open in that new window

MapAList HQ - the link text defines what will be displayed (and clickable)

Okay, you've got the link in the spreadsheet - now what?

This is the easy part.  All you have to do is referance the column in the spreadsheet that contains your link in Step 2b where you assign your fields to your map.  Simply select column that contains the links as either the Title or Additional Info values so that they will show up in the bubble when you click on the map pin.  That's all you have to do.

Click on the image above to take a closer look

What does it look like from a map perspective?

So give it a try - click on the green pin on the map below and you'll see MapAList HQ in the pop up bubble.  Click on MapAList HQ in the pop up bubble and a new browser window will open up to

What are other users doing with this feature?
The use of hyperlinks within maps is quickly becoming a very popular feature.  The most common uses to date are: 

•Mapping companies and linking to their homepages


•Mapping friends and linking to their Facebook, LinkedIn, MySpace, or Blog pages

So get creative and give it a try!

Hope this was helpful...more to come.

--The Map Commissioner (E-mail)


  1. Nice works folks. This is pretty awesome. Thank you very much for the resources!

  2. Pune city is one of the largest city of Maharashtra state. Here guide to travel of Pune with Pune city map, pune tourism map, Pune road map, location of hotel in Pune and all about Pune city. Also get about colleges in Pune, uni pune. Pune job,etc. Pune City Map

  3. Maharashtra Map | Maharashtra State Map | India in Maps. Maharashtra State Map
    Maharashtra State Map showing its political features. Get the detailed information about List of all Districts in Maharashtra, Maharashtra, Facts About Maharashtra, Maharashtra Tourism, Maharashtra Districts, government of Maharashtra, Maharashtra cities and Maharashtra Map.

  4. Programming Assignment help
    Programming Assignment Help is efficient in reducing stress from your academic life. It can save most of your time. Hence you can utilize your time in other necessary works. However, it is essential to choose a proper service; else it can trouble you badly. To avoid this, you must check the online reviews for a better Computer Science assignment

  5. Looking at divorced couples make me feel that marriages are ephemeral. But you both have proved that marriages are truly eternal. Happy anniversary. anniversary wishes messages

  6. It is nice to read such high-quality content. It is a good article that discusses the topic at hand quite well. I am looking forward to read more articles from your site. Keep up the good work.
    assignment help

  7. I’m blessed three times over. You’re a wonderful mother to my grandchild, an amazing wife to my son
    happy mothers day 2019
    happy mother day quotes

  8. This post truly made my day. You can’t imagine just how much time I had spent for this information! Thanks.
    Hooda Math
    Didi Games

  9. The information you have shared with us is beneficial and informative. MyAssignmentHelp provides urgent assignment help services at affordable prices and delivers work before the asked deadline.


Post a Comment

Popular posts from this blog

Taking your Maps to the Next Level

As our user count has steadily grown, the MapAList support team has received an increasing number of calls and e-mails from users looking to do more with our solution. Over 80% of the feature requests we’ve received are, well, features that already exist within the base MapAList solution.

What does that tell us?

What it tells me is that we need to do a better job articulating the feature set MapAList has to offer out of the box...and that’s exactly what we’re going to do.

For the next several weeks we will be publishing installments of Taking Your Maps to the Next Level – a series of short tutorials meant to enable you, the user, to get more out of MapAList. Each installment will focus on a single feature, show examples of both spreadsheets and maps, and provide step by step instructions to make it work.

Here’s the current plan…

01/02/09 –Basic Grouping to Show Differentiation
01/09/09 – Advanced Grouping to Show Differentiation
01/16/09 – Adding Hyperlinks to Your Map Points
01/23/09 – Addin…

Allow your Member/User Base to Add Pins to your Map Using Google Forms

As the MapAList user base has grown over the past couple of years, one of the things we’ve noticed is that we have a ton of organizations leveraging our toolset to map their member/user bases.Religious organizations use MapAList to track their congregations; alumni associations use MapAList to track their members; campaigns and non-profits use MapAList to track their supporters/donors…you get the point. The reason I bring this up is because a few of these organizations have gotten smart and realized that they could push the work of updating their maps out to the user based directly using Google Forms.It’s like self check-out at the grocery store – the users love it because they are empowered (and because it’s a novelty to scan those barcodes) and so does the store because it reduces labor.Sounds cool – right?Well, implementing such a solution on your site with MapAList is not terribly difficult.Those folks at Google have made Google Forms easy to design and feed to a Google Spreadsheet…