Adding a Hyperlink to Maps to a Custom Report

 In GPS Tracking Benefits

Adding a Hyperlink to Maps to a Custom Report

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")

Original Post

Recent Posts
Contact Us

Send us an email message and we'll get back to you asap. It's best if you can also include your phone number