Turn Google's local results into a CSV of business leads
Give it a list of keywords and a list of towns. It searches every combination and collects each business with its website, phone, address and rating.
Get Google Map Extractor
A third-party Chrome extension by an independent developer. Works in Chrome, Edge and Brave. SerpHammer doesn't host or sell it — this page explains what it does before you commit.
orthodontist
Bristol
→ one CSV
Paced at roughly six seconds per business, so a big keyword × location matrix is a long unattended run.
What the extension actually does
Every keyword, every location
Paste keywords in one box and locations in another. The extension multiplies them into a queue — 12 keywords across 20 towns becomes 240 searches — and works through it one at a time, showing a live progress count.
Reads the whole listing
For each business in Google's local results it opens the listing and reads the name, website link, phone, street address, star rating and review count — the fields you'd otherwise copy by hand.
Follows pagination
When a page of results is exhausted it clicks through to the next one and keeps going, then moves on to the next keyword and location pair. You start it once and leave it.
Finds emails from websites
A separate Scrape Emails pass visits each collected website and pulls email addresses out of the page source into three email columns. It reports how many rows still have a website but no email yet.
Email blacklist
Keep a list of addresses you never want in an export — shared inboxes, your own domain, known junk. Matches are replaced with Blacklisted Email rather than being silently dropped, so you can see it happened.
Sort, filter, then export
Results land in a grid with a search box, per-column filters and 25/50/100 rows per page, so you can sanity-check the haul before exporting all 15 columns to CSV. Duplicate listings are merged as they arrive.
The 15 columns you get
Every export has the same shape, whatever you searched for. Three of these columns aren't populated in this version — they're listed here so nothing surprises you in Excel.
keywordThe search term that found this businesslocationThe town or area searchedcompany_nameBusiness name as Google lists itwebsiteOutbound site link, when the listing has onephonePhone number from the listing detailsemail_1First email found on the websiteemail_2Second email found, if anyemail_3Third email found, if anyaddressStreet address as one linecityNot filled in this versionstateNot filled in this versionpincodeNot filled in this versionrating_countNumber of reviews, as a numberreviewStar rating text from the listingcidInternal id used to merge duplicatesWhere it falls short
- Demo mode stops at 50 records and the Download button opens the licence prompt instead of saving a file. A paid licence key from the developer removes both limits.
- city, state and pincode ship empty. The address arrives as a single line; splitting it is on you, and a spreadsheet formula handles it in a minute.
- Emails only come from page source. Contact details behind a form, an image, or loaded by JavaScript after the page renders won't be found.
- It reads Google's HTML, so a layout change on Google's side can break field detection until the extension is updated. Spot-check a handful of rows against the live listings before you trust a big export.
- Long runs can trigger a CAPTCHA. The pacing is deliberately slow, but a few hundred searches back to back is still unusual traffic.
Running your first extraction
-
1
Install it
Get the extension from the developer's page. If it comes as a folder rather than a store listing, open
chrome://extensions, turn on Developer mode, and use Load unpacked. -
2
Load your lists
Open the extension and fill the Keywords and Locations boxes, one per line. The counters beside each label confirm what it read, and the progress bar shows the total number of searches queued.
-
3
Start, then export
Hit Start Extracting and leave the window open. When it settles, run Scrape Emails if you want contact addresses, then Download for the CSV. Clear Data empties the grid before the next job.
Good to know
Budget the time
Roughly six seconds per business, plus a random pause, plus a page turn between result pages. Twenty listings a search across fifty searches is a few hours — start it when you don't need the machine, and don't close the browser window mid-run.
Demo versus licensed
Unlicensed, you get 50 records and no export — enough to judge whether the data quality suits you. Activate License in the toolbar takes a key in the XXXXX-XXXXX-XXXXX-XXXXX-XXXXX format. Keys, pricing and support come from the developer.
Emails are a second pass
Email discovery doesn't run during extraction — it's the separate Scrape Emails button, and it only visits rows that have a website and no email yet. The button label shows how many of those are left, so you can tell when it's finished.
What it can reach
The extension asks for access to all sites, because email discovery has to fetch arbitrary business websites. That's a broad permission — worth understanding before you install any extension, this one included. Your collected rows live in the extension's own local storage.
Check before you trust
Field detection depends on Google's current markup. Open five random rows against the real listings after a big run; if names or phones look shifted, the selectors have gone stale and the export needs treating with suspicion.
Use the data responsibly
Business contact details are still personal data under GDPR and similar regimes once they identify a person. Have a lawful basis for your outreach, honour unsubscribes immediately, and don't blast a scraped list — that's how domains get burned.
Frequently asked questions
Is this SerpHammer's extension?
No. Google Map Extractor is a third-party Chrome extension built by an independent developer. This page is an independent guide to what it does, what it exports and where it struggles, with a link to the developer's own download. SerpHammer does not host, sell or support the extension.
What exactly does it collect from Google?
For each business in Google's local results it reads the business name, website link, phone number, street address, star rating and review count, plus the keyword and location that found it. It also stores an internal id used to merge duplicates. Everything comes from the results page your browser has already loaded — the extension reads the page, it does not call a Google API.
How does the email finding work?
Separately from the main run. Once you have results, Scrape Emails visits each collected business website in turn and pattern-matches email addresses out of the page source, filling the email_1, email_2 and email_3 columns. It only reaches addresses published in the page's HTML, so sites that hide contact details behind a form or an image will come back empty.
Is it free?
There is a demo mode and a paid licence. Without a licence key the run stops at 50 collected records and the Download button opens the licence prompt instead of saving a CSV. Entering a valid key removes both limits. Pricing and keys come from the developer, not from SerpHammer.
Will Google block me?
It can. The extension paces itself — roughly six seconds per business plus a random delay — so ordinary runs look like normal browsing. Long unattended runs across many keyword and location combinations are what tends to trigger a CAPTCHA. If you hit one, stop, solve it, and continue with smaller batches.
Why are some columns empty in my CSV?
The CSV always has the same 15 columns, but this version never fills city, state or pincode — those are split out of the address in some builds and not in this one. The email columns stay empty until you run Scrape Emails, and any single listing can be missing a website or phone simply because the business did not publish one.
Is scraping Google Maps data legal?
Automated collection is against Google's Terms of Service regardless of the tool, and business contact data is personal data under GDPR and similar laws once it identifies a person. Collecting publicly listed business details for legitimate outreach is common practice, but you are the data controller: honour opt-outs, keep a lawful basis for contacting people, and check the rules that apply where you operate.
Install this guide