How to Export Google Maps Saved Places to Excel

You have saved a list of businesses in Google Maps and want to sort or research them in Excel. First decide whether you need the saved-place inventory alone or a prospect list with additional company details.

Export Saved through Google Takeout, open the relevant CSV in Excel, and save it as XLSX. For a business-contact list, import supported places into Prospect, review the details, and export the selected records.

The route table below separates a saved-place inventory from a business-contact spreadsheet.

Choose the right starting point

There are two different jobs here. One is getting your saved place records out of Google. The other is building a useful business list with websites, addresses, and contact details. A file that completes the first job may still need work before it completes the second.

For a list already saved in your Google account, begin with Google Takeout. For a smaller set of places you are reviewing in Chrome, an extension workflow may be more convenient. Either way, keep the original place links so you can return to the source when a name or address looks wrong.

Export a saved list with Google Takeout

Use this route for a saved list in your own Google account:

1. Open Google Takeout while signed in to the account holding the list.
2. Select Saved for the export. Exclude unrelated products if you only need this collection.
3. Choose the destination, frequency, and archive format, then create the export.
4. Download and extract the archive when it is available.
5. Locate the relevant list file and check several names or place links against your saved list.

These steps follow Google's saved-list export instructions. Check the actual files rather than assuming every Maps-related export contains the same records.

For a CSV, use Excel's Data > From Text/CSV import where available. Inspect the delimiter and preview before loading, then save the result as an Excel Workbook (.xlsx). If everything appears in one column, check the delimiter; if characters appear corrupted, check the import encoding. Microsoft explains the options in its text-file import guide. Menu paths vary across Excel versions.

A GeoJSON file needs a compatible conversion or import route; renaming it to CSV or XLSX will not convert it. A CSV containing names and place links is already useful as a saved-list inventory, even when it lacks business contact fields.

Build a business spreadsheet with Prospect

Prospect — Sales Bookmarks supports importing loaded Maps lists or search results and exporting selected, filtered, or all prospects to Excel. For file imports, its listing describes support for Saved CSV and Maps GeoJSON exports in batches of up to 100.

For a loaded Maps list in version 1.3.0:

1. Open the list or search results in a Chrome tab and wait for the places to load.
2. In Prospect, open Saved prospects, then Import Google Maps.
3. Choose the Open Google Maps tab and click Read tab. Use Refresh tabs if you opened Maps after the dialog.
4. Review the preview and select up to 100 places, then click Import selected places.
5. Review the saved rows. Check the boxes beside the records you want and click Export selected. Export filtered exports the current filtered view; Export Excel exports the whole collection.

Start with a small list whose contents you recognize. Keep Maps open during a saved-list-card import. Review the captured company names, websites, addresses, and phone numbers before exporting. If you need an email address, check whether one was found on the company's public website; a blank field is a review task, not evidence that the import failed.

Saving a prospect and exporting a workbook are separate actions. Review the organizer first, then use the export controls when the collection is ready.

Reconcile the places before using the list

Suppose your saved list contains 36 places but the workbook has 24 rows. Do not immediately repeat the entire import. First check whether only part of the list was loaded, whether the organizer has an active filter, or whether you exported a selection.

Compare several recognizable entries from different parts of the list. Then record the missing place names and resolve those individually or through a fuller export route. This gives you a specific discrepancy to investigate instead of a second collection that may overlap the first.

Also distinguish companies from locations. Three stores with one shared website may represent three valid sales targets. A company-level spreadsheet might combine them; a territory list usually should not.

Add the fields that make the export useful

After exporting, add columns for qualification, source checked date, owner, and next action. These are your working fields, not facts that Maps supplies. Keep them beside a stable record ID so later corrections do not become detached from the right business.

For example, a fictional equipment dealer might have a complete address and phone number but no evidence that it serves commercial customers. Mark it Needs research rather than Ready. A tidy row and a qualified prospect are different outcomes.

Begin with one list, reconcile it, and save a dated copy. Once that process works, repeat it for the next territory or business category.

Related Questions

Does a Google Maps export include business email addresses?

Do not assume it does. Inspect the fields in your actual export. Public email research usually requires visiting the company website, and some businesses provide only a phone number or contact form.

Why did only part of my list import?

A live-tab workflow may read only currently loaded places. Check loading, organizer filters, and export selection before retrying. For a larger owned list, compare against its Takeout export.

If records are missing, use the missing-places checklist. For a downloaded archive, follow the Takeout-to-prospects workflow.