How to Build a Custom Google Map Using Addresses in Google Sheets

preview_player
Показать описание
Here’s a nifty trick that combines both Google Sheets and Maps. When you enter addresses into Sheets, you can then display all of the locations right in Maps, creating your own custom map. This is great for plotting business locations, deliveries, business contacts, or even just a personal travel itinerary.

To read the full article, visit this link:
Рекомендации по теме
Комментарии
Автор

Yes the only deal-breaker for me is that this add-on asks for permission to all files in my google drive, not cool

StefanWesselsZA
Автор

If a client has multiple locations listed in multiple Sheets columns is there a way to add these columns into the address selection pull down?

rmischel
Автор

is there any way to build a route that would be time and distance efficient ? i'm trying to build a route for my drivers to drop marketing material off IE canvassing, all over a big city and its surrounding suburbs... is this possible?

youngkinghedwig
Автор

Its free version only allows 50 addresses to be mapped.... but thanks

DrownedAmazon
Автор

is there a way map will open on the same tab as the details and not open on the new tab? thanks

jorielbalverde
Автор

BEWARE, this add-on requires full access to all your google drive files.
I wonder why... hmmm

lbermude
Автор

Hi, I wanna ask you about how I can download my locations in google maps as excel file .

العنودمحمد-فع
Автор

Super helpful !!! Thanks a lot !!!! Cheers,

aseladematagoda
Автор

Does it show the label too? On top of the pin?

lovebes
Автор

What about the permissions request that ask for permission to view, delete, copy ...'all' Google you kidding me?...do not approve this.

giles
Автор

Is there a way to utilize a row instead of a column for the address, names, etc? Thanks

treykostohryz
Автор

Access to all my google drive docs? deal breaker.
"This will allow Mapping Sheets to:
See, edit, create, and delete all of your Google Drive files
View and manage spreadsheets that this application has been installed in
Connect to an external service
Display and run third-party web content in prompts and sidebars inside Google applications"

kevinmccarthy
Автор

is there a way to share the map to the public instead of an invitation trough email?

GameOverYg
visit shbcf.ru