How to Create a Google Map with Excel Data

[@valjosol12]

Very easy to follow! THANK YOU! I've been trying to do this for months!!

[@exceldemy2006]

Hello @valjosol12, You are most welcome. Glad to hear that our tutorial helped you to solve you problem. Our aim is to make the Excel easy to use. Keep learning Excel with ExcelDemy! Regards ExcelDemy

[@sbolt6]

Excellent step by step instructions. Thank you!

[@exceldemy2006]

Hello @sbolt6, You are most welcome. Thanks for your appreciation, it means a lot to us. Keep learning Excel with ExcelDemy. Regards ExcelDemy

[@sachinbandari8225]

Thank you for info. It helped me a lot in my line of work. easy to trace many locations in map. very helpful

[@exceldemy2006]

Hello @sachinbandari8225, We are glad to hear that our video helped you in your work. Thanks for your appreciation. Please stay connected with us. Regards ExcelDemy

[@golnaz.shoush]

Hi dear thank u v much , I’m in fact looking for an area to be colored by google map using spread sheet, is there any way to that ? (In fact polygon instead of marker)

[@exceldemy2006]

Dear, thanks for your exciting comment. Google My Maps does not allow us to create a direct polygon by importing data from spreadsheets. However, you can try using a manual approach. As mentioned in the article for Excel worksheet, import your Spread Sheet data into Google My Maps. Later, create a new layer on the map. In this new layer, manually draw polygons to represent the areas you want to color. Select the "Draw a line" tool in Google My Maps to do this. Once you have drawn the polygons, customize their appearance, including the fill color.

[@Johnyjohny560-r3i]

But if we want to change location of person, how will we do?

[@exceldemy2006]

Hello @Sohailabbasi93, To change a person’s location on a Google Map created with Excel data: You can follow these 3 ways: You can upload the updated Excel file. 1. Edit the Excel File: Open the Excel file containing the data. Find the row with the person’s information and update their address or coordinates. Save the changes. Update Google My Maps: 2. Open Google My Maps and go to your map. Click on the "Add layer" button, then select "Import" to upload the updated Excel file. Follow the prompts to import and replace the old data. Manual Adjust the Map Open your map in Google My Maps >> Click the marker you want to move >> Drag it to the new location. Regards ExcelDemy

[@ΛαμπροςΛαμπρος-λ6σ]

Hello do upu know how to download google maps on garmin gps astro 320 Thank you

[@exceldemy2006]

Hello @ΛαμπροςΛαμπρος-λ6σ, To download Google Maps to a Garmin GPS Astro 320, you would typically need to use a program like Garmin BaseCamp to import Google Maps data. First, save the Google Maps data as a compatible file (such as KML or GPX), then upload it to BaseCamp. From there, transfer the data to your Garmin device. You may need to ensure that the map data is compatible with Garmin devices. You can find detailed instructions in the Garmin user manual or related resources. Regards ExcelDemy

[@ΛαμπροςΛαμπρος-λ6σ]

@exceldemy2006 Thank you for your answer I have seen in Google maps an option (maps offline)And you can download it to SDK card.If I downolad and add it to my Garmin's what do you think it will play?Can you please make a video with the steps if it's possible?Thank you very much you are a life saver!!

[@ΛαμπροςΛαμπρος-λ6σ]

I want Google maps because it shows better the trees lakes etc Garmin have also but they are not so good

[@exceldemy2006]

Hello @ΛαμπροςΛαμπρος-λ6σ, It’s unlikely that directly downloading offline Google Maps and placing them on a Garmin Astro 320 will work, as Garmin devices use their own map format (.IMG) rather than standard Google Maps files. However, you can create custom maps using Garmin BaseCamp or convert Google Maps data to Garmin-compatible formats (like KML to GPX) and then load them onto your SD card. Regards ExcelDemy

[@ΛαμπροςΛαμπρος-λ6σ]

@exceldemy2006 Thank you very much for your answer I am interested only for Google maps can you please tell me the steps how to download and then convert the maps to this form Thank you

[@Johnyjohny560-r3i]

Good info.

[@exceldemy2006]

Thanks for your appreciation. Stay connected with us.

[@apocalypsematrix9252]

👍🏻