Paste a shared Google Maps list link into the converter above, choose CSV, and download the file. Every place on the list becomes one row.
What the CSV contains
Seven columns, in this order: name, latitude, longitude, notes, list_name, exported_on, location_url. Name is the place name from the list. Latitude and longitude are decimal degrees. Notes holds the note you wrote on that place in the list, when there is one. list_name is the name of this Google Maps list, the same on every row, useful once you merge CSVs from several lists. exported_on is the date you converted the file, not when the place was saved. location_url opens Google Maps at that exact point.
Google Takeout's own export of a saved list gives you names and addresses but no coordinates. The Takeout page explains why.
Steps
- Copy the share link for your list. If someone else made it, the shared list page covers that case.
- Paste it into the box at the top of this page.
- Choose CSV.
- Download the file. The free tier converts up to 25 places per list.
Open it in Excel or Google Sheets
Double-click the file to open it in Excel. In Google Sheets, use File, then Import. Latitude and longitude land in separate columns, so you can sort, filter, or copy them into any tool that takes coordinates.
What the CSV leaves out
There's no address column. GPX, KML and GeoJSON files include the address when Google has one for the place. If you need addresses, pick one of those formats. For a GPS app, GPX is the better pick anyway, and the GPX page covers it.
What people use it for
- Sorting and filtering a long list in a spreadsheet.
- Feeding coordinates into a mapping or routing tool that takes latitude and longitude columns.
- Building Waze links. Waze can't import files, but a link built from two CSV columns opens the app on that spot. The Waze page has the formula.
- Sharing a plain list with someone who has no GPS app.
To see the columns before you convert your own list, download a real CSV from the sample export page.