How to Export Google Maps Saved Places to Excel or Google Sheets

A map is good at answering where is it? A spreadsheet is better at answering the questions that arrive five minutes later: How many places are in France? Which restaurants have no website? Are there duplicates? Which saved venues have more than 1,000 reviews?

Google Maps does not give you that table. ExportMyMap does: one row per saved place, with the useful place details split into proper columns. You can download a native Excel workbook and work in Excel, or import the same XLSX file into Google Sheets for collaboration.

XLSX or CSV: pick based on the next step

Both formats carry rows and columns, but they are not equally convenient.

Choose Excel (XLSX) when you want to:

• open the list directly in Excel, Google Sheets, Numbers, or LibreOffice;
• keep a bold header row and sensible column widths;
• preserve latitude, longitude, ratings, and review counts as numeric cells;
• name the worksheet after your Google Maps list;
• edit and share the workbook with people.

Choose CSV when you want to:

• import the places into a CRM, database, no-code tool, or another map service;
• process the file in a script;
• use the simplest possible tabular format.

The dedicated CSV export guide covers separators, UTF-8, and import-oriented use cases. For this workflow, choose XLSX.

Step 1: Turn the Maps list into a workbook

Open Google Maps in Chrome, Edge, Brave, or Arc on a computer.

1. Install the ExportMyMap Chrome Extension.
2. Open Google Maps, click Saved, and choose the list.
3. Launch the extension and wait for the scan to finish.
4. Select Excel (XLSX).
5. Include your personal notes if they belong in the spreadsheet.
6. Download the file.

The free version covers the first 10 places; a paid plan is required for the full list. For a Starred list that stops at about 200 places on desktop, use the Google Takeout workflow before exporting.

What is in the workbook?

Each place gets one row. The workbook can contain roughly two dozen fields, including:

• name and full address;
• district, city, state, region, postal code, and country;
• latitude, longitude, and Plus Code;
• phone numbers and email addresses when available;
• website and website domain;
• rating and review count;
• place category and opening hours;
• Google Place ID and Google Maps URL;
• image URL and saved/updated dates;
• your note, if you chose to include it.

Not every Google place card has every field. A blank phone cell does not mean the export broke; the business may not publish a number, or Google may not return one for that entry. Coordinates, names, and addresses are the fields to check first because most later work depends on them.

The sheet name follows your Google Maps list name, with characters Excel forbids replaced and names longer than 31 characters shortened. The top row is frozen, so the column labels stay visible while you scroll.

Open it in Microsoft Excel

Double-click the downloaded XLSX. The workbook is ready to use, but two small changes make a long list much easier to handle.

First, click anywhere in the data and turn the range into a table with Insert → Table. Confirm that the table has headers. This adds a filter button to every column and keeps row styling readable.

Then use the filters for a real question rather than scrolling:

• country = Italy and category contains restaurant;
• rating is greater than or equal to 4.5;
• website is blank for a business research list;
• city = Berlin for the part of a trip you are planning now.

For a simple duplicate check, select the name and full-address columns and use Data → Remove Duplicates on a copy of the worksheet. Keep the untouched export in another tab so an enthusiastic cleanup does not become permanent data loss.

Import the same file into Google Sheets

Google Sheets understands XLSX; you do not need to convert it to CSV first.

1. Open a new or existing Google Sheet.
2. Choose File → Import.
3. Upload the XLSX file.
4. Choose Create new spreadsheet or Insert new sheet(s).
5. Click Import data.

Google's own Sheets help notes that importing does not change the original Excel file. You can also upload the XLSX to Drive and choose Open with Google Sheets, which is convenient when you want to keep editing the Office file in place.

Once imported, choose Data → Create a filter. If several people will use different filters at the same time, create filter views instead; otherwise one person's “only Lisbon cafes” view can temporarily confuse everyone else.

Three useful things to do before sharing it

1. Add a decision column

Create a new first column called Status with values such as Keep, Maybe, Booked, Visited, or Remove. The export tells you what Google knows; this column records what your group has decided.

2. Keep the Google Maps URL

Do not delete the URL column just because the address is present. It gives every collaborator a quick way back to the live place card for recent reviews, photos, transit directions, and current opening hours.

3. Treat opening hours as a snapshot

Opening hours in the workbook reflect what was returned during export. They are useful for rough planning, not for deciding whether to cross a city at 10:55 p.m. Check the live listing before making the trip.

When a spreadsheet is the wrong destination

Excel and Sheets are excellent for filtering and editing, but they are not the best way to hand someone a pleasant map. If the audience only needs to browse the places, a shareable map link or PDF is less work for them.

And if another map app is the destination, use a geographic file instead of rebuilding coordinates from spreadsheet columns. KML suits Google Earth and Organic Maps; GPX waypoints suit OsmAnd and many GPS apps.

Use the spreadsheet when the rows themselves are the point: cleaning a customer list, planning by city, checking coverage, assigning research, or turning a pile of saved pins into decisions.

Export a Google Maps list to Excel →