Hyperlink to Coordinates Using Excel?

CJ_18341

Greetings,

I'm looking to see if there's a way to hyperlink coordinates in an Excel spreadsheet so that NearMap opens up to the exact point referenced. I have the Lat/Long in Columns A and B, respectively, and I'm able to do it with GoogleMaps, so I'm wondering if the same capabilities are available with NearMap. Below is the formula I use in the Excel cell that provides the link to open directly to the GoogleMap version of my coordinates (A1 = latitude, B1 = longitude).

=HYPERLINK("https://maps.google.com/maps?q="&CONCATENATE(A1,",",B1),"Map It")

Any help in developing and utilizing NearMap with a hyperlink would be appreciated! Thanks in advance.

[Deleted User]

Hello @CJ_18341! Welcome to the community. I'll get someone to help you soon.

Jeff_6944

While in Mapbrowser, you can copy the url in the web browser and then paste it into your spreadsheet. The url would be like this here:  https://apps.nearmap.com/maps/#/9B7rxzWOTb-DtaHRZBQyMA/@41.9755570,-87.9126784,15.00z,0d/V/20240409

CJ_18341

Thank you, I will try that.

Roy_5843

Hi @CJ_18341,

Adding to what Jeff has shared, you can learn more on how to use the MapBrowser URL with the help of our documentation ( https://help.nearmap.com/kb/articles/701-ways-to-use-the-mapbrowser-url?utm_source=community-search&utm_medium=organic-search&utm_term=mapbrowser+url . I hope this helps.