Back to all posts

Export Google Maps Saved Places to Google Sheets

Get your Google Maps saved places — or a list someone shared with you — into Google Sheets, with names, addresses, and coordinates.

Google Sheets is where a lot of planning actually happens — trip itineraries, shared venue lists, a database of places. But Google Maps has no “send to Sheets” button, so your list stays trapped behind a column of pins. Here's how to get it into a Sheet in a couple of steps, coordinates included.

How to Get Google Maps Into Google Sheets (3 Steps)

  1. Add your places to Takeout Tools — Paste a shared Google Maps list link (a maps.app.goo.gl link), or upload a Google Takeout export, into Takeout Tools.
  2. Export the file — Download as Excel (.xlsx) or CSV. Either imports into Sheets cleanly, with name, address, latitude, longitude, and notes.
  3. Open in Google Sheets — For .xlsx, use File → Open. For CSV, use File → Import → Upload and choose “Insert new sheet”. Your places land in tidy, sortable columns.

Google Maps to a Google Sheet

Names, addresses, and coordinates — ready to import

Try Takeout Tools →

Importing the File into Google Sheets

  • Excel (.xlsx) — In Sheets, File → Open and pick the file; it converts to a Sheet automatically, hyperlinks and all.
  • CSV — File → Import → Upload, choose the CSV, leave the separator on “Detect automatically”, and click Import data.

What You Can Do Once It's in Sheets

  • Sort & filter — Order by area, filter to places with notes, group by category
  • Share & 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
  • Map it back — The latitude/longitude columns drop straight into Google My Maps or a Sheets mapping add-on

Frequently Asked Questions

Can I send a Google Maps list straight to Google Sheets?

There's no one-click "send to Sheets" inside Google Maps. The reliable path is to get your places as a file from Takeout Tools — an Excel (.xlsx) or CSV — then open or import it in Sheets. Both take seconds.

How do I import the file into Google Sheets?

For an .xlsx, just File → Open in Google Sheets. For a CSV, use File → Import → Upload, select the file, and choose "Insert new sheet" or "Replace current sheet". Sheets detects the columns automatically.

Does the sheet include coordinates?

Yes — latitude and longitude come through as their own columns, alongside the name, address, and (for shared lists) the author's notes. That means you can map, sort, or analyze the list right away.

Can I do this with a list someone shared with me?

Yes. Paste a public Google Maps list link (a maps.app.goo.gl link) into Takeout Tools, export, and import into Sheets — even for a list you don't own. See our guide on extracting a shared list.

Can I turn the Sheet back into a map?

Yes. Google My Maps can import a Sheet or CSV and place each row on a map using the address or coordinates — handy for visualizing a filtered version of your list.

Learn More

Export Google Maps Saved Places to Google Sheets | Takeout Tools