Extract Data from Google Maps to Excel: Practical Options

How-to basics · Updated November 19, 2026

You can move location data into Excel, but Google Maps does not provide a general-purpose button to export every search result as a spreadsheet. For a small list, record the places you are entitled to use and save them as a CSV; for larger or repeatable projects, use an authorized data source such as the Google Maps Platform Places API, then transform its output for Excel while following Google’s current terms.

What Google Maps Can Export

Google Maps is designed to help people find and navigate to places, not to download its entire database of businesses or search results. A normal search such as coffee shops near an address has no built-in command that exports all displayed names, phone numbers, ratings, and coordinates to an Excel workbook. The map may show only a subset of results, and the places shown can change with the map area, query, and ranking.

There are several different kinds of data people mean when they ask about a Google Maps export:

  • Places you saved: Your own saved places and lists may be available through Google Takeout, depending on the data and export options offered for your account. The download may use a location-data format such as KML rather than a ready-to-use Excel table.
  • Places you manage: Business owners can access information about their own business through Google Business Profile tools and eligible APIs. That is different from collecting information about unrelated businesses.
  • Public place information: For an application or a larger structured lookup, Google Maps Platform offers APIs, subject to its product rules, billing, and usage limits.
  • Your own field research: You can manually enter observations into a spreadsheet, or import data from a source that explicitly permits reuse.

These sources are not interchangeable. A file of your saved locations does not represent every result for a search, and an API response is not automatically a license to build a permanent directory.

Choose a Method That Fits the Job

Start by deciding what you need to do with the data, how many records you need, and whether you have permission to collect and retain them. A one-off list of eight venues has different requirements from a frequently refreshed list of thousands of businesses.

  • Small, one-time list: Create a workbook and enter a limited set of details from places you inspect individually. This is simple, but it takes time and should not become automated copying of search results.
  • Your saved places: Check Google Takeout for a Maps export. Review the files and formats included before planning an Excel workflow; options can differ with the account and the data being exported.
  • Application or approved data workflow: Review the Google Maps Platform Places API documentation and policies. Use the API only for a permitted purpose and request only the information needed.
  • Reusable business dataset: Consider a licensed supplier, a government open-data portal, or another source that expressly permits the intended use and redistribution.

For customer addresses, staff locations, or a business’s own records, the organization’s existing CRM, booking system, or business-management software may be the authoritative source. Google Maps can help verify a location, but it should not be assumed to be the master database.

Manually Build a Small Excel List

For a handful of locations, the most straightforward approach is to make a clean table yourself. Open Excel for Microsoft 365 on Windows and create headings such as Name, Address, Category, Phone, Website, Source, and Checked date. Add only the fields you need, and note where each value came from. A checked date matters because business details can change.

  1. Search for one place in Google Maps and open its place panel.
  2. Check the details you need and record them in the corresponding spreadsheet row. Do not assume every result has every field.
  3. Repeat for the small, defined set of places rather than trying to harvest a whole results page.
  4. In Excel, select the filled range and choose Insert > Table. Confirm that the table has headers.
  5. Save the workbook as an Excel file. If you need to exchange a simple table with another application, use File > Save As and select CSV UTF-8 (Comma delimited) (*.csv), where that option is available.

Keep addresses in one column initially, even if they contain commas. When Excel opens a properly quoted CSV, it can interpret those commas as part of a field rather than as column separators. For postal codes, phone numbers, and identifiers, use a text format where appropriate: Excel may otherwise remove leading zeros or reinterpret values. A phone number is not a quantity to calculate, so storing it as text is usually sensible.

On Mac, the same basic workflow works, though ribbon labels and the Save As file-type list can vary slightly by Excel version. Excel for the web can open and edit workbooks, but desktop Excel is often more convenient for importing files and managing larger data-cleaning tasks.

Use Google Takeout for Your Own Saved Places

If your goal is to back up locations you saved in your own Google account, look in Google Takeout for a Maps-related export and review the available categories and file formats before starting. A Takeout archive is a download of account data, not an export of all public Maps search results. Do not expect it to contain a complete business directory or a polished worksheet.

Takeout files may include KML or other structured files. KML is intended for geographic data and can represent placemarks and coordinates; it is not the same as CSV. If the archive contains KML, inspect a copy first. Converting it to a table may require a geographic-information application or a carefully chosen converter, and fields can be nested or represented differently from ordinary spreadsheet columns. Avoid uploading private location history or sensitive account data to an unknown conversion website.

For a straightforward conversion, choose a tool that explains what it does with uploaded files, supports the particular KML structure, and lets you export a CSV. Open the resulting CSV in Excel and check several rows against the source. Coordinates, names, and descriptions should not be silently dropped or shifted into the wrong columns.

Use the Places API for Structured Access

Google Maps Platform’s Places API is the formal route to request place information programmatically for use cases allowed by its terms. Depending on the API operation, a request can search for places or retrieve details about a particular place. The response is structured data, commonly JSON, rather than an Excel workbook. The API requires setup such as a Google Cloud project and API key, and usage can incur charges under the current pricing and billing rules.

Before writing code or connecting a spreadsheet, decide what fields the project needs and read the current documentation for the API version and operation. Newer Places API requests use field masks to specify requested fields. Results, field availability, pagination, quotas, and billing depend on the operation and current product rules; do not assume that a request returns every field shown on a Maps screen.

To get an authorized JSON file into Excel for Microsoft 365 on Windows, a typical desktop route is Data > Get Data > From File > From JSON. In Power Query, expand the relevant records and lists into columns and rows, review data types, then choose Home > Close & Load. If your approved workflow provides CSV instead, use Data > From Text/CSV, inspect the delimiter and preview, and select Transform Data if you need to adjust columns before loading. On Mac and Excel for the web, connector availability can differ by version; if a particular import option is absent, prepare an allowed CSV with another trusted tool and open that file in Excel.

Keep API credentials out of shared workbooks and public repositories. Restrict keys in Google Cloud settings to the services and applications that need them, and follow Google’s current attribution, storage, display, and usage requirements. In particular, access to an API is not permission to create an unrestricted permanent copy of Maps content. Check the current Google Maps Platform terms and Places policies before designing a dataset or refresh schedule.

Clean and Organize the Spreadsheet

Once the data is legitimately in Excel, structure it so that each row represents one place and each column represents one kind of information. A practical table might contain Place name, Street address, City, Region, Postal code, Country, Latitude, Longitude, Category, Phone, Website, Source, and Last checked. Keep raw imported data on a separate worksheet if you need to preserve it for comparison.

Use consistent conventions: separate address parts if you need to sort by city, store coordinates in numeric columns, and keep phone numbers and postal codes as text. Do not treat ratings as a stable measure without recording when and where they were obtained. If two sources disagree, keep a source or notes column rather than silently overwriting one value.

For a CSV import in Windows Excel, Data > From Text/CSV provides a preview before loading. Check the delimiter, encoding, and data types, especially if names contain accented characters or fields contain commas. If Excel has already opened a CSV and removed leading zeros, close it without saving and re-import it with the relevant column set to Text. A CSV stores a single flat table, not Excel formatting, multiple worksheets, or formulas, so save a working copy as .xlsx when those features matter.

Scraping, Accuracy, and Privacy Risks

Browser extensions, scripts, and scraping services that promise to extract every Google Maps result deserve particular caution. Automated collection can conflict with Google Maps terms and may bypass product limits; it can also produce incomplete or stale results. A map’s displayed ranking is not a guaranteed complete list, and repeated searches may return overlapping or different records. A technically successful scrape does not establish that the data can be stored, republished, or used for marketing.

There are also practical and privacy concerns. A third-party extractor may ask for account access, browser permissions, or payment, and could expose search history or other data. Business contact details can be personal data when they identify an individual. Before collecting, sharing, or contacting people using a location list, check the rules that apply to the source, the intended use, and the relevant jurisdiction. For sensitive or commercial projects, obtain appropriate legal or privacy guidance rather than assuming that information visible on a map is free to reuse.

Alternatives When You Need a Downloadable Dataset

If the real need is a list of locations rather than Google’s own data specifically, a source built for downloads may be more suitable. Municipal open-data portals publish datasets such as public facilities, transit stops, or licensed businesses; national mapping agencies may provide geographic data; and commercial data providers can license business information with explicit terms. Coverage, update frequency, and permitted use vary, so check the documentation and license before importing.

Google My Maps is useful for organizing a custom map and can import spreadsheet-style data, but it should not be confused with a bulk export of Google Maps search results. Its export options are focused on geographic formats such as KML/KMZ, not a universal Excel download of arbitrary search listings. Likewise, Google Takeout is for data associated with your account, not a way to claim ownership of the general Maps database.

For a new dataset, define a geographic boundary, the categories needed, update frequency, and acceptable source terms first. That makes it easier to compare sources on completeness and cost, and reduces the chance of building a workbook around data that cannot legally or practically be retained.

Frequently Asked Questions

Can I export Google Maps search results directly to Excel?
No general built-in Google Maps command exports an entire search-results page to Excel. For a small number of places, record selected details manually; for a larger permitted workflow, investigate the Places API or a properly licensed dataset.

Can Google Takeout export my saved places?
Maps-related data may be available through Google Takeout, depending on the account and export options. The archive may contain KML or other files rather than an Excel workbook. Check the archive contents and treat it as your account data, not a download of public search results.

Can Excel open a Google Maps KML file?
KML is a geographic XML-based format, not a normal spreadsheet file. Excel may not turn a complex KML file into a useful table with one click. A trusted GIS tool or converter can help create CSV, but verify the resulting columns and protect private data during conversion.

Is it legal to scrape Google Maps?
That depends on the method, purpose, applicable terms, and law. Automated scraping may violate Google’s terms, and visibility on a map is not blanket permission to copy or republish data. Review current Google policies and seek qualified advice for consequential commercial use.

Does the Google Places API cost money?
API use is governed by Google Maps Platform’s current pricing, billing, and quota rules. Charges depend on the services and usage involved, and prices or included allowances can change. Check the official pricing page and configure budget alerts before running requests at scale.

What is the easiest safe option for a short list?
Make a small Excel table and enter only the information you need from places you review individually, with a source and checked date. If you need many records or plan to reuse them, confirm that your data source permits that use before collecting anything.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.