A Google Maps list often starts with a few holiday ideas and somehow ends up containing hundreds of restaurants, hotels, shops, and places you can no longer remember saving. At that point, viewing everything as pins is not always enough. Sometimes you just want a spreadsheet.
Google Maps does not have an Export to CSV button for Starred Places, Want to go, or custom lists. Google Takeout can download an account archive, but its files are intended as raw backup data rather than a table you can open and start sorting.
Export the list in five steps
- Install ExportMyMap in Chrome or another Chromium-based desktop browser.
- Open Google Maps and sign in to the account that owns the saved places.
- Open ExportMyMap and choose Starred Places, Want to go, or one of your custom lists.
- Review the detected places and deselect anything you do not need.
- Click CSV and save the file.
The free version covers the first 10 places, which is enough to check that the columns and data look right. To export every place detected in the list, you will need one of the paid plans.
What actually appears in the file?
Each place gets its own row. The available columns depend on the information Google has for that location, but you may see:
- Place name and full address
- District, city, postal code, state, region, and country
- Latitude, longitude, and Plus Code
- Phone numbers, email addresses, website, and domain
- Rating, review count, and category
- Opening hours and permanently closed status
- Google Place ID and Google Maps URL
- Image URL and saved or updated dates
- Your list note, when available
Do not be surprised by the occasional empty cell. A viewpoint can have coordinates but no phone number; a small business might not publish an email address. In most cases, a blank simply means Google did not provide that particular detail.
Opening the CSV in a spreadsheet
A CSV is just a text-based table, which is why almost every spreadsheet and database application can read it.
- Google Sheets: create a sheet, choose File → Import → Upload, then select the CSV.
- Microsoft Excel: open the CSV directly. If Excel asks about encoding or delimiters, choose UTF-8 and comma-separated values.
- Apple Numbers: drag the CSV onto Numbers or choose File → Open.
The export uses UTF-8, so accents and non-Latin place names should remain intact. One common Excel annoyance is regional delimiter settings: if the file opens in a single column, use Excel's data-import screen and select comma as the delimiter.
CSV or XLSX?
Use CSV if the next step is an import into a CRM, database, mapping service, script, or no-code tool. Use XLSX if you plan to work on the list manually in Excel or Numbers. The underlying place data is structured in either case; the difference is mostly about what you intend to do next.
What if Starred Places has more than 200 entries?
Google Maps on desktop may expose only about 200 Starred Places even when the account contains more. If ExportMyMap spots that situation, it shows a warning rather than passing off a partial list as a complete backup.
When completeness matters, follow the Google Takeout method for more than 200 Starred Places first. For lists that Maps exposes in full, the extension is the much shorter route.
Does the export upload my list?
The CSV is generated in your browser; the spreadsheet does not have to be uploaded somewhere else to be created. Still, the finished file can contain home addresses, client locations, or personal notes, so store and share it with the same care as an address book.
Once the list is in a spreadsheet, it is yours to work with: sort it by city, remove duplicates, add your own columns, import it elsewhere, or simply keep a backup that does not depend on the Google Maps interface.
