Avatar

Adding a Hyperlink to Maps to a Custom Report

1

It is sometimes useful to have a hyperlink in the Excel report that links to an external site directly. For example, if the report has the latitude and longitude available you can use the HYPERLINK function in Excel to create this link.

This is done as follows:

hyperlink.PNG

use the HYPERLINK function in a formula.
It takes two arguments, the first is the URL that it must point to, the second is what should be displayed to the user.

A Google map link has this format: maps.google.com/maps?q=43.3,-79 where the q=43.3,-79 is the part where you specify the coordinate.

If you have the coordinate in the report as columns, you can easily create a link that follows the format specified above by referencing the relevant columns:

=HYPERLINK("http://maps.google.com/maps?q="&D2&","&E2,"See location")

Mauricio Muniz

Please sign in to leave a comment.

4 comments

0
Avatar

Garret,

You have one too many &. If you look at the formula you have you have an & at the end that should not be there.

Mauricio Muniz 0 votes
0
Avatar

Wow, hah thanks, i thought i verified that before the screenshot hah. 

Ok it works now. Thanks!

Garret - Fleet Profit Center 0 votes
0
Avatar

Mauricio,

Can we get the link to pull the city and state info from the Lat Long and insert into Excel?

David Rivera 0 votes