The short answer
A lead list is a structured spreadsheet or CRM view of the companies and people you plan to contact, with the fields you need to reach and personalize: company name, website, industry, size, contact name, title, verified email, LinkedIn URL, a reason to reach out, a source and the date each email was last verified. Good lists are small, specific and refreshed regularly.
On this page
- The 15 Columns Every Lead List Needs
- A Lead List Template You Can Copy
- How to Build a Lead List in 5 Steps
- Cleaning a Lead List Before You Send
- Lead List Decay: How Fast Lists Go Stale
- Lead List Mistakes That Waste a Month
- Turning a Lead List Into Personalized Outreach
- Turn your lead list into personalized collateral in three steps
- FAQ
Key takeaways
Website is the key column: The company website is the cleanest key for deduping and the starting point for researching every account.
Add a 'why now' column: A list without a reason to reach out produces generic emails. Capture the trigger while you build the list.
Date every verification: Record when each email was verified. Re-check anything older than a few months before you send.
Clean before every send: Dedupe, remove role addresses and bounces, and suppress opt-outs every time you send, not once a year.
The 15 Columns Every Lead List Needs
A good lead list has four groups of columns: who the company is, who the person is, why you're reaching out, and how fresh the data is. Most lists stop after the second group, which is why most outreach sounds the same.
| Group | Columns | Why they matter |
|---|---|---|
| Company (5) | Company name, website, industry, employee count, country | Fit checks, deduping and research |
| Contact (5) | First name, last name, title, email, LinkedIn URL | Reaching the right person, and checking they're still there |
| Context (3) | Why now, source, tier | Personalization, compliance and priority |
| Hygiene (2) | Email status, last verified date | Deliverability and decay control |
Add phone only if you call. A direct dial or mobile column is worth it for teams that run calling blocks. Otherwise it's one more field to keep fresh.
A Lead List Template You Can Copy
Paste this header row into a new sheet. The example row uses a made-up company to show what good data looks like in each column.
company_name,website,industry,employee_count,country,first_name,last_name,title,email,linkedin_url,why_now,source,tier,email_status,last_verified
Halden Freight,haldenfreight.example,Logistics,220,US,Maya,Chen,VP Operations,[verified email],[profile url],Hiring three pricing analysts,Careers page,A,valid,2026-10-02
Why now is the column that pays. "Hiring three pricing analysts" gives you an opening line. "Logistics, 220 employees" gives you nothing to say.
Source protects you. Knowing where each record came from lets you answer a prospect who asks, and helps with GDPR transparency if you contact people in Europe.
Keep values consistent. Use one format for dates, one spelling per industry and plain domains without "https://". Clean data makes filtering, deduping and importing far easier.
How to Build a Lead List in 5 Steps
Building a lead list well is mostly about deciding what to leave out. For the full process with time estimates, see our guide to prospect list building.
- Write your ICP in one sentence. Industry, size, region and one trigger. Our ideal customer profile template helps.
- Pull accounts first. Decide which companies deserve outreach before you spend credits on contacts.
- Add one to three contacts per account. The likely buyer, a user who feels the pain, and perhaps their manager.
- Fill in context. For each account, note the trigger and where you saw it.
- Verify and tier. Check every email, then mark the top accounts as Tier A.
Use real sources. Contact databases, your CRM and LinkedIn are the usual inputs. Our guide to leads with contact info explains where that data comes from and the rules that apply.
Cleaning a Lead List Before You Send
Clean the list every time you send, not once a year. Each of these steps takes minutes in a spreadsheet and prevents most bounce and complaint problems.
- Dedupe by website. Company names vary ("Halden", "Halden Freight Inc."). Domains don't.
- Dedupe contacts by email. Then check that two reps aren't working the same person.
- Remove role addresses. info@, sales@ and support@ rarely reach a buyer.
- Suppress opt-outs and customers. Keep a suppression list and check every new list against it.
- Check catch-all domains. These accept every address, so "valid" proves little. Send carefully or find another route in.
- Spot-check titles. Open ten LinkedIn profiles. If two have changed jobs, the whole list needs a refresh.
Verify last. Run the verifier after cleaning, right before the send, so the results are as fresh as possible. Our guide to verified B2B leads covers what each verification status means.
Lead List Decay: How Fast Lists Go Stale
Every lead list starts decaying the day you build it. People change jobs, companies rebrand and inboxes close.
Email addresses go first. ZeroBounce's 2026 Email List Decay Report, based on the addresses it verified during 2025, found that at least 23 percent of email lists degrade each year. That's roughly a quarter of a list in twelve months.
Job changes drive most of it. The US Bureau of Labor Statistics put median tenure with a current employer at 4.1 years in January 2026, so a steady share of any contact list moves on every year.
| Field | Why it decays | Refresh rule |
|---|---|---|
| Job changes, closed inboxes | Re-verify if older than a few months | |
| Title | Promotions, reorganizations | Spot-check on LinkedIn before Tier A outreach |
| Company | Acquisitions, rebrands, closures | Check the website still resolves |
| Why now | Triggers expire | Treat as stale after a month or two |
Build smaller lists more often. A list sized for one month of outreach decays far less before you use it than a list sized for a year.
Lead List Mistakes That Waste a Month
Most lead list problems are set in the first hour of building. These are the ones that cost the most later.
- Starting with contacts, not companies. You burn credits on people at accounts that never fit. Choose accounts first.
- One giant list for the year. By the time you reach row 2,000, the top rows have already decayed. Build monthly.
- No owner column on shared lists. Two reps email the same buyer on the same day, and both look careless.
- Mixing sources without a source column. When bounces spike, you can't tell which source caused them.
- Skipping the suppression check. Emailing someone who opted out is a compliance problem, not just an awkward moment.
Fix it in the template. Most of these disappear if the source and last verified columns exist from day one, plus an owner column on any list a team shares.
Turning a Lead List Into Personalized Outreach
A clean lead list is a starting point. The reply comes from a message that shows you understand each account, and that takes research per row, which is where most teams fall back to mail merge. Our guide to personalized outreach at scale covers the options.
Keep the research per row. For each account, read the website, note what changed and connect it to one problem you solve. Then write a short email around it.
Or import the list. In Edithly, click Import CSV in History, match your headers and import the rows. Press play on a row and Edithly reads that prospect's website and builds the material for that account, such as a pitch deck, one-pager or landing page on your brand. You can also call the API from Clay, Apollo, HubSpot or Zoho CRM.
Finish the data work first. Edithly doesn't add or verify emails, so clean and verify the list before you import it. See how bulk list import works, or read the guide to bulk personalized sales collateral from a CSV.
How Edithly does it
Turn your lead list into personalized collateral in three steps
Import the lead list you already have, from Apollo, Clay or your CRM. For every row you run, Edithly reads that prospect's website and builds a visual, such as a one-pager or pitch deck, on your brand.
- 1
Click Import CSV in History
Open the History table, click Import CSV and upload your lead list. Download sample CSV shows the expected format if you're starting from scratch.
- 2
Match headers, then Import rows
Use Match CSV headers before import to map your columns, such as company name and website, then click Import rows.
- 3
Press play on each row
Press play on a row to build its one-pager, deck or landing page. To automate it, call the Edithly API from Clay, Apollo, HubSpot or Zoho CRM.
Import CSV
Ready
- Prospect co.
- Website URL
- Contact name
- Materials
- Generate
- By hand
- 20 to 30 minutes per row to research and write
- With Edithly
- A couple of minutes per row
Frequently asked questions
What should be included in a lead list?
At minimum: company name, website, industry, employee count, location, contact first and last name, title, email, LinkedIn URL and the email's verification status. The most useful extras are a 'why now' trigger, the source of each record, a priority tier and the date the email was last verified. Those turn a contact sheet into a working list.
How often should you update a lead list?
Re-verify emails right before any send if they're more than a few months old, and review the whole list at least quarterly. People change jobs constantly: the US Bureau of Labor Statistics put median tenure with a current employer at about four years in January 2026. Remove bounces and opt-outs after every send.
How many leads should be on a lead list?
As many as you can research and contact well in about a month. For one rep sending genuinely personalized outreach, that's often a few dozen new accounts a week. Bigger lists go stale before you reach the bottom, and they push you toward generic messages. Build smaller lists more often.
Where can I get a lead list?
Build it from your own CRM, a contact database such as Apollo, ZoomInfo, Lusha or Cognism, LinkedIn Sales Navigator for finding people, or a mix combined in an enrichment tool such as Clay. Be cautious with one-off lists sold by unknown vendors, which are often stale, shared with many buyers and poorly sourced.
Can I import my lead list into Edithly?
Yes. In History, click Import CSV, match your CSV headers and click Import rows. Then press play on each row to generate its material, or automate generation through the API from Clay, Apollo, HubSpot or Zoho CRM. Edithly doesn't add or verify emails, so do that in your data tool before you import.