How to make prospect list in sales work: write the fit rules, choose the columns, source the names, verify the data, then keep the file clean.

What is a prospect list in sales?

A prospect list is a working file of the companies and named people your sales team decided are worth contacting, with enough data on each row to start a real conversation. Learning how to make prospect list in sales work means treating that file as a build with rules, not a pile of exported names.

Every row should answer three questions. Who is this company, who is this person inside it, and why are they on the list this month? A prospecting list that cannot answer the third question produces generic outreach, which is the most common reason a campaign gets no replies.

The sales prospecting list is the input to everything downstream. Prospecting is the activity, the list is the artifact prospecting produces, and the sequence your sales reps run is only ever as good as the rows in it.

Prospect list vs lead list vs account list

Sales teams use these three words as if they mean the same thing, then argue about who owns which file. They are different objects with different jobs.

The practical difference is who starts the conversation. On a prospect list you do, so the burden of relevance is yours. On a lead list they did, so speed matters more than research. Our entry on business leads covers the second case, and lead sources covers where inbound records come from.

Why a sales prospecting list is worth the effort

A sales team without a prospecting list still makes calls. It just makes them at whoever was on screen that morning, which is why prospecting feels like luck and why results swing from month to month without anyone being able to explain it.

• Time goes to the right accounts: sales reps spend their hours on potential customers who match the profile, instead of researching companies that were never going to buy.
• The work is repeatable: a new rep inherits a list and a set of rules, not a folder of somebody else's browser tabs.
• Outreach gets specific: a reason column forces a real opening line, so the first message sounds like it was written for that company.
• Coverage is visible: you can see which segments of your market your sales team has contacted and which have never been touched.
• Results become diagnosable: when a sales campaign underperforms you can separate a weak list from a weak message.
• Forecasting improves: prospects worked per week is a number a sales leader can plan against, unlike activity counts.

The prospecting list is also where marketing and sales meet. Marketing supplies segments and signals, sales supplies the reality of who actually answers, and the file is the shared object both teams argue over productively.

Know the product and the buyer before you build

Every strong sales prospecting list starts with someone who can explain, in one sentence, which problem the product removes and for whom. Without that, the fit rules are guesses and the list becomes a list of companies rather than a list of prospects.

Three questions are enough to get there. Which job does a customer stop doing after they buy? What has to be true about a company for that job to be expensive? And who inside the company feels the cost of it every week?

Answer those from your own closed won deals and from recent customer conversations, not from the product page. The wording your customers use is also the wording your outreach should use, and it rarely matches the internal feature names.

This is also where you decide what you will not sell to. A product that needs a dedicated admin does not suit a ten-person company, however well the firmographics match.

How to make prospect list in sales, step by step

The order below matters. Most bad lists come from doing step three before step one, then trying to add fit rules to a file that already has two thousand rows in it.

1. Write the fit rules down

   Turn your ideal customer profile into filters a colleague could apply without asking you: industry, size, region, technology, and the signals that say now.

2. Choose the columns before the names

   Decide which fields every row must carry and which are optional, so nobody fills a spreadsheet with whatever the tool happened to export.

3. Build the account list first

   Find the potential customers that match the fit rules, check each one against a disqualifier list, and stop when you have enough potential customers for one month of work.

4. Find the people inside each account

   Map the roles you need per account, then name them. One buyer per company is rarely the whole decision.

5. Source and verify the contact data

   Pull emails and phone numbers from your tools, verify them, and mark anything you could not confirm as unverified rather than guessing a pattern.

6. Add the reason and the tier

   Write one line per row saying why this person now, and sort rows into tiers so your best research goes to the accounts worth it.

7. Import to the CRM and set a refresh date

   Map columns to CRM fields, dedupe against existing records, assign owners, and book the date you will clean the list again.

Step one in detail: fit rules a stranger could apply

A fit rule is only useful if two people building the list independently would produce nearly the same accounts. "Mid-market SaaS" is not a rule. "Software companies, 50 to 500 employees, United States or Canada, running a CRM, with at least two sales reps on the team" is a rule.

Write the rules as three groups, and keep each group short enough to remember:

• Firmographics: industry, employee count, revenue band if you can see it, country, and the number of locations.
• Technographics: the systems they already run, since those often decide whether you fit at all. See technographics.
• Disqualifiers: the conditions that make an account a waste of time, written as plainly as the fit rules.

Disqualifiers do more work than most teams expect. Existing customers, open opportunities, companies in a partner's territory, industries you cannot legally serve, and accounts a rep already burned this quarter should all be excluded before anyone opens a sequence.

If the rules do not exist yet, build them from closed won deals rather than from the marketing deck. Our guide to the ideal customer profile covers how to derive them from accounts you already serve well.

Prospect list columns, field by field

Columns decide what your sales reps can personalize and what your reporting can answer later. Add them deliberately: every optional column is a cell somebody has to fill or leave conspicuously empty.

Core columns every row must carry

Columns that earn their place on some lists

• phone: direct dial where you have it, switchboard where you do not, marked clearly as which.
• trigger and trigger_date: the event that put the account on the list and the day it happened.
• tier: A, B or C, so research effort follows account value.
• owner: the rep responsible, filled before the first send, never after.
• tech: the specific systems the account runs, when your pitch depends on them.
• last_touch and next_step: the two fields that keep a spreadsheet honest between CRM syncs.
• notes: free text, kept short, and never used to store a fact that deserves its own column.

Resist columns you will not maintain. A field that is empty on four rows in five tells your sales reps that the prospecting list is unreliable, and they will stop trusting the columns that are filled.

Where the names come from in sales prospecting

No single source produces a good list. The usable approach is to pick a primary source for volume, then a second and third to confirm and enrich what the first one returned.

On the professional network side, saved searches turn a one-time build into a feed. LinkedIn states that Sales Navigator users can save a total of 50 lead searches and 50 account searches, and that new matches arrive as weekly emails and as homepage alerts.

That turns list building into a standing job rather than a quarterly panic. Our guide to LinkedIn Sales Navigator covers the filters in detail, and LinkedIn prospecting covers what to do with the names once the alert arrives.

Whatever you use, record the source on the row. When bounce rates spike or replies dry up, the source column tells you which supplier to fix instead of forcing you to rebuild everything.

How many people to name per account

One name per company is the default and it is usually wrong. B2B decisions involve a group, and the person who answers first is rarely the person who signs.

• The owner of the problem: the manager whose numbers suffer when the problem is unsolved. Usually the best first message.
• The user: the person who would live in your product daily. They confirm whether the problem is real.
• The budget holder: one or two levels up, contacted with a different message about outcome and risk.
• The blocker: security, legal, IT or procurement. Worth naming early even if you write to them last.

Two to four names per account is a workable default for mid-market lists, fewer for very small companies and more for enterprise. Whatever you pick, keep one row per person, never several names crammed into one cell.

The tools a prospect list build needs

This page does not rank vendors or quote prices. These are the tool categories a sales prospecting list depends on, and most teams can start with three of them.

• A search and filtering tool: finds potential customers by firmographics and finds the right people inside them.
• A contact data provider: supplies emails and phone numbers, and fills gaps in company information.
• An email verification tool: confirms an address exists before it costs you a bounce and time spent chasing.
• Enrichment, by tool or by API: keeps company information current without manual research. See data enrichment API.
• A CRM: holds the record, the owner and the history once prospects become leads you are working.
• A sequencing tool: runs the touches and writes activity back, so the prospect list stays honest.

Tools speed up a good process and accelerate a bad one just as effectively. If the fit rules are vague, more information from more tools produces a longer list of the wrong prospects, not better leads.

Segmenting by trigger, not just by industry

Fit tells you who could buy. A trigger tells you who might buy now. Segmenting the list by trigger is what lets a small team send fewer, better messages.

Triggers age badly. A funding round from last year is background, not a reason to write. Keep a trigger_date column and let rows fall back to the untriggered pool when the window closes, rather than letting a stale reason go out in a live email.

Buying signals collected at scale are their own category of data. Our entry on B2B intent data explains what those feeds do and do not tell you.

Verifying emails and phone numbers

Verification is not optional housekeeping. Sending to a file you have not checked is the fastest way to damage the sending domain you spent months warming up.

Treat the output as three buckets. Verified addresses go into email sequences, risky addresses go to the professional network or the phone, and invalid addresses leave the file before the first send. Guessing an address from a pattern you saw on two other rows counts as unverified, not as verified.

If the list is for a new sending domain, verification and a proper email warm up belong in the same week. Filling gaps in company and role data is a separate job, covered in lead enrichment.

How big should a prospect list be per sales rep?

There is no correct number, and any figure you copy from a vendor page was measured on somebody else's funnel. Calculate it instead, using rates you have actually observed.

The second half of that calculation is the one teams skip. A cadence with eight touches across three channels takes real minutes per prospect, and a list that needs more hours than the week contains will simply be worked badly. See sales cadence for how touch counts add up.

A practical habit: keep an active list sized to about a month of work, plus a larger backlog that nobody touches until the active list is cleared. Sales reps work one file, and the backlog stays cold until it is refreshed.

Tier the list so effort follows value

Not every prospect deserves the same research. Tiering makes that explicit rather than leaving it to whoever is having a busy morning.

• Tier A: strong fit plus a live trigger. Individual research, several named people, multi-channel touches, personal messages.
• Tier B: strong fit, no trigger yet. Segment-level personalization, lighter cadence, watched for signals.
• Tier C: plausible fit, thin data. One templated touch at most, or hold until a signal appears.

Review the tier of a prospect when the trigger changes, not on a schedule. A Tier C account that just posted a job for the role you sell to is a Tier A account that afternoon.

Keeping the sales prospect list clean

Business data decays on its own, and it takes prospects with it. People change jobs, companies rebrand, domains move, titles get renamed, and the row that was accurate in March quietly stops being accurate in July.

Keep a suppression list next to the prospect list and check every import against it. Opt-outs, current customers, open opportunities and accounts a partner owns belong there permanently. Removing a row from the prospect list is not enough, because the next import will bring it straight back.

Record disqualification reasons too. "Wrong size", "no budget this year" and "uses a competitor on a three-year contract" are different outcomes, and the third one is a date in your calendar rather than a dead row.

Importing the list into your CRM

The import is where a tidy spreadsheet becomes duplicate records. Two decisions prevent most of the damage: which field is the unique identifier, and whether the import creates records or updates them.

HubSpot's documentation states that import files must be CSV, XLSX or XLS with a single sheet, that a unique identifier is what lets an import update existing records instead of duplicating them, and that email is the identifier used for contacts. It also publishes row and file size limits that differ by subscription tier.

After the import, the spreadsheet stops being the source of truth. Keep it as the build record if you like, but status, owner and activity live in the CRM from that point on.

Build, buy, or blend

Buying data is normal. Buying a finished list is the risky part, because a list assembled for sale was almost certainly assembled for your competitors too, and it carries none of your fit rules or research.

• Build: slowest per row, highest relevance, and the research stays with your team. Best for Tier A accounts.
• Buy the data, not the list: subscribe to filters and contact data, then apply your own rules, research and verification on top.
• Blend: the common answer. Providers give coverage, your team supplies the reason each row exists.

Before you buy, sample it. Take fifty rows, verify the emails yourself, check ten titles against public profiles, and see how many companies you would have excluded under your own disqualifiers. That test tells you more than any coverage claim. Our entry on B2B data covers what the categories actually contain.

Consent and the rules that apply

A prospect list is personal data about working people, and three sets of rules usually touch it at once.

• United States email: the FTC states that CAN-SPAM requires accurate header information, a subject line that is not deceptive, a valid physical postal address and a clear opt-out that you honor within ten business days.
• United States calling: the FTC states that most phone calls to a business made with the intent to solicit sales from that business are exempt from the Do Not Call provisions. Company-specific requests still bind you.
• European prospects: GDPR Article 14 covers data you did not collect from the person. It requires you to tell them, normally within one month of obtaining the data or at your first communication with them.
• California residents: the state Attorney General describes rights to know what a business collected, to delete it, and to opt out of the sale or sharing of personal information.

The operational version is short. Record where every row came from, keep the suppression list current, make opting out easy in every message, and stop immediately when someone asks. None of this is legal advice, and rules differ by state and country.

A sales prospecting checklist before first contact

Run this checklist on a sample of rows before anyone sends anything. It takes minutes and it catches the errors that waste weeks of sales time.

• Is the company still trading? Check the site loads and the domain has not moved. Dead domains bounce and skew every later number.
• Is this person still there? Compare the title on the row against their public profile before you contact them.
• Does the account pass the disqualifiers? Existing customer, open opportunity, partner territory, or a region you cannot serve.
• Is the email verified? Anything marked risky or unverified stays out of the sending list.
• Is there a reason on the row? One line, specific to the company, that a sales rep could read aloud on a call.
• Is the trigger still fresh? If the date has aged past the useful window, the prospect moves back to the untriggered pool.
• Is the right person on the row? The title should own the problem, not merely sit near it.
• Is the row owned? An owner and a next step, or the prospect will sit untouched.
• Is it deduped? One row per person, and no colleague already contacting the same account.

Sampling twenty rows is usually enough. If more than a couple fail, the problem is upstream in the source or the fit rules, and fixing the sample by hand only hides it.

Turning the prospect list into outreach

A finished prospecting list is not a campaign. Before the first contact, decide which channel each tier gets, how many touches each prospect receives, and what happens when nobody replies.

Feed results back into the list, not just into the CRM. Bad titles, wrong companies and "please contact my colleague" replies are all corrections to your fit rules, and they are worth more than the individual reply. See outbound lead generation for how the campaign around the list is run.

How to tell if the list is working

Judge the prospecting list separately from the message. If replies are poor, the two possible causes are a badly chosen list of prospects and a badly written message, and they need different fixes.

Track those by source and by tier from the first campaign. A list that looks mediocre overall is often one strong source and one weak one averaged together, and you cannot see that without the source column.

Leads that respond still have to be qualified before they count as pipeline. Our guide on how to qualify sales leads covers the conversation that follows a positive reply.

Common sales prospecting list mistakes

• Building the list before the fit rules: two thousand rows that nobody can defend, and no way to prune them.
• One name per company: the decision involves a group, and your single contact may be the wrong one.
• Guessing email patterns: it works often enough to be tempting and fails often enough to hurt deliverability.
• No source column: when quality drops you cannot tell which supplier caused it.
• Stale triggers: opening a message with news from eleven months ago reads worse than no personalization.
• Free text where a picklist belongs: industry written six ways makes segment reporting impossible.
• A list nobody owns: unowned rows are worked by nobody and cleaned by nobody.
• Treating volume as progress: rows loaded is not rows worked, and only the second number matters.
• No suppression list: customers and opt-outs quietly return with every new import.

Building the prospect list template in Excel or Google Sheets

Most teams build the first version in a spreadsheet, and that is fine. A free Excel or Google Sheets file is faster to change than a CRM view, and it is easier to hand to a colleague who has never seen your sales tools.

A few settings turn a spreadsheet into something a sales team can manage without corrupting it:

Keep the spreadsheet as a staging area, not as the system of record. Once rows are imported, the CRM holds status and activity, and the sheet is only used to build the next batch of prospects.

A prospect list template you can copy

The prospect list template below was written for this page. It is a header row plus one filled row, with placeholders in double braces, so you can paste it into a spreadsheet and start with the columns already in the right order.

Two habits make the difference once it is in use. Keep email_status honest, and never leave reason blank on a Tier A row. Everything else in the file can be imperfect without doing much harm.

company,domain,industry,employees,country,contact_name,title,linkedin_url,email,email_status,phone,source,trigger,trigger_date,tier,owner,status,last_touch,next_step,next_step_date,reason
{{company}},{{domain}},{{industry}},{{employees}},{{country}},{{contactName}},{{title}},{{linkedinUrl}},{{email}},verified,{{phone}},{{source}},{{trigger}},{{triggerDate}},A,{{ownerName}},new,,{{nextStep}},{{nextStepDate}},{{whyThisRowNow}}

Frequently asked questions