How to scrape Google Maps to Excel (free) — business leads, no code

Google Maps is one of the best free sources of local-business leads on the internet: search any service in any city and you get dozens of businesses complete with names, phone numbers, websites, ratings, and categories. The problem is getting all of that out of Maps and into a spreadsheet you can actually work with. This guide shows you how to scrape Google Maps into an Excel or CSV file, for free, without writing any code, using the Grabby web scraper Chrome extension.

By the end you will have a clean lead list, one row per business, ready for outreach, a CRM, or research.

Is it legal to scrape Google Maps?

Business names, phone numbers, and websites shown on Maps are public information, and collecting them for research or lead generation is common practice. That said, be responsible: respect Google’s terms, keep your volume reasonable, and remember that how you use the data is regulated too. If you plan to contact these businesses, follow the rules that apply to you, such as GDPR in Europe and CAN-SPAM for email in the US. Grabby reads the Maps results you have already loaded in your own browser, so it behaves like a person browsing rather than an aggressive bot. (This is a how-to, not legal advice.)

What you’ll need

• Google Chrome, Microsoft Edge, or Brave.
• The free Grabby extension. No account, no API key, no proxies.
• A Google Maps search for the businesses you want, for example plumbers in your target city.

Step 1: Install Grabby (free)

Add Grabby to your browser from the Chrome Web Store. Nothing to sign up for, nothing to configure. Everything here works on the free plan.

Step 2: Search Google Maps

Open google.com/maps and search for a service and a location, for example plumbers in Austin, TX. Maps shows a scrollable list of businesses on the left. This results panel is what you are going to turn into a spreadsheet.

Step 3: Run the Google Maps template

Open Grabby’s side panel and choose Scrape List. On Google Maps you will see a one-click template made for the results panel, so you can skip selecting anything. Click Run and Grabby captures each business with the fields that matter for a lead list:

• Business name
• Rating and review count
• Category (plumber, dentist, and so on)
• Phone number
• Website
• The Google Maps link to each place

No template on your version, or scraping a different Maps view? Click Select the list and click any one business card instead, and Grabby highlights the whole results list.

Install Grabby free and build your lead list

Step 4: Scroll to load more results

Google Maps loads businesses as you scroll the results panel rather than all at once. To collect a longer list, scroll the panel down so more businesses load, then run the scrape (or re-run it) to capture the fuller set. Maps typically surfaces a few dozen results per search, so if you need more, run several nearby searches (by neighborhood or city) and combine the exports.

Step 5: Clean up your lead list

Your results open in an editable data table, one row per business. This is where you turn raw results into a usable lead list: remove duplicate or empty rows, drop businesses with no phone or website if you only want contactable leads, rename columns, and sort by rating or review count to prioritize. It is all non-destructive, so tidy the list until it is exactly what you need.

Optional: get an email for each business

Maps rarely lists email addresses directly. But Grabby captured each business’s website, so you can feed that column of URLs into Grabby’s email extractor and it will visit each site and pull the contact emails it finds, then merge them back into your list. That turns a directory of businesses into a contactable outreach list.

Step 6: Export to Excel, CSV, or JSON

Click Export and choose your format. Pick CSV or Excel and open it directly, export JSON for another tool, or copy the whole table and paste it straight into Google Sheets or your CRM import. Everything is saved locally, so your lead list is yours and nothing is uploaded.

Troubleshooting

• Only a few businesses captured? Scroll the Maps results panel to load more, then run the scrape again.
• Missing phone or website? Not every business lists both on Maps. Filter those rows out after export if you only want complete leads.
• Template not showing? Use Select the list and click one business card to grab the list manually.
• Need more than one city’s worth? Run separate searches per area and combine the exported files.

Frequently asked questions

Is it really free? Yes. Grabby is free while in early access, with every feature unlocked and no sign-up.

Can I get emails from Google Maps? Maps itself rarely shows emails, but you can extract them from each business’s website using Grabby’s email extractor on the website column.

How many businesses can I scrape? As many as Maps shows for your search. For bigger lists, run several searches by area and merge the results.

Can I export to Google Sheets? Yes, copy the table and paste it straight into a sheet, or export CSV or Excel and import it.

Does this work for any business type? Yes. Restaurants, dentists, gyms, agencies, anything you can search on Maps.

Scrape any other site the same way

Google Maps is one of the highest-value sources, but the same select, scrape, clean, and export flow works anywhere. See our guides to scraping Amazon product data to Excel and scraping any website to Excel without code.

That’s a local-business lead list in a spreadsheet, free and without code. Install Grabby and turn any Google Maps search into Excel.