Convert Excel Data into a Google Map

แชร์
ฝัง
  • เผยแพร่เมื่อ 28 พ.ย. 2024

ความคิดเห็น • 79

  • @CharlesWorth-d1c
    @CharlesWorth-d1c 11 หลายเดือนก่อน +4

    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.

  • @runningaway2388
    @runningaway2388 2 ปีที่แล้ว +2

    one of the best youtube videos about maps I've ever watched

  • @purpleologist
    @purpleologist 3 ปีที่แล้ว +4

    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.

  • @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!

  • @DemetriPanici
    @DemetriPanici 3 ปีที่แล้ว +4

    This is very similar to what Maptser looks like! Loved this

  • @Life_is_very_Beautiful
    @Life_is_very_Beautiful 3 ปีที่แล้ว +1

    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 ปีที่แล้ว +3

    This is a game changer. Thank you so much for the clear explanation!!

  • @saroshhavewala1489
    @saroshhavewala1489 2 ปีที่แล้ว +5

    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?

  • @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

  • @FortunaFound
    @FortunaFound ปีที่แล้ว +1

    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.

  • @nyasawide-tv2838
    @nyasawide-tv2838 หลายเดือนก่อน

    Thanks is my favorite video that soon will change my life_ my first health project will originate from this video

  • @rochellefennell955
    @rochellefennell955 ปีที่แล้ว

    Thanks for the info! Is there a way to switch all markers at once?

  • @scottfrost2855
    @scottfrost2855 2 ปีที่แล้ว +1

    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 7 หลายเดือนก่อน

    Is there a way to upload multiple layers in bulk at once? Having the ability to toggle on/off layers are useful. THX

  • @Firemission-qw3lj
    @Firemission-qw3lj 5 หลายเดือนก่อน

    Do you have a video about excell to timeline format?

  • @Rayray17772
    @Rayray17772 8 หลายเดือนก่อน

    Extremely well done. Thank you!

  • @JB-fh9rb
    @JB-fh9rb 3 หลายเดือนก่อน

    Really Cool! Very helpful!! I needed a way to reflect over 500 service locations for my organization excellent solution!

  • @MaiAlHussain-s4d
    @MaiAlHussain-s4d ปีที่แล้ว

    that is so helpful, i am using it with my thesis, thank you so much!

  • @rogeliobenavides1169
    @rogeliobenavides1169 9 หลายเดือนก่อน

    Can you make the best route after you get the location ? Excellent video !

  • @buildergirl2515
    @buildergirl2515 5 หลายเดือนก่อน

    Thank you. I just mapped out pre-foreclosures from the excel sheet I built from the county records in my area.

  • @lancesimmons7025
    @lancesimmons7025 ปีที่แล้ว

    Love it, thank you! Is there any way to do this with Google Earth?

  • @agustinvidal99
    @agustinvidal99 5 หลายเดือนก่อน

    Does the map refresh when the spreadsheet is edited?

  • @aspergerhellasbn
    @aspergerhellasbn ปีที่แล้ว

    This is what i was looking for. Thanks alot for sharing

  • @ronaldodavis9138
    @ronaldodavis9138 ปีที่แล้ว

    Such a useful tool. Makes me look good at work. Thank you!

  • @xXboy93Xx
    @xXboy93Xx ปีที่แล้ว

    Exactly what i was looking for!!
    Really apreciate it, thank u very much!

  • @Tibi4791
    @Tibi4791 6 หลายเดือนก่อน

    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  6 หลายเดือนก่อน

      Thank you for your kind words and the gift. I really appreciate it.

  • @Manchitre-Vromon
    @Manchitre-Vromon ปีที่แล้ว +1

    Thanks a lot 🇧🇩🌹

  • @jeaninehaack1459
    @jeaninehaack1459 3 ปีที่แล้ว

    Who knew? This is amazing!!

  • @heroone6067
    @heroone6067 ปีที่แล้ว +1

    Can i embed it in my own website?

  • @csher6734
    @csher6734 3 หลายเดือนก่อน

    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?

  • @amyfelton-toth4172
    @amyfelton-toth4172 3 ปีที่แล้ว +1

    Is there a way to export the latitude and longitude that is created by Google Maps?

  • @lonelymusicboy
    @lonelymusicboy 8 หลายเดือนก่อน

    Thank you so much for this!

  • @kdbeadthebeadstylist8641
    @kdbeadthebeadstylist8641 3 ปีที่แล้ว

    So what I needed for mapping bead & craft stores located in the USA...Thanks!

  • @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?

  • @jadewilson8534
    @jadewilson8534 ปีที่แล้ว

    Thank you soooo much for this video it really is so detailed and informative

  • @luckybaba8545
    @luckybaba8545 2 ปีที่แล้ว

    Thx for this. you fixed one of my big problemes

  • @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?

  • @basazinewdegu4181
    @basazinewdegu4181 2 ปีที่แล้ว

    Thank you very much. God Bless You!

  • @killahlmw23
    @killahlmw23 ปีที่แล้ว

    Thank you! Thank you! Thank you!

  • @harshitabhawsar745
    @harshitabhawsar745 ปีที่แล้ว

    woww.....thank you for sharing this

  • @lei2827
    @lei2827 7 หลายเดือนก่อน

    How do i remove those items that fall on the other/no value field?

  • @robbradshaw5534
    @robbradshaw5534 2 ปีที่แล้ว

    Please make an updated video on Google my maps. That would be great great 👍 Helpful videos thank 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...... 😀

  • @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. 🙂

  • @wenxinhuang8763
    @wenxinhuang8763 ปีที่แล้ว

    so amazing,thanks for sharing

  • @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.

  • @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? 😊

  • @MartinTodoroski-m2y
    @MartinTodoroski-m2y 2 หลายเดือนก่อน

    Thanks alot!

  • @cesarfelipe
    @cesarfelipe 2 ปีที่แล้ว

    An now how do i do to see this map in my regular google maps app in my phone?

  • @AmieFajardoNZ
    @AmieFajardoNZ 3 ปีที่แล้ว

    Very nice tutorial. Thanks for sharing your knowledge to us!

  • @ashminishashadara2726
    @ashminishashadara2726 2 ปีที่แล้ว

    Superb lesson 👍

  • @kimwenceslaosanchez4449
    @kimwenceslaosanchez4449 3 ปีที่แล้ว

    WOW , SO AMAZING IDEAS

  • @matteyman4274
    @matteyman4274 3 ปีที่แล้ว

    This is so great, thank you!

  • @boldizsarolah3490
    @boldizsarolah3490 ปีที่แล้ว

    thank you!

  • @NaturalplacesofCeylon
    @NaturalplacesofCeylon 22 วันที่ผ่านมา

    how can we reimport data, without changing existing data? I was trying the reimport option. new data was added but all formats restored

    • @niyaapooh1348
      @niyaapooh1348 7 วันที่ผ่านมา

      I had same issue but thomethics helped me it can be so frustrated but thomethics will fix it for you he is a verified Meta agent

  • @Disciplinemh
    @Disciplinemh ปีที่แล้ว

    thanks

  • @DPC1959
    @DPC1959 9 หลายเดือนก่อน

    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.

  • @moesadr3342
    @moesadr3342 2 ปีที่แล้ว

    What would happen if my workbook has more than one worksheet and data's are in tables?

  • @sanjeewarmsk
    @sanjeewarmsk 2 ปีที่แล้ว

    Great Stuff thanks

  • @thania2266
    @thania2266 3 ปีที่แล้ว

    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.

  • @uexcelinmsoffice4323
    @uexcelinmsoffice4323 3 ปีที่แล้ว

    Nice video

  • @d4ng3l
    @d4ng3l 10 หลายเดือนก่อน

    Feeling like a hacker!

  • @Kruse1
    @Kruse1 3 ปีที่แล้ว

    I wish I had a google map of my warehouse to do a heat map like that.

  • @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 ปีที่แล้ว +1

      @@tamaraclarke2812 what did you do wrong because mine isn't working either

  • @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 9 หลายเดือนก่อน +1

    Should be titled: "Convert Excel Data into a Google My Map." Google Maps ≠ Google My Maps

  • @9990337204
    @9990337204 ปีที่แล้ว

    How to search on google my maps

  • @eliemrad7
    @eliemrad7 3 ปีที่แล้ว

    Interesting

  • @ruslangeography104
    @ruslangeography104 3 ปีที่แล้ว

    cool

  • @felipesanin1808
    @felipesanin1808 ปีที่แล้ว

    YESSSSSSSSSSSS

  • @cynthiaelesevandyke-melcho1864
    @cynthiaelesevandyke-melcho1864 3 ปีที่แล้ว

    💜