Convert Excel Data into a Google Map

Поделиться
HTML-код
  • Опубликовано: 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.

  • @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 23 дня назад

    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 года назад

    💜