Back to all posts

How to Get a Google Maps List into Google Sheets

Want a Google Maps list in Google Sheets — to sort, plan a trip, or share with friends? Here's how to turn your saved places or a shared list into a Sheet with addresses and coordinates.

May 31, 2026

•

4 min read

Google Sheets is where a lot of planning actually happens. You're mapping out a trip, splitting a list of venues with friends, or building a shared database of places — and you want your Google Maps list in the sheet, not trapped behind a row of pins you have to click one by one.

Google Maps has no "send to Sheets" button, but getting there is quick. This guide shows how to turn your saved places — or a list someone shared with you — into a Google Sheet with names, addresses, and coordinates, ready to sort, filter, and share.

The Short Version

Google Sheets opens both Excel (.xlsx) and CSV files, so the path is: export your places from Takeout Tools, then open or import.

  1. Open Takeout Tools and add your places — paste a shared Google Maps list link (a maps.app.goo.gl/... URL), or upload a Google Takeout export of your own saved places.
  2. Review the table — name, address, latitude, longitude, and notes — and trim it to what you want.
  3. Export to Excel (.xlsx) or CSV — both import into Sheets cleanly.
  4. In Google Sheets: open an .xlsx with File → Open, or import a CSV with File → Import → Upload ("Insert new sheet").

Your places land in tidy columns. For the full picture, see Google Maps to Google Sheets.

Importing the CSV into Google Sheets

Once you have the CSV:

  1. Open a new or existing Google Sheet.
  2. File → Import.
  3. Switch to the Upload tab and drop in the CSV.
  4. Under "Import location," choose where it goes; leave the separator on "Detect automatically."
  5. Click Import data.

Your places appear with a column each for name, address, latitude, and longitude (plus notes, if the list had them).

What You Can Do Once It's in Sheets

This is where the spreadsheet earns its keep:

  • Sort and filter — order by neighborhood, filter to places with notes, group by category
  • Share and collaborate — send the Sheet to travel companions or your team; everyone edits the same list
  • Add columns — a "visited?" checkbox, a priority rating, who recommended each spot
  • Plot it back on a map — paste the latitude/longitude into Google My Maps, or use a Sheets mapping add-on, to see your filtered list on a map

A Note on Coordinates

Each place comes through with real latitude and longitude — not just a name. That matters in Sheets: with coordinates you can map the list, calculate rough distances, or hand it to any other tool cleanly. If coordinates are the only thing you need, see how to get coordinates from a shared Google Maps list.

Frequently Asked Questions

Related

How to Get a Google Maps List into Google Sheets | Takeout Tools