Importing Spreadsheets into Google My Maps

In this video I will show you how to easily import a spreadsheet into your Google My Maps.

There's a lot of different formats that you can use to import your spreadsheet. But I found using a Google Sheet spreadsheet is the best/easiest option.

Google My Maps Tutorial 2021:

Import map features from a file:

Timestamps:
0:00 Introduction
0:20 Google My Maps Tutorial Video
0:41 Import Map Documentation
1:41 How To Format The Spreadsheet
2:57 How To Import Spreadsheet
4:04 Change The Color Of The Markers
4:58 Hide Data
5:27 Open Data Table
6:20 Fix Data Errors
8:12 Testing Map

#googlemymaps #googlesheets #googlemaps

Our Recommended Tools
Some of the links on this page are affiliate links, meaning we may receive a commission if you follow them. This allows us to continue providing free content and educational resources for you. Thank you for supporting our small business!

WORDPRESS PLUGINS:

BUSINESS TOOLS:

GRAPHICS:

WEBSITE HOSTING:

------

[grammargirl]

Thanks! This looks like it is going to save me a lot of time. I appreciate the clear demonstration.

[JulianTol]

Thank you! I'm trying to figure out how to use Google Sheets (or CSV) to import LINES using To / From addresses (or placenames). I can do it directly for driving within countries ('directions') but not for flights. The aim is to have a "Route Lines" layer in my map.

[timvanetten]

Would you think it is possible to automate the updating process from Excel to Google Maps? So when I add a location in Excel that it would automatically add this into Maps aswell?

[nathanbrock]

When I click Import its just a blank white box.. Using google chrome on work computer. It's worked in the past.

[larryzweig]

My my maps "reacts" differently than what you show here. ... and I mean
in many places. I imported from a csv, but the name, add., tel., etc.
information for each point is shown in a sliding panel on the left, and in the csv-text format with everything pushed together with commas, and not in the middle of the map.

[billheckaman]

Wicky Design, the company I work for uses Google My Maps all the time and our sales reps upload all of their prospect accounts, but recently they are having issues when trying to upload. Any troubleshooting you could provide?

[elite]

Is it possible to import multiple sheets into the my maps?

[tinadavidson]

Hi! great video - thank you! quick question - In the future, I'll be adding more locations. Is there an easy way to do that? Can I add them to the original CVS file and if so, will they automatically be incorporated into the map? And then... if the map is updated - will it automatically update on my website or do I need to embed a new code??? So many questions!! Thanks - Tina

[franciscosanchisartes]

Gracias! It works with Google Sheet but it does not work with EXCEL

[jonathancover]

Can I upload data in bulk from a spreadsheet into a data table in google my maps? Not one field at a time. Working with a KMZ file that doesn't have spreadsheet data and looking to add data to the areas highlighted in the KMZ file from a separate spreadsheet. The only way I can see to do it currently is to go cell by cell. Not nice since I have 10 columns and 255 rows...

[jam]

Is there a way to download My Maps to my phone for offline use?

[juliacastro]

I did this and it simply doensn't work lol Google can't find the locations, they ask if Im sure thats the colunm for location

[michaell]

Is it possible to update the data in Google sheets and have it auto populate on my maps. (***without having to re upload that data again***)?

[paolamontesi]

Can I upload custom icons for each place?