How to Export Google Maps to Excel or CSV (2026 Guide)
Anyone who has tried to build a prospect list off Google Maps hits the same wall in the first five minutes: there is no export button. You can see hundreds of perfectly relevant businesses — name, phone, website, rating, all right there — and Google gives you no way to get them into a spreadsheet. So people copy-paste one listing at a time, lose the afternoon, and end up with forty rows when they needed four hundred.
This guide shows the fast way: how to export Google Maps business listings straight into Excel or CSV, with one clean row per business, in minutes instead of hours. It covers the search terms that actually pull full coverage, the 120-result limit that quietly caps every Maps search, and how Kavex turns a map full of pins into a deduplicated spreadsheet you can open in Excel or Google Sheets and send the same day.
Why Google Maps has no "export to Excel" button
Google Maps is built for someone looking up one business, not for someone building a list of every business in a category. There is no native download, no "select all", no CSV option anywhere in the interface — and the data you can see on screen is deliberately hard to pull out in bulk. That is by design.
So the real question is not "where is the export button" but "how do I get this on-screen data into a structured file". The answer is a tool that reads each listing and writes it to a row for you — exactly what the copy-paste workflow does by hand, except automated, complete, and finished in minutes. Every field you can see on the map becomes a column: business name, full address, phone number, website, category, star rating and review count.
What lands in your spreadsheet
A single Google Maps run in Kavex returns one row per business, with the columns you'd build by hand if you had a week to spare:
| name | category | phone | address | website | rating | reviews |
|---|---|---|---|---|---|---|
| Bright Smile Dental | Dentist | (212) 555-0147 | 240 W 35th St, New York | brightsmile.com | 4.8 | 312 |
| Harbor Marketing | Marketing agency | (415) 555-0199 | 88 King St, San Francisco | harbormktg.com | 4.6 | 47 |
| Vale Plumbing Co | Plumber | (312) 555-0123 | 19 N Wells St, Chicago | — | 4.9 | 128 |
Phone coverage is near-total — almost every Maps listing carries a number. Website coverage varies by trade, which turns out to be useful: if you sell web design or digital services, the businesses without a website are your warmest prospects, and you can filter for exactly those (more on that below).
Mind the 120-result limit
The one thing that trips up everyone scraping Maps for the first time: Google never returns more than about 120 results for a single search, no matter how many businesses actually exist. A query like "restaurant New York" does not return New York's restaurants — it returns the first ~120 Google chooses to rank and silently drops thousands more. If you run one broad search and export it, you have skimmed the top of the market and missed most of it.
The fix is to scope each run narrowly and combine them:
- By area — run one search per neighbourhood, suburb or town rather than one for the whole metro.
- By postcode / ZIP district — the cleanest geographic lever, because it carves a city into precise, non-overlapping chunks.
- By category term — businesses pick their own Maps category, so "restaurant", "bistro" and a cuisine name surface different listings; run the related terms as separate searches.
Kavex deduplicates every run on Google place ID, so where your area searches overlap at the edges, the duplicate rows collapse automatically into one master list. You collect a market exhaustively instead of capturing its first 120 names.
Search the terms people actually use
Coverage depends heavily on the term you search, because each business chose how it's listed. Run a few overlapping queries and let the deduplication merge them — "estate agent" and "letting agent" surface different halves of the property trade; "solicitor" and "law firm" pull different listings again; a sole-trader listed only as a "heating engineer" never appears under "plumber". Two or three related terms across the same area beat one broad term every time.
Export to Excel, CSV, or straight into your CRM
When the run finishes, download it in the format you actually work in. CSV is the universal option — every spreadsheet and CRM imports it natively, each line is a row, and the columns come pre-labelled. XLSX opens straight in Excel with formatting intact. From there it goes wherever your outreach lives: import into Excel or Google Sheets to sort and filter, or push it straight into a CRM, a dialler, or a cold-email tool like Instantly or Smartlead.
Two add-ons make the export immediately usable:
- The Email Finder visits each business's own website and pulls a contact address, so your spreadsheet has emails as well as phones.
- The Phone Validator flags which numbers are mobiles versus landlines, so your callers don't waste dials.
Selling websites? Set Has website → No in the advanced filters before you run, and the export comes back as a pre-qualified list of businesses with no site at all.
The five-minute version
- Pick a term and an area — e.g.
dentistin one ZIP district. - Run the Google Maps job in Kavex with a result cap.
- Repeat by area to clear the 120-result ceiling; Kavex dedupes on place ID.
- Add enrichment — Email Finder for addresses, Phone Validator to sort numbers.
- Export to CSV or XLSX and open in Excel, Sheets, or your CRM.
From first search to a clean, deduplicated spreadsheet is usually three to five minutes — the copy-paste version of the same list is a lost afternoon.
Try it free
Pick one category and one area, run it on your signup credits, and open the CSV before you spend anything. Start free with 1,000 credits — no card — enough to export your first few hundred businesses and see the data quality for yourself.
Keep reading
- How to scrape Google Maps — the full method, every output column explained.
- Free Google Maps scraper — try the engine behind every export.
- Google Maps scraper for London business leads — a worked, city-by-city example.
- Phone Validator — sort mobiles from landlines before your callers dial.
- How to clean and format a CSV for cold email — get the export sequencer-ready.
Start free — 1,000 credits, no card.
Pick a category and a city, run Google Maps, and export an enriched CSV.
Build your first lead list