How to Build a Prospect List From Scratch (Template + Columns)

Includes: Prospect list spreadsheet template — columns, filters, and the priority formula template
The short answer

A prospect list is your working set of accounts and named contacts that fit your ICP, with columns for research and outreach status. This page gives you the exact spreadsheet template — columns pre-built, a priority formula, and the filter that separates a list worth calling from a list that wastes your day.

A prospect list is your working set of accounts and named contacts that fit the ICP — not a random download, but a spreadsheet you actually work. It is the raw material of every touch, sequence, and cadence you run. While the BDR builds lists of net-new accounts to open, the SDR builds lists within the accounts the company already works. Both use the same columns and the same filter: it fits the ICP, and there's a reason to reach out now.

The columns your list needs

Here is the asset — the template, column by column:

Account columns: Company name · Industry · Employee count · Revenue band (if known) · Fit score (1–5 against your ICP) · Trigger or reason to reach out now.

Contact columns: First name · Last name · Title · LinkedIn URL · Email · Phone · How you found them (referral, event, tool) · Decision-maker? (Y/N).

Outreach columns: Channel (email / call / LinkedIn) · First touch date · Touches sent · Last reply date · Status (new / contacted / replied / meeting booked / dead) · Notes.

The priority formula. Add a column Priority = Fit score × Trigger (0 or 1) × Recency. Rank the list by it and work the top every day. A perfect fit with no trigger is a someday account; a fit with a trigger is a this-week account.

The filter: fit AND a reason to reach out now

The one filter that separates a good list from a time-sink is two-part: does the account fit your ICP, and is there a reason to reach out now? Size and industry alone are not fit — a huge conglomerate with no matching division is still irrelevant, and a perfect fit locked into a three-year competitor contract is not a near-term prospect. The accounts worth your time clear both gates, which is exactly what the sort challenge above tests.

The trap: the list that feels productive

Downloading 5,000 accounts feels like progress and produces nothing. A good list is small, ranked, and worked daily. Build it in the shape above, keep the columns honest, and you convert a market into accounts you can actually reach — the whole difference between prospecting and hoping. If a name doesn't clear fit AND trigger, it doesn't earn a touch.

Start here

Your list is built. The sharper your filter, the better the list — next, what an ideal customer profile actually is, and how to define yours so your list only ever contains accounts worth reaching.

Practice this

Pass this challenge (score 3+ of 4) to mark the lesson complete in your progress.