Kick off the new school year with lessons from our Back to School 2022 collection to help students express themselves, build relationships, and stay organized.

2. Import Your Spreadsheet Data into 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.

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.


  1. Import your area guide into your map.
  2. Select the address column to position placemarks.
  3. Select the location names column to title the markers.
  4. Click the points on the map to see more information.
  • "Happy Alley by Kevin MacLeod" by ( -- Licensed under Creative Commons: By Attribution 3.0 License (