How to Build a B2B Lead List from Scratch

Whether you sell software, services, or supplies, pipeline starts with knowing who to talk to. Buying a stale database feels fast until bounce rates spike and your reps waste hours on wrong numbers. Building a list yourself takes more upfront thought, but you control fit, freshness, and format—so every row earns its place in your sequence or dialer.

What Makes a Good Lead List?

Quality beats quantity every time a human has to work the file. A good list is targeted: same industry or use case, geography that matches your coverage, and rough company size signals that line up with your offer. Spray-and-pray lists create noise; tight ICP-aligned lists create conversations.

It is also complete enough to act on. Email and phone matter for outbound; address and website matter for routing, enrichment, and legitimacy checks. Social profiles help research and personalization. If half your rows are missing contact paths, you are not building a list—you are building homework.

Fresh, accurate data means you captured it recently and normalized it (consistent phone formats, full URLs, no stray line breaks in cells). Finally, the file should be formatted for your tools: column headers your CRM expects, UTF-8 encoding, and deduplicated business entities so imports do not create duplicate deals or contacts.

Where to Find B2B Leads

Most teams think LinkedIn first—and rightly so for titles and org charts. Google Maps and industry directories surface local operators and niche verticals that LinkedIn under-represents. The gap many marketers miss is Yelp: millions of brick-and-mortar and service businesses with structured listings, categories, ratings, and review volume—signals of real operations, not ghost companies.

For local B2B—agencies selling to restaurants, SaaS for retail, vendors calling on contractors—Yelp is underrated. Search is already filtered by city and category; listings often include phone, address, website, and sometimes email. You are not guessing who is “open for business”; you are pulling from a directory people actively maintain.

Combine Yelp with LinkedIn for org mapping and with Maps for coverage checks, and you get redundancy without paying for the same record three times. When you are ready to turn Yelp pages into rows you can sort and import, Yelp Lead Scraper runs in Chrome and exports straight from search results—no manual copy-paste marathon.

What Data to Collect

Minimum viable rows usually include business name, a path to a decision-maker (even if that starts as “owner” or a role you will verify later), email when available, phone, full address, and website. Add industry or category from the source so you can segment campaigns. Company size indicators from public data—review count, star rating, years in business if shown—help reps prioritize without a full firmographic subscription.

Social links (Instagram, Facebook, LinkedIn, and others when listed) speed up research and make personalization honest. Pulling all of this by hand across hundreds of listings is how lists die in the backlog. Yelp Lead Scraper is built to extract business leads from Yelp search results automatically: emails, phones, addresses, websites, and social profiles where the listing exposes them, so your base layer of data lands in one pass.

For a deeper playbook on strategy and targeting on Yelp, see our Yelp lead generation guide.

Building Your List: Step by Step

1. Define your ICP. Write down industry, geography, deal size band, and disqualifiers. If the row does not match, it does not go in the list.
2. Choose data sources. Match source to motion: Yelp and Maps for local density, LinkedIn for roles, directories for regulated niches.
3. Extract data at scale. For Yelp, install Yelp Lead Scraper from the Chrome Web Store, run your searches, and let the extension walk results while you focus on targeting—not transcription.
4. Clean and deduplicate. Normalize phones and domains, merge obvious duplicates, and drop rows with no viable contact method unless enrichment is planned.
5. Segment. Split by category, city or ZIP, rating band, or review volume so messaging and offer can stay specific.

This workflow keeps your file honest: every segment ties back to a hypothesis you can test in outreach.

Organizing Your Lead List

A practical CSV structure uses stable headers—business_name, email, phone, address_line, city, state, zip, website, category, rating, review_count, source_url—so imports do not break. Keep one business per row unless your CRM explicitly wants person-level expansion later.

For CRM import, map columns once in HubSpot or Salesforce (or your tool of choice), save the mapping as a template, and re-use it on weekly pulls. Use tags or custom fields for campaign, territory, and lead source (“Yelp – Austin – HVAC”) so reporting stays clean six months out.

Step-by-step export mechanics and column details are covered in how to export Yelp search results to CSV—useful when you are ready to move from list concept to actual file.

Enriching Your Leads

Your first pass is rarely the last. Enrichment means layering data from other sources: confirming the right contact on LinkedIn, appending firmographics from a data vendor, or scraping the company site for a better generic inbox. Email verification tools reduce hard bounces before you burn domain reputation.

Cross-reference Yelp listings with LinkedIn company pages and job titles when the buyer is not the storefront name on the door. Treat enrichment as a quality gate: better to drop a dubious row than to spam a shared inbox or a long-closed location.

Putting Your List to Work

Lists exist to fuel motion. Cold email works when segments are tight and copy acknowledges real business context—category, city, and a specific observation from their site or reviews beat generic templates. Our cold email guide goes deeper on structure and compliance-minded habits.

Cold calling still wins for high-value local deals when you have accurate numbers and time zones. Social selling lets you warm touches before the ask. For paid demand, upload hashed lists (where policy allows) to build custom audiences and lookalikes so outbound and ads reinforce the same ICP.

Measure by reply rate, meeting rate, and pipeline created—not raw send volume. A shorter, cleaner list almost always outperforms a bloated one.

Start Building from Yelp Today

You do not need an enterprise data contract to begin. Define your ICP, pull structured leads from directories your buyers actually use, then clean, segment, and enrich before you load the CRM. When Yelp is part of your sourcing mix, a Chrome extension that exports search results to CSV removes the manual bottleneck between discovery and outreach.