How to export Google Maps search results to a spreadsheet

Searching Google Maps for "roofers near Austin" shows you dozens of local businesses with phone numbers and websites. Getting that list into a spreadsheet for outreach is the hard part. Here's how to do it quickly.

The manual way

Click each result, copy the name, phone, website and address into a sheet, then go back and click the next one. Expect about a minute per business, so an hour for 60 leads, and you'll miss the results that only load when you scroll.

The fast way: a lead extractor extension

PinLeads is a Chrome extension that collects every business from a Google Maps search into a table you can download.

1. Add PinLeads to Chrome (it also works in Brave and Edge).
2. Search Google Maps for a business type and city, for example dentists in Columbus OH.
3. Open PinLeads and click Scroll & collect all. It scrolls the result list so every business loads. Run more searches to add to the same list; duplicates are removed.
4. Click Fill missing phones & websites for results that don't show them in the list.
5. Optional: click Find emails & social links. PinLeads checks each business's own website and contact page.
6. Click Export CSV and open it in Excel or Google Sheets.

What you get per business

Name, category, rating and review count, phone number, website, address, opening hours, map coordinates and the Google Maps link, plus contact emails and social profile links found on the business's own website.

Tips for better lead lists

• Search by neighbourhood or suburb, not just the city. Google Maps shows about 120 results per search, so smaller areas give you more businesses overall.
• Sort by review count in your spreadsheet. Businesses with few reviews are often the ones that need marketing help.
• Remove duplicates by phone number after combining several searches.
• Check the website column: businesses without a website are good leads for web designers.

Free vs Pro

The free version exports up to 25 leads per export and 10 email lookups. Pro ($29.99 once, no subscription) removes both limits.

Stay on the right side of the rules

Business listings on Google Maps are public, but how you contact people is regulated. Follow CAN-SPAM in the US (and GDPR in Europe) when you email, and honour do-not-call rules when you phone.

Updated 2026-10-09.