Convert Excel Data into a Google Map

  Рет қаралды 196,873

Technology for Teachers and Students

Technology for Teachers and Students

Күн бұрын

Пікірлер: 78
@CharlesWorth-d1c
@CharlesWorth-d1c Жыл бұрын
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.
@Tibi4791
@Tibi4791 7 ай бұрын
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.
@techteachersandstudents
@techteachersandstudents 7 ай бұрын
Thank you for your kind words and the gift. I really appreciate it.
@runningaway2388
@runningaway2388 2 жыл бұрын
one of the best youtube videos about maps I've ever watched
@DemetriPanici
@DemetriPanici 3 жыл бұрын
This is very similar to what Maptser looks like! Loved this
@DSKesq
@DSKesq Жыл бұрын
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!
@saroshhavewala1489
@saroshhavewala1489 2 жыл бұрын
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?
@FortunaFound
@FortunaFound Жыл бұрын
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.
@purpleologist
@purpleologist 3 жыл бұрын
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!
@mohammadirshad3166
@mohammadirshad3166 Жыл бұрын
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.
@rochellefennell955
@rochellefennell955 Жыл бұрын
Thanks for the info! Is there a way to switch all markers at once?
@rogeliobenavides1169
@rogeliobenavides1169 10 ай бұрын
Can you make the best route after you get the location ? Excellent video !
@scottfrost2855
@scottfrost2855 2 жыл бұрын
Is there any way to have my maps auto-update based on new information added to the workbook? Thank you in advance! Great video!
@siyuchen7339
@siyuchen7339 8 ай бұрын
Is there a way to upload multiple layers in bulk at once? Having the ability to toggle on/off layers are useful. THX
@Life_is_very_Beautiful
@Life_is_very_Beautiful 3 жыл бұрын
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.
@MargueriteLowak
@MargueriteLowak 3 жыл бұрын
This is a game changer. Thank you so much for the clear explanation!!
@aspergerhellasbn
@aspergerhellasbn Жыл бұрын
This is what i was looking for. Thanks alot for sharing
@Firemission-qw3lj
@Firemission-qw3lj 6 ай бұрын
Do you have a video about excell to timeline format?
@agustinvidal99
@agustinvidal99 6 ай бұрын
Does the map refresh when the spreadsheet is edited?
@MaiAlHussain-s4d
@MaiAlHussain-s4d Жыл бұрын
that is so helpful, i am using it with my thesis, thank you so much!
@heroone6067
@heroone6067 Жыл бұрын
Can i embed it in my own website?
@buildergirl2515
@buildergirl2515 6 ай бұрын
Thank you. I just mapped out pre-foreclosures from the excel sheet I built from the county records in my area.
@MGW7347
@MGW7347 Жыл бұрын
Using this for survey data collection. Saved my time. Thank you!
@uiagraphics-customprinting975
@uiagraphics-customprinting975 Жыл бұрын
Very well put together. So how do you use it to optimize your driving routes, if possible? Thanks
@Rayray17772
@Rayray17772 9 ай бұрын
Extremely well done. Thank you!
@amyfelton-toth4172
@amyfelton-toth4172 3 жыл бұрын
Is there a way to export the latitude and longitude that is created by Google Maps?
@JB-fh9rb
@JB-fh9rb 4 ай бұрын
Really Cool! Very helpful!! I needed a way to reflect over 500 service locations for my organization excellent solution!
@lancesimmons7025
@lancesimmons7025 Жыл бұрын
Love it, thank you! Is there any way to do this with Google Earth?
@xXboy93Xx
@xXboy93Xx Жыл бұрын
Exactly what i was looking for!! Really apreciate it, thank u very much!
@nyasawide-tv2838
@nyasawide-tv2838 Ай бұрын
Thanks is my favorite video that soon will change my life_ my first health project will originate from this video
@csher6734
@csher6734 4 ай бұрын
Is there a way to create a "cluster" map using this same data? Can the data be aggregated by location? Say for a customer list, etc?
@ronaldodavis9138
@ronaldodavis9138 Жыл бұрын
Such a useful tool. Makes me look good at work. Thank you!
@lonelymusicboy
@lonelymusicboy 9 ай бұрын
Thank you so much for this!
@lei2827
@lei2827 8 ай бұрын
How do i remove those items that fall on the other/no value field?
@nanakwekuoppongasiamah524
@nanakwekuoppongasiamah524 6 ай бұрын
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?
@NaturalplacesofCeylon
@NaturalplacesofCeylon Ай бұрын
how can we reimport data, without changing existing data? I was trying the reimport option. new data was added but all formats restored
@cesarfelipe
@cesarfelipe 2 жыл бұрын
An now how do i do to see this map in my regular google maps app in my phone?
@sablebenjamin3292
@sablebenjamin3292 2 жыл бұрын
This a great video. I'm still struggling because I need it only for Europe. Can you make a video for that?
@jadewilson8534
@jadewilson8534 Жыл бұрын
Thank you soooo much for this video it really is so detailed and informative
@Manchitre-Vromon
@Manchitre-Vromon Жыл бұрын
Thanks a lot 🇧🇩🌹
@luckybaba8545
@luckybaba8545 2 жыл бұрын
Thx for this. you fixed one of my big problemes
@strngf7
@strngf7 2 жыл бұрын
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?
@sameenakausar1020
@sameenakausar1020 Жыл бұрын
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. 🙂
@AM-pc3yd
@AM-pc3yd Жыл бұрын
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...... 😀
@killahlmw23
@killahlmw23 Жыл бұрын
Thank you! Thank you! Thank you!
@Simply.C
@Simply.C Жыл бұрын
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.
@jeaninehaack1459
@jeaninehaack1459 3 жыл бұрын
Who knew? This is amazing!!
@AmieFajardoNZ
@AmieFajardoNZ 3 жыл бұрын
Very nice tutorial. Thanks for sharing your knowledge to us!
@wenxinhuang8763
@wenxinhuang8763 Жыл бұрын
so amazing,thanks for sharing
@DPC1959
@DPC1959 10 ай бұрын
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.
@harshitabhawsar745
@harshitabhawsar745 Жыл бұрын
woww.....thank you for sharing this
@kdbeadthebeadstylist8641
@kdbeadthebeadstylist8641 3 жыл бұрын
So what I needed for mapping bead & craft stores located in the USA...Thanks!
@Simply.C
@Simply.C Жыл бұрын
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? 😊
@ashminishashadara2726
@ashminishashadara2726 2 жыл бұрын
Superb lesson 👍
@moesadr3342
@moesadr3342 2 жыл бұрын
What would happen if my workbook has more than one worksheet and data's are in tables?
@basazinewdegu4181
@basazinewdegu4181 2 жыл бұрын
Thank you very much. God Bless You!
@matteyman4274
@matteyman4274 3 жыл бұрын
This is so great, thank you!
@robbradshaw5534
@robbradshaw5534 2 жыл бұрын
Please make an updated video on Google my maps. That would be great great 👍 Helpful videos thank you.
@erinfield1943
@erinfield1943 Жыл бұрын
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.
@MartinTodoroski-m2y
@MartinTodoroski-m2y 3 ай бұрын
Thanks alot!
@kimwenceslaosanchez4449
@kimwenceslaosanchez4449 3 жыл бұрын
WOW , SO AMAZING IDEAS
@tamaraclarke2812
@tamaraclarke2812 2 жыл бұрын
My columns with my addresses is not appearing on the Google map after I import the spreadsheet. Please help me?
@tamaraclarke2812
@tamaraclarke2812 2 жыл бұрын
Update: I figure out what I did wrong. This method is a game changer for me. Thank you for this video 🙏
@meganoleary817
@meganoleary817 2 жыл бұрын
@@tamaraclarke2812 what did you do wrong because mine isn't working either
@sanjeewarmsk
@sanjeewarmsk 2 жыл бұрын
Great Stuff thanks
@thania2266
@thania2266 3 жыл бұрын
Thank you 🙏🏽
@boldizsarolah3490
@boldizsarolah3490 Жыл бұрын
thank you!
@9990337204
@9990337204 2 жыл бұрын
How to search on google my maps
@uexcelinmsoffice4323
@uexcelinmsoffice4323 3 жыл бұрын
Nice video
@Kruse1
@Kruse1 3 жыл бұрын
I wish I had a google map of my warehouse to do a heat map like that.
@garymeek4080
@garymeek4080 Жыл бұрын
What I need to perform is to enter in 30 stores and have them listed in the order I need to make them
@paultannahill5043
@paultannahill5043 10 ай бұрын
Should be titled: "Convert Excel Data into a Google My Map." Google Maps ≠ Google My Maps
@Disciplinemh
@Disciplinemh Жыл бұрын
thanks
@d4ng3l
@d4ng3l 11 ай бұрын
Feeling like a hacker!
@eliemrad7
@eliemrad7 3 жыл бұрын
Interesting
@cynthiaelesevandyke-melcho1864
@cynthiaelesevandyke-melcho1864 3 жыл бұрын
💜
@ruslangeography104
@ruslangeography104 3 жыл бұрын
cool
@felipesanin1808
@felipesanin1808 Жыл бұрын
YESSSSSSSSSSSS
The Excel Format Painter - Basics and Beyond
7:06
Technology for Teachers and Students
Рет қаралды 55 М.
GOOGLE MY MAPS TUTORIAL | Get Started with Travel Planning
16:34
travelaimes
Рет қаралды 81 М.
How to have fun with a child 🤣 Food wrap frame! #shorts
0:21
BadaBOOM!
Рет қаралды 17 МЛН
ВЛОГ ДИАНА В ТУРЦИИ
1:31:22
Lady Diana VLOG
Рет қаралды 1,2 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 958 М.
Top 20 Google Maps Tips & Tricks: All the best features you should know!
11:29
Using Excel's XLOOKUP Function
11:16
Technology for Teachers and Students
Рет қаралды 106 М.
How to Plan Your Trip With Google MY MAPS ⎜Google Maps Tutorial
21:33
The Travel Coaches
Рет қаралды 135 М.
Intermediate Excel Skills, Tips, and Tricks Tutorial
20:18
Technology for Teachers and Students
Рет қаралды 6 МЛН
Creating Easy Data Entry Forms in Excel
9:52
Technology for Teachers and Students
Рет қаралды 3,1 МЛН
Create a Custom Map with Google My Maps (No Code)
7:03
Steve Builds Websites
Рет қаралды 28 М.