YellowPages Scraper — Local Business Leads (Phone, Address, Website) to CSV/Excel

Fast YellowPages.com scraper for local-business lead generation. Search any business type in any US city and pull clean, spreadsheet-ready rows — name, phone, address, website, rating, reviews, categories, years in business — with no login and no API key.

yellowpages scraper · yellowpages.com scraper · local business leads · b2b lead generation · business directory · phone number scraper · local seo · sales prospecting

Built for sales teams building local lead lists, agencies doing local SEO, and analysts mapping a market by city and category.

---

👥 Who Is This For?

• B2B Sales / Lead-gen: Build targeted call/email lists by trade + city.
• Local SEO Agencies: Pull local competitors with ratings, categories, and websites.
• Market Analysts: Map a category across geographies (counts, ratings, tenure).

---

⚡ Features

• Contact data — business name, phone, street address, locality, website.
• Reputation — star rating and review count.
• Firmographics — categories, years in business.
• Multi-search — several search terms in one run, one location filter.
• Full-profile mode (optional) — description, address parts, geo lat/lng, founding year, opening hours, social links.
• De-duplicated — by YellowPages profile URL.
• Cost control — hard maxItems cap.
• Export — CSV/Excel/JSON, or call via Apify's MCP server.

---

🚀 How to Use

1. Add one or more search terms (e.g. plumber, dentist, roofing contractor).
2. Set a location (e.g. New York, NY or a ZIP like 90210).
3. Set Maximum Items and press Start.
4. Export as CSV, Excel, JSON, or HTML.

Sample Input

{
  "searchTerms": ["plumber", "electrician"],
  "location": "New York, NY",
  "maxPagesPerSearch": 3,
  "maxItems": 500,
  "scrapeProfileDetails": false,
  "proxyConfiguration": { "useApifyProxy": true, "apifyProxyGroups": ["RESIDENTIAL"] }
}

---

🔎 Two modes

• Directory (default): everything from the results page — name, phone, address, website, rating, reviewCount, categories, yearsInBusiness, snippet. One request per results page.
• Full profile (scrapeProfileDetails: true): visits each business profile for the rich object — full description, address object (street/city/region/zip/country), geo (lat/lng), foundingDate, openingHours, socialLinks, areaServed. +1 request per business (slower, more bandwidth). Businesses whose profile is temporarily blocked still return their directory row — no data is lost.

---

📊 Output Data Dictionary (Directory mode)

Field	Type	Example
name	string	"RR Plumbing Roto-Rooter"
phone	string | null	"(917) 997-7507"
streetAddress	string | null	"450 7th Ave"
locality	string | null	"New York, NY 10001"
website	string | null	"https://www.rotorooter.com/manhattan/"
rating	number | null	4.5
reviewCount	integer | null	28
categories	string | null	"Plumbers, Plumbing-Drain & Sewer Cleaning"
yearsInBusiness	integer | null	91
snippet	string | null	"From Business: When you need an emergency plumber…"
yellowPagesUrl	string | null	"https://www.yellowpages.com/…/mip/…"
searchTerm	string	"plumber"
location	string	"New York, NY"
scrapedAt	string (ISO)	"2026-07-01T10:00:00.000Z"

Fields not shown on a listing come back null.

Extra fields with Full profile mode (scrapeProfileDetails: true)

Field	Type	Description
description	string	Full business description
address	object	street, locality, region, postalCode, country
geo	object	{ lat, lng }
foundingDate	string	Founding year, e.g. "1935"
openingHours	array | string	Opening hours
areaServed	string	Service area, e.g. "New York, NY"
socialLinks	array	Profile links (LinkedIn, Twitter, YouTube…)
email	string | null	Email if listed (often absent)
categoriesFull	string	Full category list from the profile

---

💡 Proxy (required)

YellowPages blocks data-center IPs, so this actor uses residential proxy.

• Default: Apify residential — works out of the box.
• Optional: plug in your own residential proxy for higher volume.

Tip: use maxItems / maxPagesPerSearch to control cost.

⚖️ Compliance & Responsible Use

Collects publicly listed business directory data only. You are responsible for lawful use, anti-spam compliance for any outreach, and respecting YellowPages.com's Terms of Service and robots.txt.