Prospecting List Template for Excel: 20 Columns and CRM Import

A prospecting list template for Excel: 20 columns with an example row, four Excel settings, Excel vs CSV, and how to import it into HubSpot or Pipedrive.

Raphael Canyasse, Founder ยท 7 min

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
Email 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:

Share of US business listings with a public email address and with a phone number, by industry, from 47.7% email in education to 15.6% in auto and transport

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:

How the columns of a SphereScout export (Company Name, Address, Zipcode, City, State/Region, Primary Email, Primary Phone, Website, Categories) map to CRM fields

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

Raphael Canyasse

Founder at spherescout.io with extensive experience in data engineering for the past 10 years.