Skip to content

2. Create Your Map

Playback Speed:

In this video, you will create an interactive map of your area in Google My Maps.

To do this, you will import the data from your area guide spreadsheet.

Go to the map you created in the last video.

Click “import.”

Find your area guide in Google Drive.

If you can’t find it, search for all or part of the title of your spreadsheet.

Import the sheet.

If you get an error message when you try to import the spreadsheet, you may need to shorten your column headings.

If the column headings are too long or contain special characters the spreadsheet will not upload into My Maps.

Change the headings in your area guide if you need to.

Now the spreadsheet should import to Google My Maps correctly.

Now, choose the column with “Addresses.”

Google My Maps will use the data in this column to create location points on the map.

Then, choose the column with “Location Names.”

This tells the map what to call the location points it adds.

If you are not sure which columns contain the addresses and location names, click the question mark next to the column name.

The help text shows the items from that column.

Click “finish.”

The locations in your area guide show up as points on the map!

Click on a few of the location markers.

Information about each location appears as you click!

Don’t worry if your map doesn’t look exactly like what you see in this video.

Applications change often.

In the next video, you will learn about more “My Maps” features you can use to customize your map.

Now, it’s your turn: Import your area guide into your map.

Select the address column to position placemarks.

Then, select the location names column to title the markers.

Import the sheet, then click the points on the map to see more information.

Finally, click the next arrow to move on to the next video.


  1. Import your Area Guide into your map.
  2. Check off the address column.
  3. Check off the location names column.
  4. Import the sheet, then click the points on the map to see more information.
  5. Share your map with your partner.
  • "Happy Alley by Kevin MacLeod" by ( -- Licensed under Creative Commons: By Attribution 3.0 License (