A prospecting list template in Excel is one row per company and about 20 columns: who the company is, where it is, how to reach it, then follow-up (status, last contact, next step). Here's the template to copy, the Excel settings worth using, where to get the data, and how to import the file into your CRM.
In this post, you'll learn:
- The template's columns, with an example row
- Four Excel settings that save time
- Where to find businesses and their contacts, by industry
- When to use Excel and when to use CSV
- How to import the file into HubSpot, Pipedrive or Brevo
The prospecting list template
Create these columns in this order. The first 15 describe the company, the last 5 track your follow-up:
| Column | Example | What it's for |
|---|---|---|
| Company | Example Plumbing | Identify the row |
| Industry | Plumber | Segment the campaign |
| Address | 120 Main St | Mail, visits |
| ZIP code | 78701 | Filter by area |
| City | Austin | Filter by area |
| County | Travis | Split territories between reps |
| State | TX | Same, at a larger scale |
| info@example.com | First channel for outreach | |
| Other emails | joe@example.com | Reach the right person |
| Phone | (512) 555-0100 | Call |
| Mobile | (512) 555-0101 | Call or text |
| Website | example.com | Check and personalize |
| Google rating | 4.6 | Qualify |
| Review count | 212 | Qualify |
| Source | SphereScout export, Oct 2026 | Know where the lead came from |
| Status | To contact | Track progress |
| Last contacted | 10/26/2026 | Date the last touch |
| Next step | Call the owner | Plan the week |
| Follow-up date | 11/02/2026 | Don't drop the lead |
| Notes | Owner out on Mondays | Prepare the next call |
Keep one row per company and one value per cell. If a company has several emails, put the main one in Email and the others in Other emails.
The Source column looks minor. It becomes essential once you compare purchased lists, manual research and inbound leads.
With the columns in place, a few settings make the sheet faster to use.
Four Excel settings that save time
| Setting | Where to find it | What it does |
|---|---|---|
| Format as table | Ctrl+T | Adds a filter to every column |
| Freeze Panes | View | Keeps the headers visible |
| Drop-down list | Data, then Data Validation | Consistent statuses: To contact, Contacted, Interested, Meeting, Not interested |
| Remove Duplicates | Data | One row per company, on the Website or Phone column |
A SphereScout export arrives partly set up. The "Business Leads" sheet has a frozen header row and filters, and a second "Summary" sheet shows how many companies the file holds, how many have an email or a phone, and the export date.
Now for the data.
Where to find businesses and their contacts
Manual research works for up to about 50 companies: Google Maps gives you the phone and website, the company's site gives you the email. Scrapers go further, but you have to set them up, wait and clean the output.
A ready-made list skips those steps. SphereScout is a B2B data provider: business email lists of local businesses, collected from the public internet. You pick an industry and an area, preview the businesses, then export. Our business directory CSV guide walks through the file.
Emails aren't everywhere. In our October 2026 data, the share of US listings with an email depends heavily on the industry:

46.6% of tech and 42.5% of consulting listings publish an email, against 23.5% of restaurants and 20.5% in healthcare.
Phone numbers show on more than 85% of listings in most industries, from home services and plumbers to real estate and legal.
So keep the Phone column in every file. Each US business email list shows these counts before you buy, from accounting to marketing agencies.
Excel or CSV: which to use for what
Excel is for working: filtering, sorting, coloring, adding notes. CSV is for moving data: a plain table any tool can read.
Many CRMs take Excel files anyway:
| Tool | File types | Sheets | Good to know |
|---|---|---|---|
| HubSpot | .csv, .xlsx, .xls | One | UTF-8 if the file has non-English characters |
| Pipedrive | .csv, .xls, .xlsx | One per import | Up to 200,000 rows and 50 MB |
| Brevo | .csv, .xlsx, .txt | One | Comma, semicolon or tab; UTF-8 or Windows-1252 |
So delete the "Summary" sheet from a SphereScout export before importing it, or import the CSV.
CSV has traps of its own. Microsoft notes that Excel saves CSV files with the list separator from your Windows region settings, which isn't always a comma. Save as "CSV UTF-8" to keep accented names intact.
Every SphereScout list bought from a list page comes as both an Excel file and a CSV. Our CSV uses commas and UTF-8. To work in Excel, open the .xlsx. All that's left is the import.
How to import the file into your CRM
1. Keep a single sheet, or start from the CSV.
2. Import 20 rows first and check the result.
3. Map each column to a CRM field.
4. Pick the duplicate rule: website domain for companies, email for contacts.
5. Import the rest of the file.
For a SphereScout export, the mapping looks like this:

Before the first send, run the Email column through a verifier. Public addresses change between updates, and a high bounce rate hurts your sending domain. Our data enrichment guide covers the tools that fill the gaps, and our cold email guide the sequence that follows.
FAQ
What columns should a prospecting list have?
About 20, in two blocks. 15 columns describe the company (name, industry, address, emails, phones, website, rating, source) and 5 track follow-up (status, last contact, next step, follow-up date, notes).
Can I import an Excel file into my CRM?
Yes in HubSpot, Pipedrive and Brevo, if it has a single sheet. Delete any extra sheets first. For email tools and scripts, CSV is still the safest format.
How do I remove duplicates from a prospecting list?
Use Excel's Remove Duplicates command on the Website or Phone column before importing. Then set your CRM's duplicate rule to the domain or the email.
Do B2B emails have to follow CAN-SPAM?
Yes, the law makes no exception for business-to-business email. The FTC's compliance guide requires an accurate sender, an honest subject line, your postal address and a working opt-out honored within 10 business days.
Where can I get a free prospecting list?
SphereScout gives new accounts 100 free contacts, no credit card needed. Export them as Excel or CSV to test the format, then pick a plan. Our free email list post shows what's inside.
Final thoughts
Start from the template above, with one row per company and a Source column. Before importing, keep a single sheet or switch to CSV UTF-8, and test with 20 rows.
To fill the file, browse the US business email lists or buy a full database. For the bigger picture, see our guide to B2B lead generation.
No credit card ยท Export-ready CSV
Founder at spherescout.io with extensive experience in data engineering for the past 10 years.