Generate Google Maps Links using a simple Google Sheet Formula

3 min readApr 2, 2023

Welcome!

In this blog I will be showing you how to generate Google Maps link using a simple Google Sheet Formula. This idea originated when one of my friends was building a project and he had addresses stored in a Google Sheet. He wanted to get the link of the addresses that are present in the sheet.

Doing this manually, would be a very long task, hence we are going to use some Google Sheet formulas to automate the process of generating Google maps links.

You can check out the full video below.

Sample Google Sheet

The Google Sheet that I will be using for this blog contains the following details:

Location of the place
Google Maps link to the location

We are going to be use a couple of Google Sheet formulas to generate the Google Maps links for the locations in the sheet.

If you want to work with the sheet, click here.

Step1: Understanding the Formulas

To generate the Google Map links, we are going to be using two important formulas, they are as follows:

CONCATENATE()
— This formula is used to append strings to one another. To know more about the formula, check out the link below.

CONCATENATE function

Appends strings to one another. CONCATENATE("Welcome", " ", "to", " ", "Sheets!") CONCATENATE(A1,A2,A3)…

support.google.com

2. HYPERLINK()
— This formula is used to create a hyperlink inside a cell

HYPERLINK

Creates a hyperlink inside a cell. HYPERLINK("http://www.google.com/","Google") HYPERLINK(url, [link_label]) url - The…

support.google.com

The CONCATENATE() formula will be used to merge the search query with the link that we are going to be using. After the link is merged we are going to be using the HYPERLINK() formula to create link that the user can click if they want to view it on Google Maps.

https://www.google.com/maps/search/?api=1&query=

We are going to using this link and going to add the address in front of this to generate the Google Map link for that address.

Step2: Insert the Formulas

To generate Google Map links from the data in the Google Sheet, we are going to be using the two formulas that we just discussed above.

Here you can see we have used two formulas, HYPERLINK() and CONCATENATE() .

We have first used the CONCATENATE() formula to merge the search link and the query, followed by using the HYPERLINK() formula to create a clickable link.

On successful execution you can see that a Google Maps link for that gets generated successfully.

Here you can see using these two formulas we have successfully been able to generate Google Maps links for all the addresses automatically.

On clicking the link, it takes me to the Google Maps website where you can see that the link has taken me to the correct address.

Conclusion

In this blog we saw how we can generate Google Map links for addresses stored in a Google Sheet using two simple formulas. This can be used if you have a lot of addresses stored in your Google Sheet and you want to generate Google Map links for them.

I hope you have understood how to generate Google Map links in Google Sheets using the CONCATENATE() and HYPERLINK() formula.

Feel free to reach out if you have any issues/feedback at aryanirani123@gmail.com.