How to export Google Maps results to CSV or Excel

Google Maps is the most complete free directory of local businesses there is, but it was built for finding one place, not for downloading a hundred of them. There is no export button. If you want search results in a spreadsheet, you have to get them there yourself.

This guide covers the options, what each gives you, and how to end up with a file that opens cleanly and imports without a fight.

Can you export Google Maps results natively?

No. Google Maps has no built-in way to download search results as CSV or Excel. You can save places to a list in your Google account, but that is a bookmark list, not a data export with phones, websites and addresses in columns.

That leaves three realistic routes.

Whichever you choose, be clear-eyed about the rules. Scraping Google Maps is against Google’s Terms of Service. The data is public business contact information and collecting it is not generally unlawful, but the ToS question is real and it is your call to make.

What fields can a Google Maps export include?

Everything a listing shows: name, categories, rating, review count, phone, website, full address, hours, plus code and the Maps link. A deeper read of each listing also gives address components, coordinates, Place ID, description, services and photo count.

What a listing does not include is an email address or the names of people at the business. Those come from the business website. If your export needs them, you need an enrichment step that visits each site; we cover that in how to find the decision-maker’s email from a company website.

LeadScrapper’s business export has 96 columns, from Business Name, Phone and Email through Has Website, Claimed, Hours, Latitude, Longitude, Place ID and Google Maps URL, to the website audit columns and a Score with a Why (pitch angle) column. The full list, grouped by what each column is for, is on the features page.

How do you export more than 120 results?

Split the search by location. Google caps one search’s results at roughly 120 listings, so instead of one broad search, run the same term across several cities or ZIP codes and merge the results.

When you merge, deduplicate. Businesses near a city boundary appear in both searches. A tool should dedupe on a stable identifier such as the Place ID rather than on name, because names are not unique and are often written slightly differently. LeadScrapper merges and dedupes across every location in a run, so a business that appears in two neighbouring cities is stored once.

Step by step: exporting with LeadScrapper

Here is the full sequence, from a blank Chrome to a file on disk.

1. Install the extension in Chrome 114 or later. It shows in Chrome as Lead Grabber. The install guide has every step.
2. Open the side panel from the toolbar icon and choose Google Maps as the source.
3. Type a search term as you would in Maps, such as “dentist” or “roofing contractor”.
4. Pick locations with the state, city and ZIP picker, or type your own, one per line.
5. Choose Fast or Deep. Fast reads the results list; Deep also pulls each listing’s full record.
6. Turn on enrichment if you want emails, socials and named staff. Leave it off for a quick listings-only export.
7. Set any filters: minimum rating, minimum reviews, phone required, or only businesses without a website.
8. Start the run and watch leads arrive in the Leads tab. You can export at any point, even while the run is still going.
9. Choose the shape and format from the export bar and download.

Exports include everything currently filtered in, not just the rows visible on screen. If a long run is interrupted, the Runs tab offers Resume, and a CSV snapshot is saved to your Downloads folder every 250 leads regardless. The how it works page explains why runs survive Chrome closing.

Which export shape should you choose?

Businesses for prospecting, Contacts for a CRM, and Both when you want the two side by side.

• Businesses: one row per business. This is the prospecting list you sort, filter and work through. The most senior person found is already on the row as Contact Name and Contact Title.
• Contacts: one row per person, each carrying its company’s name, phone, website, address, score and pitch angle alongside their own name, job title, email, direct phone, socials and licence. It imports straight into a CRM with no joining.
• Both: the two as separate sheets in one workbook.

CSV, Excel or JSON?

CSV for imports, Excel for people, JSON for code. All three hold the same data; they differ in how safely other software reads it.

CSV is the universal import format. Almost every CRM, email tool and spreadsheet accepts it. LeadScrapper writes CSV with a UTF-8 byte order mark so accented business names display correctly when Excel opens the file.

Excel (XLSX) is the better choice when a person will open the file. The XLSX export keeps leading zeros on ZIP codes and stores ratings as numbers, so sorting works.

JSON suits developers and automations that will process the list programmatically.

How do you stop Excel mangling the data?

Open an XLSX file rather than a CSV, or import the CSV through Excel’s data import and set the ZIP and phone columns to Text. Double-clicking a CSV lets Excel guess column types, which is where things go wrong.

The usual casualties:

• ZIP codes lose leading zeros: 02134 becomes 2134.
• Phone numbers can turn into scientific notation or lose a leading plus sign.
• Long IDs such as CID values can be rounded.

If you must work from CSV, import rather than open, and set those columns to Text before you load.

How do you import the export into a CRM?

Use the Contacts export if your CRM is organised around people, and the Businesses export if it is organised around companies. Then map columns once and save the mapping for next time.

A few habits make imports painless:

• Map names to name fields. The Contacts export already splits First Name and Last Name, which most CRMs want for personalisation.
• Keep a source column. Search Term, Search Location and Scraped At travel with every row, so you can tell later which run a contact came from.
• Import a small batch first. Ten rows will show you any mapping mistakes before they are repeated across a thousand.
• Do not import rows you will not contact. Filtering in the spreadsheet first keeps your CRM clean and your opt-out records simple.

What should you check after exporting?

Look over a sample before anything goes into a CRM or an outreach tool. Remove categories you did not mean to include, confirm phones and websites on a few rows against the live listing, and note any rows whose website is down or parked.

Then check the rules for how you plan to use the list. In the US, cold commercial email falls under CAN-SPAM: honest sender details and subject lines, a valid physical postal address, and a working opt-out you honour promptly. If your prospects are in the UK or EU, GDPR and PECR apply. Respect the terms of any website you collect from as well.

Where to go from here

If you are building the list from scratch, start with our guide to building a local business lead list from Google Maps. For a look at the tool itself, the Google Maps scraper page covers what it does and does not do, and the extension FAQ answers the common questions about plans, installs and data.