Тёмный

Convert Excel Data into a Google Map 

Technology for Teachers and Students
Подписаться 1,5 млн
Просмотров 165 тыс.
50% 1

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

Хобби

Опубликовано:

 

31 окт 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 74   
@MargueriteLowak
@MargueriteLowak 2 года назад
This is a game changer. Thank you so much for the clear explanation!!
@user-ns8zl7fe3w
@user-ns8zl7fe3w 7 месяцев назад
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.
@MGW7347
@MGW7347 9 месяцев назад
Using this for survey data collection. Saved my time. Thank you!
@purpleologist
@purpleologist 2 года назад
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.
@Life_is_very_Beautiful
@Life_is_very_Beautiful 2 года назад
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.
@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.
@runningaway2388
@runningaway2388 Год назад
one of the best youtube videos about maps I've ever watched
@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!
@ronaldodavis9138
@ronaldodavis9138 Год назад
Such a useful tool. Makes me look good at work. Thank you!
@xXboy93Xx
@xXboy93Xx 8 месяцев назад
Exactly what i was looking for!! Really apreciate it, thank u very much!
@DemetriPanici
@DemetriPanici 2 года назад
This is very similar to what Maptser looks like! Loved this
@Rayray17772
@Rayray17772 4 месяца назад
Extremely well done. Thank you!
@AmieFajardoNZ
@AmieFajardoNZ 2 года назад
Very nice tutorial. Thanks for sharing your knowledge to us!
@buildergirl2515
@buildergirl2515 Месяц назад
Thank you. I just mapped out pre-foreclosures from the excel sheet I built from the county records in my area.
@user-vu5bw8cg9o
@user-vu5bw8cg9o Год назад
that is so helpful, i am using it with my thesis, thank you so much!
@basazinewdegu4181
@basazinewdegu4181 Год назад
Thank you very much. God Bless You!
@aspergerhellasbn
@aspergerhellasbn Год назад
This is what i was looking for. Thanks alot for sharing
@matteyman4274
@matteyman4274 2 года назад
This is so great, thank you!
@kdbeadthebeadstylist8641
@kdbeadthebeadstylist8641 2 года назад
So what I needed for mapping bead & craft stores located in the USA...Thanks!
@jadewilson8534
@jadewilson8534 11 месяцев назад
Thank you soooo much for this video it really is so detailed and informative
@lonelymusicboy
@lonelymusicboy 4 месяца назад
Thank you so much for this!
@wenxinhuang8763
@wenxinhuang8763 Год назад
so amazing,thanks for sharing
@killahlmw23
@killahlmw23 Год назад
Thank you! Thank you! Thank you!
@jeaninehaack1459
@jeaninehaack1459 2 года назад
Who knew? This is amazing!!
@thania2266
@thania2266 2 года назад
Thank you 🙏🏽
@ashminishashadara2726
@ashminishashadara2726 Год назад
Superb lesson 👍
@luckybaba8545
@luckybaba8545 Год назад
Thx for this. you fixed one of my big problemes
@kimwenceslaosanchez4449
@kimwenceslaosanchez4449 2 года назад
WOW , SO AMAZING IDEAS
@harshitabhawsar745
@harshitabhawsar745 10 месяцев назад
woww.....thank you for sharing this
@danydesmarais5287
@danydesmarais5287 2 месяца назад
wow thank you so much !!
@sanjeewarmsk
@sanjeewarmsk 2 года назад
Great Stuff thanks
@robbradshaw5534
@robbradshaw5534 2 года назад
Please make an updated video on Google my maps. That would be great great 👍 Helpful videos thank you.
@Tibi4791
@Tibi4791 3 месяца назад
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 3 месяца назад
Thank you for your kind words and the gift. I really appreciate it.
@boldizsarolah3490
@boldizsarolah3490 Год назад
thank you!
@uiagraphics-customprinting975
@uiagraphics-customprinting975 8 месяцев назад
Very well put together. So how do you use it to optimize your driving routes, if possible? Thanks
@Manchitre-Vromon
@Manchitre-Vromon Год назад
Thanks a lot 🇧🇩🌹
@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? 😊
@scottfrost2855
@scottfrost2855 Год назад
Is there any way to have my maps auto-update based on new information added to the workbook? Thank you in advance! Great video!
@sablebenjamin3292
@sablebenjamin3292 Год назад
This a great video. I'm still struggling because I need it only for Europe. Can you make a video for that?
@uexcelinmsoffice4323
@uexcelinmsoffice4323 2 года назад
Nice video
@rogeliobenavides1169
@rogeliobenavides1169 5 месяцев назад
Can you make the best route after you get the location ? Excellent video !
@rochellefennell955
@rochellefennell955 9 месяцев назад
Thanks for the info! Is there a way to switch all markers at once?
@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?
@Disciplinemh
@Disciplinemh Год назад
thanks
@lancesimmons7025
@lancesimmons7025 Год назад
Love it, thank you! Is there any way to do this with Google Earth?
@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?
@siyuchen7339
@siyuchen7339 3 месяца назад
Is there a way to upload multiple layers in bulk at once? Having the ability to toggle on/off layers are useful. THX
@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...... 😀
@sameenakausar1020
@sameenakausar1020 8 месяцев назад
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. 🙂
@Firemission-qw3lj
@Firemission-qw3lj Месяц назад
Do you have a video about excell to timeline format?
@amyfelton-toth4172
@amyfelton-toth4172 2 года назад
Is there a way to export the latitude and longitude that is created by Google Maps?
@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.
@eliemrad7
@eliemrad7 2 года назад
Interesting
@Kruse1
@Kruse1 2 года назад
I wish I had a google map of my warehouse to do a heat map like that.
@d4ng3l
@d4ng3l 6 месяцев назад
Feeling like a hacker!
@nanakwekuoppongasiamah524
@nanakwekuoppongasiamah524 2 месяца назад
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?
@agustinvidalmusic
@agustinvidalmusic Месяц назад
Does the map refresh when the spreadsheet is edited?
@heroone6067
@heroone6067 Год назад
Can i embed it in my own website?
@cesarfelipe
@cesarfelipe Год назад
An now how do i do to see this map in my regular google maps app in my phone?
@ruslangeography104
@ruslangeography104 2 года назад
cool
@lei2827
@lei2827 3 месяца назад
How do i remove those items that fall on the other/no value field?
@moesadr3342
@moesadr3342 Год назад
What would happen if my workbook has more than one worksheet and data's are in tables?
@cynthiaelesevandyke-melcho1864
@cynthiaelesevandyke-melcho1864 2 года назад
💜
@DPC1959
@DPC1959 5 месяцев назад
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.
@felipesanin1808
@felipesanin1808 Год назад
YESSSSSSSSSSSS
@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
@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.
@paultannahill5043
@paultannahill5043 5 месяцев назад
Should be titled: "Convert Excel Data into a Google My Map." Google Maps ≠ Google My Maps
@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
@9990337204
@9990337204 Год назад
How to search on google my maps
Далее
The Excel Format Painter - Basics and Beyond
7:06
Просмотров 47 тыс.
🎙ПЕСНИ ВЖИВУЮ от КВАШЕНОЙ🌇
3:16:26
▼КОРОЛЬ СОЖРАЛ ВСЕХ 👑🍗
29:48
Просмотров 468 тыс.
Google My Maps route planner [step-by-step tutorial]
25:54
I saw my boss do these 10 things in Excel!
7:36
Просмотров 2,6 млн
How to Create a Google Map with Excel Data
5:49
Просмотров 11 тыс.
Use 3D Maps in Excel - Create Beautiful Map Charts
15:23
Import Excel data to Google Maps
3:42
Просмотров 11 тыс.
Microsoft Excel 3D Maps - A Complete Guide
43:59
Просмотров 109 тыс.
This is how I ACTUALLY analyze data using Excel
24:05
WORLD'S SHORTEST WOMAN
0:58
Просмотров 88 млн
Forming of goal foam || A2Z SKLLS
1:00
Просмотров 26 млн
Small Act of Kindness is also a charity
1:00
Просмотров 46 млн