MyMaps is part of Google Maps. You can import spreadsheets into MyMaps in order to plot your own locations. In this example, I have an excel spreadsheet of six sites, with latitude and longitude coordinates.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_001.png)
Firstly, go to the Google MyMaps webpage www.google.com/maps/d/ you will need a Gmail Account to do this. Click on CREATE A NEW MAP.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_002-1024x547.png)
This will open a blank map. To get your own data into the map, click on Import.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_003-1024x614.png)
Then import the excel spreadsheet with your data in it.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_004-1024x530.png)
MyMaps is smart enough to figure out the columns with the headings Latitude and Longitude and the latitude and longitude coordinates. Click on Continue.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_005-1024x653.png)
Choose the column heading that has the names for your locations. In this example, the column is called Campaign. Click on Finish.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_006-1024x627.png)
To change the name of the map, click on Untitled map.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_007-1024x669.png)
Then type in the map title that you want and click Save.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_008-1024x691.png)
You can change the color of the markers inidividually by clicking on the paint can.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_009-1024x658.png)
You can also change the style of all the markers as once by clicking on the paint roller and choosing one of the other options.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_010-997x1024.png)
You can also add labels to the markers using one of the columns in your spreadsheet.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_011-952x1024.png)
To change the appearance of the markers, click on the paint can, and choose More Icons.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_012-840x1024.png)
Then choose one of the available icons, or select Custom icon.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_013-1024x746.png)
Then select an image file to use as your custom icon.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_014-1024x529.png)
In this example, the markers have been changed to green pins.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_015-1024x470.png)
Next, I added in another layer using a different excel spreadsheet.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_016-1024x644.png)
For this layer, I also changed the icons. This time I selected See older icons.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_017-1024x750.png)
Then I selected the circle shape.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_018-1024x780.png)
This changes all the markers for the second layer to circles.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_019-1024x714.png)
To change the map, click on Base map and then select one of the nine different map types available. Next, click on Preview to see the map on its own without the options box or the search bar.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_020-1024x758.png)
In the preview window, select Collapse map legend to remove the left hand pane. Dismiss the warning message. Then take a screenshot and crop it to get the map as an image that you can use later.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_021-1024x411.png)
This is what the final map looks like.
![](https://keatraining.com/wp-content/uploads/2023/12/028_google_mymaps_022-1024x681.png)