How To Create Google Map and Directions Link With Excel

[@ExcelForFreelancers]

📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

[@mariaakero3869]

Thanxs Randy for just filming THE new things so that THE video is not Long

[@ExcelForFreelancers]

Ok thank you very much.

[@macman007747]

Another great lesson Randy! I really like how you provide the references to skills you have shown in other videos. Thanks for all that you do Randy!

[@ExcelForFreelancers]

Glad it was helpful and thanks so much Rob.

[@overpowermarketing2706]

thank you, just the fact of knowing about the Google Direction URL is just the address added onto it, made it all worth it

[@ExcelForFreelancers]

That's great to hear and I am glad you found it valuable. Thank you for your Likes, Shares & Comments. It really helps.

Wow! Another useful video. Thanks Randy.

[@ExcelForFreelancers]

Thanks Hélène, you are always so kind to me :)

[@pogwo1968]

Is it possible for you to create a tutorial for Zillow or Redfin map for real estate investing wholesalers?

[@ExcelForFreelancers]

HI and thanks very much. I believe their API is not for free and you would have to subscribe before gaining access to their data, so this is not something I could create a tutorial for. Thank you for the idea though :)

[@jafarpazhouheshpour4864]

Thank you , I have a question. I want to have several addresses with no directions on the Google map, What should I change in this Macro? Apologies for my English.

[@ExcelForFreelancers]

Hi and thanks you can create this using a csv and uploading it to Google Maps. More details on that here: www.google.com/earth/outreach/learn/visualize-your-data-on-a-custom-map-using-google-my-maps/

[@mdsaiful6294]

Nice video 😊

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Saiful

[@itamarconceicao6708]

Great Video! Please, how can I get distance and time travel in that maps?

[@ExcelForFreelancers]

Hi and thanks both Distance & Time are part of the Google Maps API. Just follow the training and add those two options within the results and have that data come into the response. I hope this helps and thanks so much.

[@itamarconceicao6708]

@@ExcelForFreelancers Sorry ... My English is not very good! Excuse me again! I think my message was not well written. I would like to bring the distance and travel time data from Google Maps to the Excel spreadsheet. Is it possible?

[@ExcelForFreelancers]

Yes that is correct. I understand you. Please use the API and video training to bring in distance and travel time. It is all there, you just have to bring it in.

[@itamarconceicao6708]

@@ExcelForFreelancers ok! Thanks again!

[@podbrothers9492]

What looks like the url if I want to search multiple addresses? For example I want to see 5 address with red pin, by typing once the url. Thanks

[@ExcelForFreelancers]

Hi and thanks. You can use a 3rd party tool such as integromat or other tools that will send a text file with multiple addresses to handle this. I hope this helps and thanks so much.

[@madandivya]

Sir this video super

[@ExcelForFreelancers]

So nice of you. Thank you for your Likes, Shares & Comments. It really helps.

[@sunilloke9685]

Thank You.....Sir

[@ExcelForFreelancers]

For sure, you are very welcome. Happy to create this for you

[@selftravelling]

Can I get this link buying 150 Workbook Zip File?

[@ExcelForFreelancers]

Hi and thanks so much. Yes you can get the link here: bit.ly/300WkBks_Randy I hope this helps and thanks so much.

[@SyedMuzammilMahasanShahi]

Thanks for this amazing video

[@ExcelForFreelancers]

For sure, you are very welcome

[@gporoi]

That is so awesome! You are pretty skilled, sir. Wow!! I’ve been looking for such a video, and thank goodness I found this. I do have one query, though. I don’t really want Google Map to come up. I want the code to run in the background and then, when Google Map finds the multiple addresses, it gets back to me with the correct spelling of the addresses. Does this make sense?🤔 Not sure. Alright. Let me explain. I work for a Europe-based company. Our European customers understandably want a correct billing address. However, it can be hard to type their symbols on our computer keyboard. For example, the non-latin letters “ß” in German, or the “ñ” in Spanish to name but a few. So I would like to create a button and assign a macro that would get the address on Google Map (without opening it) and get back to me (maybe with a message box) with the correct address. Someone suggested that I should use the “Inspect element” technique but I’m not quite sure how to do it. Lol. Is it at all possible?

[@ExcelForFreelancers]

HI and thanks for your comment. Yes that makes sense. Google Maps API can do a java POST and GET which means you can submit map information and google, through its website, can respond with things like distance and directions and other data. Please search the google site for "Google Maps API" to get more information on this.

[@gporoi]

Alright. I’ll do my research then. Thank you. Cheers.

[@thehgamers]

@@gporoi Did u succeed? if yes, please share

[@parikshitdambhare6647]

Thank you sir... love from India ❤️

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much.

[@עמירצין]

Hi Is there a way to open the map directly in the workbook?

[@ExcelForFreelancers]

Yes it is possible using the internet explorer browser object. Thanks for your suggestions.

[@alebm82]

awsome!

[@ExcelForFreelancers]

Thanks so much.

[@madandivya]

Sir I need to this tool in excel based on Google Map Extractor | Google Map Scraper |export a huge number of Business Contacts.

[@ExcelForFreelancers]

Hi and thanks for your comment. I have not worked with the Google Map Scraper before however you can check their API for details.

[@madandivya]

@@ExcelForFreelancers thank you sir

[@SelvaKumar-tj3eb]

I have 150location of longitude latitude number around 60km, any way to passable to use this concept

[@ExcelForFreelancers]

Hi am not sure as I have not used it. That would be a good question for our Facebook group in which you can post here: Http://bit.ly/groupexcel

[@SelvaKumar-tj3eb]

This video also super

[@ExcelForFreelancers]

Selva Kumar Thanks very much

[@SelvaKumar-tj3eb]

Please accept my Fb account 🆔 Selvajackson

[@AYUSHGUPTABME]

Is there a way we can add stops also and get the directions

[@ExcelForFreelancers]

Hi yes certainly you can customize the code to add multiple stops according to Google's API, the workbook is open and unlocked so you can customize it by adding additional code and columns to support additional stops. Thanks so much for your comment and question.

[@AYUSHGUPTABME]

Can you help me with that

[@ExcelForFreelancers]

Hello , Thank you for your comment. The application is open and your are welcome to customize this to fit your exact requirements. If you would like some help with this, we have a group with 15,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.

[@VS.R3LeVant]

is the a way to do bulk lookup

[@ExcelForFreelancers]

I believe so, Google API is quite powerful. You can check the documentation provided by Google for their Mapping API. Thanks for your comment.

[@stevecourtney3625]

I think you mean forward slash (not back slash)

[@ExcelForFreelancers]

Correct Steve, Thanks so much.