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
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
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)
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.