Convert Excel Data into a Google Map
Vložit
- čas přidán 31. 10. 2021
- Learn how to take Excel data that includes locations and then convert it into a Google Map! ***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's the practice file for this video: bit.ly/exceltogooglemap #excel #exceltutorials #microsoft365 #googletutorial #gsuite #googlemymaps #googlemaps
- Jak na to + styl
I've used my maps extensively...importing an Excel spreadsheet (with Google geocoding...latitude & longitude) into my maps. It works great! 👍🏻 I really appreciated the extra detail on multiple layers. I've not needed more than one, but I can see how useful it will be. Please consider uploading another video on this topic. Thanks!
I am also looking at the creation of my map based on latitude and longitude, but I failed to do so. please help me in this regard. your kind help will be highly appreciated.
Lovely. I am not just baffled by your expertise in taking us through these formidable new topics, but also marvel at the fantastic wonderland of MS Excel. Cheers.
And also makes me wonder as to who was your GURU/tutor.
This is a game changer. Thank you so much for the clear explanation!!
Very helpful. You have a talent in explaining and teaching! The information you provided was excellent and fairly easy to follow which I need because it takes me awhile to learn new features such as this even though I have the basics of excel firmly down.
I’m going to watch the other video you mentioned now.
Thank you.
This is very similar to what Maptser looks like! Loved this
Nice tutorial! Does Google map help to plan the route or do you have to do it manually one by one for a large number of addresses in the same city?
Using this for survey data collection. Saved my time. Thank you!
one of the best youtube videos about maps I've ever watched
My spreadsheet will not import. Even created a simple spreadsheet with two just addresses and used the same headers as yours. Thoughts why it's not importing?
Thank you for creating this.
Do you know how to take data such as in your example and have google make a time line map or a travel map so I can see where I started a journey and how it progressed? I suspect it’s just a feature change but not sure.
If possible, would you make a mini video showing this for us? 😊
Very nice tutorial. Thanks for sharing your knowledge to us!
This tool is bonkers. I'm an attorney and used this for a particular purpose and when I showed my presentation using this tool my team almost shat their pants. Thanks for making me look good!
Very well put together. So how do you use it to optimize your driving routes, if possible? Thanks
Such a useful tool. Makes me look good at work. Thank you!
This is so great, thank you!
Is there any way to have my maps auto-update based on new information added to the workbook? Thank you in advance! Great video!
Extremely well done. Thank you!
Exactly what i was looking for!!
Really apreciate it, thank u very much!
This is what i was looking for. Thanks alot for sharing
that is so helpful, i am using it with my thesis, thank you so much!
Thank you very much. God Bless You!
Superb lesson 👍
Who knew? This is amazing!!
Thanks for the info! Is there a way to switch all markers at once?
WOW , SO AMAZING IDEAS
so amazing,thanks for sharing
Thank you! Thank you! Thank you!
Thank you so much for this!
Thank you 🙏🏽
I don't know how long you have been teaching teachers, but you have mastered the art. Informative - easy - quick - but *not* condescending! You have my admiration! Thank you.
Thank you soooo much for this video it really is so detailed and informative
Is there a way to export the latitude and longitude that is created by Google Maps?
Great Stuff thanks
wow thank you so much !!
Thank you for your shared, clear and understandable information and knowledge in this video. It helpd me to plan my bussiness route more easily! Greetings from Hungary, Europe.
Thank you for your kind words and the gift. I really appreciate it.
woww.....thank you for sharing this
Thanks a lot 🇧🇩🌹
Love it, thank you! Is there any way to do this with Google Earth?
thank you!
this was very helpful. i had a few items that I had added by clicking on the + sign and it appeared on the map. later i had a separate spreadsheet that i tried to add to the same layer and it went bananas. how could i rectify this? unless you have already made another video...... 😀
Thx for this. you fixed one of my big problemes
This a great video. I'm still struggling because I need it only for Europe. Can you make a video for that?
Thank you. I just mapped out pre-foreclosures from the excel sheet I built from the county records in my area.
So what I needed for mapping bead & craft stores located in the USA...Thanks!
Is there a way to make this auto fill based on information added to a google sheet? I thought Geosheets was the answer, but that service seems to have crashed.
Please make an updated video on Google my maps. That would be great great 👍 Helpful videos thank you.
Nice video
Is there a way to upload multiple layers in bulk at once? Having the ability to toggle on/off layers are useful. THX
Can you make the best route after you get the location ? Excellent video !
Do you have a video about excell to timeline format?
thanks
An now how do i do to see this map in my regular google maps app in my phone?
Can i embed it in my own website?
What would happen if my workbook has more than one worksheet and data's are in tables?
Does the map refresh when the spreadsheet is edited?
Is it possible to allow other people you shear your map to search for entities on the map without giving them access to edit the map?
How do i remove those items that fall on the other/no value field?
Thanks a lot !
Can you please make a video on how to use OFF of routes into the map to navigate my route based on the PDF route map provided to me. I'm a rider and need to learn this for navigation of routes. I'll be very thankful to you. 🙂
Interesting
I am importing excel data by state into google maps.
For some reason I get an error saying 20 of the 42 states on the list can't be added because of errors.
It says to open the data table to fix the errors.
However, when I open the data table, all the state entries are correct.
Changing abbreviation to the state name doesn't work, because it defaults the state of Georgia to the country of Georgia.
Clicking on the red triangle doesn't help, because t doesn't give any information.
I wish I had a google map of my warehouse to do a heat map like that.
cool
I did the upload, but why are all my points about a block off from where the address actually is? I need them to be accurate.
💜
YESSSSSSSSSSSS
My columns with my addresses is not appearing on the Google map after I import the spreadsheet. Please help me?
Update: I figure out what I did wrong. This method is a game changer for me. Thank you for this video 🙏
@@tamaraclarke2812 what did you do wrong because mine isn't working either
Feeling like a hacker!
What I need to perform is to enter in 30 stores and have them listed in the order I need to make them
Should be titled: "Convert Excel Data into a Google My Map." Google Maps ≠ Google My Maps
How to search on google my maps