Create a Custom Google Map with Pins from Excel Address List | Drop Multiple Pins on Google Maps

Поділитися
Вставка
  • Опубліковано 3 сер 2024
  • In this video, I have thoroughly explained how to create location pins on Google Maps using the data from an Excel file.
    You can have hundreds of addresses in the files with some other columns and the address column. Then, on Google mymaps, upload the Excel file.
    It will create the location pins for all the addresses within a few seconds. Initially, you will see the location pins in Blue with the default location pin icon. But you will have complete freedom to update the styles of the location pins. It has a vast library of icons for the pins and a few colors. You can change the different icons and different colors for the different pins.
    Also, you can upload images for the locations where you have created the pins.
    According to my view, this is the best Google Maps location pin feature.
    When the pinning is done, you can share the custom map with other people using their email or copy the link and share it with others.
    It gives you an option to make the custom map publicly available.
    Another nice feature Google Maps offers here is you can embed the custom map with all the custom pins on your website. It provides an iframe embed code; copy the code and paste it where you want to display it.
    Other videos I have talked about in the video:
    1. Get the latitude & longitude of Bulk addresses at once: • How to Convert Address...
    2. Draw radius circle on Google Maps: • How to Draw a Radius M...
    Timestamps:
    0:00 Intro
    0:19 Log on to Google My Maps
    0:33 Import the Excel file with the address
    0:45 Select the column with the address
    1:02 Select a column for the pin titles
    1:44 Change the color & icon of the pins
    3:00 Add/Edit/Delete location pins
    3:32 Change the map style
    3:43 Share the custom map
    4:05 Add images to the location pins
    4:22 Embed the map on the website
    Subscribe to the channel:
    / @technologiate
    Follow and engage on social media:
    Facebook: / technologiate
    Instagram: / technologiate
    #googlemaps #custommaps #pins #locationpins
  • Наука та технологія

КОМЕНТАРІ • 14

  • @technologiate
    @technologiate  6 місяців тому +1

    *How to Draw Raius Circle on Google Maps:* ua-cam.com/video/uRTkpTHmBRo/v-deo.html

  • @mohadesehkh8762
    @mohadesehkh8762 3 години тому

    perfect👌

  • @MikePeaceWoodturning
    @MikePeaceWoodturning 4 місяці тому +2

    Awesome, thanks for sharing!

  • @talkto123
    @talkto123 4 місяці тому +1

    Genius

  • @cmqta
    @cmqta 4 місяці тому

    Nice video. Question: how do I make each placemark to show the info of All the Columns in the Excel table? I remember I could do that in the past but I can't find a way now. Thank you.

    • @technologiate
      @technologiate  4 місяці тому +1

      Do you have other columns along with the Address column?

    • @cmqta
      @cmqta 4 місяці тому

      Yes, Sir. Let's say, I have 6 Columns: Site, Name, City, State, Latitude, Longitude. When I first started using Google Maps, I knew how to have each placemark showing those 6 info right next to it (to the right of the placemark). Now I can't do it. I need to make a map for my job and this is stressing me out! Thank you!!!@@technologiate

    • @technologiate
      @technologiate  4 місяці тому +1

      Hi@@cmqta ,
      Could you please send me the Excel file with the columns? Also, mention which info you want to display on the pins.
      Thank you.

    • @cmqta
      @cmqta 3 місяці тому

      @@technologiate Where should I send you the info? Email? Thank you.

    • @cmqta
      @cmqta 3 місяці тому

      @@technologiate Hi! My apologies, I thought I replied to your message. Where can I send you the info? Email? Thank you.

  • @huzaifasy6555
    @huzaifasy6555 2 місяці тому

    How I can make update for the files please ?

    • @technologiate
      @technologiate  2 місяці тому

      Hi, did you mean how to update the locations? See at 03:00

  • @dirkzin7188
    @dirkzin7188 4 місяці тому

    🏃 'promo sm'