Yellow Pages Scraper

Export businesses from any Yellow Pages search to CSV, Excel, or JSON: names, phone numbers, addresses, websites, categories, ratings, and years in business. Free to run in your browser, no account or API key.

Up to 1,500 businesses per search
GuidesBuild a lead list and find businesses without a websiteExport Google Maps results to Google SheetsSend scraped leads to HubSpot

Runs in desktop Chrome with the free Lection extension. No Yellow Pages account or API key needed.

How to Scrape Yellow Pages Listings

Yellow Pages shows 30 businesses per search page and has no export button or public API. This tool opens the same public search pages in your own browser through the free Lection extension, reads every listing on each page, and moves to the next page until the results end or you reach your row limit.

It works for any business type and any US city, state, or ZIP code that Yellow Pages covers. No cookies are sent and you don't sign in to anything.

Step-by-Step Guide

Step 1

Enter a business type and a location

For example "plumbers" and "Austin, TX", or a ZIP code such as 78701.

Step 2

Click Export Businesses

Install the free Lection Chrome extension when asked. The tool loads the results page by page; set Max Rows for a sample, or press Stop at any time and keep what loaded.

Step 3

Download your file

Download CSV, Excel, or JSON. Downloads use credits (1 per 100 rows); a free account includes 5 credits a month.

What You Get

One row per business, with the fields Yellow Pages shows on its search results. Empty cells mean the listing doesn't show that field.

ColumnsWhat they hold
Business Name, CategoriesThe listed name and every Yellow Pages category, such as "Plumbers, Water Heaters".
PhoneThe main phone number shown on the listing.
Street Address, City, State ZIPThe street address and the city, state, and ZIP line, in separate columns.
WebsiteThe business website when the listing links one.
Rating, Review CountThe Yellow Pages star rating (1 to 5, in half stars) and how many reviews it is based on, when the business has reviews.
Years in BusinessThe "years in business" badge, when the listing shows it.
Open Status, SnippetOpen or closed at the time of the export, and the short description or review excerpt under the listing.
Yellow Pages URL, Listing IDA link to the full listing and its Yellow Pages ID, handy for removing duplicates across searches.

Honest Limits

  • Search results only. Fields that appear only on a business's detail page (hours, emails, extra phone numbers) are not included.
  • Yellow Pages covers US businesses; listings can be out of date, so check key details before you rely on them.
  • Up to 1,500 businesses per search. For a big metro area, run one search per ZIP code or neighborhood.
  • Needs desktop Chrome with the free Lection extension. If Yellow Pages shows a check page, open yellowpages.com in a tab once, then run the tool again.
  • Sponsored ad listings are skipped; regular results are kept in Yellow Pages' order.

What People Use It For

  • Local lead lists: every plumber, roofer, or dentist in a city with phone, address, and website, ready for a CRM.
  • Market research: count competitors per ZIP code and see how long they have been in business.
  • Agency prospecting: find local businesses without a website, or with few reviews, to pitch web or review services.
  • Directory and data projects: seed a niche directory or clean an existing list against fresh listings.

Need Leads From Another Directory, or Every Week?

This tool only reads Yellow Pages search results. Lection's AI scraper works on any website: open the side panel on a directory, association member list, or business profile page, describe the columns you want, and it builds the table, including pages that need you to be logged in. Save it and Lection can refresh it into Google Sheets on a schedule, so new businesses land in your sheet automatically. See how the AI scraper works.

Need this done for you, across many searches or every week? Tell us what you need.

Frequently Asked Questions

How do I scrape Yellow Pages for free?
Type a business type (like "roofers") and a city, state, or ZIP above, then click Export Businesses. The tool pages through the results 30 at a time, up to 1,500 businesses per search, and you download them as CSV, Excel, or JSON.
Can I export Yellow Pages listings to Excel or Google Sheets?
Yes. Download the Excel or CSV file and open it in Excel, or import the CSV into Google Sheets with File > Import. Each business is one row with separate columns for phone, address, website, and rating.
Does it include phone numbers, websites, and addresses?
It includes whatever the public listing shows: almost every listing has a phone number and address, and most have a website. Email addresses are not shown on Yellow Pages search results, so they are not included.
Do I need a Yellow Pages account or an API key?
No. Yellow Pages has no public API for search results, and you don't need an account. The free Lection Chrome extension loads the same public search pages you would see, in your own browser, without sending any cookies.
How many businesses can I export?
Up to 1,500 per search, or the Max Rows value you set. Loading and previewing is free. Downloads need a free Lection account and use credits: 1 credit per 100 rows, and the free plan includes 5 credits a month. For bigger areas, run one search per ZIP code or neighborhood.
Why are sponsored listings missing?
The export keeps the regular (organic) results and skips the paid ad blocks at the top of each page, so the same advertiser doesn't appear on every page of your file.
Is it legal to scrape Yellow Pages?
The tool reads public business listings, one page at a time, the way a visitor browsing the site would. Use the data responsibly: follow do-not-call and anti-spam rules (such as the TCPA and CAN-SPAM in the US) before contacting businesses, and check the site's terms for your use case.
Can I get the same list from Google Maps or another directory?
Yes. The Google Maps Business Scraper exports local businesses from Maps, and Lection's AI scraper can read any other directory page (association member lists, Yelp, chamber of commerce sites) in your browser and send it to Google Sheets on a schedule.

Related Resources

Google Maps Business Scraper

Export local businesses from Google Maps searches.

Craigslist Search Results Scraper

Export Craigslist listings by city and search.

LocalBusiness Schema Generator

Generate LocalBusiness JSON-LD for location pages.

Browse All Free Tools

Explore the full tool directory.

Scrape any site, every page, on a schedule.

Add to Chrome — free

This free tool is one ready-made template of Lection, an AI web scraper Chrome extension that extracts lists, tables and detail pages from any website. It can also scrape any website to Google Sheets on a schedule. Need a recurring data feed for your team or clients? We can set it up for you.