How to Export Google Maps Data to Excel & CSV: 3 Methods (and 1 to Avoid)

You searched Google Maps for suppliers, competitors or clinics, and now you want the results in a spreadsheet. The catch: Google Maps has no "export to Excel" button for search results. You can still export Google Maps data to Excel or CSV, but the right method depends on what you want to move and how you plan to use it.

This guide covers three methods that work, what each one actually exports, and where Google's terms draw the line. It also points to better sources for bulk business data in Europe.

Quick answer: Use Google Takeout for your own saved lists. Copy a handful of businesses by hand for one-off research. Use the Google Places API when you're building an application. Don't assume a scraper makes bulk export of Maps content acceptable.

Can You Export Google Maps Search Results to Excel?

Not directly. Google Maps has no export function for an ordinary search-results page.

Google does offer Google Takeout, which exports data tied to your own account, including saved lists. That distinction shapes everything else:

If you want a spreadsheet of every business returned for "dentists in Tallinn", none of Google's official tools will produce it. That is by design.

Method 1: Export Google Maps Saved Lists With Google Takeout

Google Takeout is Google's tool for downloading your account data. It is the only official way to export saved Google Maps lists.

How to export your saved lists

1. Open Google Takeout and sign in with the account that holds your lists.
2. Click Deselect all, so you don't export your entire Google account.
3. Tick Saved for your saved lists. Also tick Maps (your places) if you want starred and labelled places.
4. Click Next step, choose a one-time export and a file type, then click Create export.
5. Wait for Google's email and download the archive.

What's inside the export

Each saved list arrives as its own CSV file. Starred places arrive as GeoJSON.

The list CSVs are lean. Expect the place name, any notes you added and a Google Maps link. Addresses and coordinates are usually missing, so inspect your files before planning around them.

Converting the files to Excel

CSV files open directly in Excel, Google Sheets, LibreOffice Calc and Apple Numbers. Save as .xlsx if you need formulas, filters or multiple sheets.

GeoJSON needs one extra step. Convert the features into rows with a GIS tool or a short script, then import the resulting CSV.

Limitation: Takeout exports what you saved. It cannot export the results of an arbitrary Maps search.

Method 2: Copy Google Maps Results Into Excel Manually

For 10–20 businesses, manual copying is often faster than any automated setup. Comparing five local competitors before a store visit is a typical case.

Set up the spreadsheet first

Create one column per field before you start:

Keep one value per cell. A cell holding "name, address, phone" is hard to sort, filter or deduplicate. The "Date checked" column matters because ratings, opening hours and rankings change.

Know the limits

Manual collection breaks down at scale. Hundreds of rows mean slow work, typos and a list that is outdated before you finish.

There is also a terms question. Google Maps' end-user terms prohibit mass-downloading content or creating bulk feeds. They also bar using Maps to build datasets, such as business listings or mailing lists, for a service that substitutes for Google Maps. Keep manual lists small, internal and purpose-specific.

Method 3: Use the Google Places API for Structured Place Data

If you're building software, such as a store locator or booking flow, the Google Places API is the official route to structured place data.

Places API (New) includes Text Search, Nearby Search, Place Details, Place Photos and Autocomplete. You need a Google Cloud project, billing and an API key.

How the Places API works

A Text Search (New) request takes a query such as "accounting firms in Helsinki" and returns matching places. Four rules shape every request:

• Field masks are mandatory. You list the fields you want. Requests without a field mask return an error.
• Fields drive cost. Google bills each request at the highest SKU tier (Essentials, Pro or Enterprise) among the fields you request.
• Results per page are capped. Text Search returns up to 20 results per page.
• Total results are capped. Text Search returns at most 60 results across all pages. Google notes this limit may change.

Why the API isn't an "export to Excel" shortcut

The API gives you access to data, not the right to warehouse it. The Google Maps Platform Terms forbid exporting or scraping Maps content for use outside the services. Their examples include copying and saving business names, addresses or user reviews.

Caching is tightly limited as well. Place IDs can be stored, and coordinates can only be cached temporarily. Check the service-specific terms before storing anything else.

EEA note: Since 8 July 2025, projects linked to a billing account with an EEA address fall under separate EEA Maps Platform terms. They changed several rules, but the no-scraping clause remains.

For a broader comparison of the two approaches, read our guide to web scraping vs API for retail data.

The One to Avoid: Bulk Google Maps Scrapers

Many tools promise to turn any Maps search into a CSV with thousands of rows. Technically, many can. That doesn't make it permitted.

Three separate questions apply:

1. Can the data be retrieved? Often, yes.
2. Do Google's terms allow it? Both the end-user terms and the Maps Platform terms restrict bulk extraction.
3. Does the law allow your intended use? Consider GDPR, EU database rights, copyright and marketing rules.

For European teams, the third question carries real weight. A sole trader's name and phone number are personal data under GDPR, even when publicly visible. Reviews carry reviewers' names. Outreach rules also vary: Germany, for example, is notably strict about unsolicited marketing emails, even between businesses.

We discuss the wider debate around automated collection in The Anti-Bot Arms Race. If you're considering a Maps scraper for production use, get legal advice first.

Better Sources for Bulk Business Data in Europe

If you need a large, reusable business dataset, start with sources that permit reuse:

• Open company registers. EU Implementing Regulation 2023/138 lists company data as a high-value dataset. Since June 2024, member states must publish these datasets free of charge, in machine-readable formats and via APIs. Finland's avoindata.fi portal, for example, now labels them.
• OpenStreetMap. It holds points of interest, including shops and offices, under the ODbL licence. Attribution and share-alike rules apply.
• Licensed data providers. Commercial point-of-interest and firmographic datasets come with explicit reuse rights.
• Businesses' own websites. Company sites, store locators and online shops publish their own information. Where extraction is permitted, platforms like ScrapeWise.ai turn these pages into scheduled CSV or API feeds. See how product data extraction works.

For local SEO research, rank-tracking tools are a cleaner option than scraping. Semrush's local SEO guide explains how local visibility works, and its Map Rank Tracker measures Maps rankings by location.

How to Keep Your Google Maps CSV Data Clean

Whichever method you use, a spreadsheet is only as useful as its structure.

1. Define fields before collecting. Gather only what you'll use. Data minimisation is also a GDPR principle.
2. Normalise formats. Use one phone format, such as +372 …, and split addresses into street, postcode and city.
3. Deduplicate carefully. Chains and multi-category businesses appear repeatedly. Matching on name alone fails, so combine name, address and website. Our post on product data matching covers the same challenge for SKUs.
4. Timestamp every row. A spreadsheet is a snapshot, not a live record.
5. Record the source. Note where each row came from, so you can later answer "may we use this?"

Troubleshooting Common Export Problems

Your Takeout CSV has no addresses. That's normal for saved-list files. The starred-places GeoJSON stores coordinates by design, so check that file too.

The Places API returns an error. Check the field mask first, then billing, API key restrictions and quotas.

The API stops at 60 results. That is the documented cap. If you routinely need more, you likely need a different data source.

The CSV looks broken in Excel. Use Data → From Text/CSV and set the encoding to UTF-8, so characters like ä, ö and ø display correctly. Excel in many European locales expects semicolons, so set the delimiter explicitly.

FAQ

Can I export Google Maps search results to Excel?

Not directly. Google Maps has no export button for search results. You can export your own saved lists through Google Takeout, copy a few results by hand, or use the Places API inside an application.

How do I export a Google Maps list to CSV?

Open Google Takeout, click Deselect all, tick Saved and create the export. Each saved list arrives as a separate CSV file that opens in Excel or Google Sheets.

Is it legal to scrape Google Maps?

There is no single answer. Google's terms restrict bulk extraction for both regular users and API customers. In Europe, GDPR also applies to personal data in listings and reviews, so get legal advice before scraping Maps for production use.

How many results can the Google Places API return?

Text Search (New) returns up to 20 results per page and at most 60 across all pages. Google notes that this limit may change.

What's the difference between Google Takeout and a Google Maps scraper?

Google Takeout is Google's official tool for exporting data from your own account, such as saved lists. A scraper extracts content from Maps pages automatically, which Google's terms restrict.

Conclusion

Exporting Google Maps data to Excel is simple once you match the method to the goal. Use Google Takeout for saved lists, manual copying for short research lists and the Places API for applications.

For bulk business data, look beyond Google Maps. EU open registers, OpenStreetMap and licensed providers offer data you can actually reuse. When the data lives on public company websites, platforms such as ScrapeWise.ai can deliver it as clean, scheduled feeds. Our guide to AI-powered web scraping explains how that works.

This article is for general information and isn't legal advice. Google's terms change, so check the current versions that apply to you.