Business Directory CSV: Download Emails and Phones, Free or Paid

Where to download a business directory CSV, free or paid, which columns it has, how full they really are for US plumbers, and how to import it into a CRM.

Raphael Canyasse, Founder ยท 8 min

You can download a business directory CSV from two kinds of sources. City open data portals give free files of registered businesses, without phones or emails. Business email lists give each listing's phone, website and email where published: of 86,085 plumbers in the USA, 98% show a phone and 28.2% an email.

In this post, you'll learn:

  • Where to download a business directory CSV, free or paid
  • How to download one by industry and area
  • Which columns it has, and how full they really are
  • How to open it in Excel and import it into a CRM
  • How to use it in a first campaign without hurting your deliverability

Where to download a business directory CSV

Here are the main sources, from free to paid:

Source What you get Contact details Price
City open data Registered businesses with address and industry code None Free
Census County Business Patterns Counts of businesses by industry and county None, counts only Free
Online directories and Google Maps Listings to browse one by one Phone and website Free, but no export
Scraping tools What the scraper reaches Emails where websites publish them Tool cost plus your time
Business email lists Listings by industry and area Phone, website and email where published 100 free contacts, then from $49 a month

Free files exist, but they're built for other jobs. Los Angeles publishes its business tax registrations as a free CSV of 1,709,221 rows: name, address, industry code and start date, with no phone, email or website.

The Census Bureau's County Business Patterns counts establishments by industry and county, with 2023 as the latest year. It sizes a market, but you can't contact anyone from it.

I learned this the hard way in 2018. A Turkish friend needed US restaurant contacts for his olive oil business, and I ended up writing a scraper from scratch.

Scraping, deduplication, email checks and formatting each needed their own script. SphereScout, a B2B data provider, does that work once: business email lists of about 110 million businesses in 51 countries, collected from the public internet. Here's how to get a file from it.

How to download a business email list as a CSV

1. Pick an industry list

Each US business email list shows its counts before you pay. The plumbers list has 86,000+ businesses, 28.2% with an email and 98% with a phone, for $509 once:

SphereScout's US plumbers list page: 86,000+ listings, 28.2% with an email, 98% with a phone, 56.3% with a website, $509 one-time

The same counts exist for home services, restaurants, healthcare, real estate and the other US industries.

2. Check the sample

"View sample" shows real rows, with the email and phone masked. You can also get a 20-row sample CSV by email:

The masked sample of the US plumbers list: company, city and state, masked phone and masked email for ten plumbing businesses

3. Narrow it down

To target one area, use the dashboard. Pick a state, county, city or ZIP code, keep only businesses with an email, a phone or a website, and filter by rating, review count or open status.

On the Growth plan and up, a "Personal emails only" filter skips info@ and contact@. New accounts get 100 free contacts to test the file.

4. Export

The export is an Excel file by default, or a CSV if you choose it. Plans run from $49 a month for 5,000 contacts to $499 for 250,000. See the pricing.

Next, what's inside the file:

Which columns a business directory CSV has

Here are the columns of a SphereScout export:

Group Columns
Company Company Name, Categories, Website, Google Maps, Google Place ID
Location Address, City, County/Department, State/Region, Zipcode, Country
Email Primary Email, Email 2 to Email 5, All Emails
Phone Primary Phone, Phone 2 to Phone 5, All Phones, Mobile Phones
Social Facebook, Instagram, LinkedIn
Freshness First Seen, Last Seen

Through the API or the MCP server, an export can also add rating, review count, coordinates and opening hours. First Seen and Last Seen tell you when a listing was first and last found, which helps you spot stale records.

The file has no owner names, job titles, revenue or headcount. To add the decision-maker, see our test of data enrichment tools.

For a column-by-column template, see our guide to the prospecting list in Excel.

How full each column is

A column being there doesn't mean it's filled. Here's the share of 86,085 US plumber listings with a value in each:

Share of 86,085 US plumber listings with a value in each CSV column: phone 98.0%, address 67.1%, website 56.3%, email 28.2%, named email 19.4%, Facebook 19.4%, Instagram 11.6%, LinkedIn 2.8%

Almost every plumber shows a phone, but only 28.2% an email. Of those 24,246 emails, 16,736 (69%) are named addresses rather than info@ or office@.

A third show no street address. Google asks businesses that don't serve customers at their address to remove it, and plumbers usually work at the customer's place.

Email coverage depends on the industry more than on the provider:

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

It runs from 47.7% in education to 15.6% in auto and transport. Check the count for your industry before you plan an email-only campaign.

How to open the CSV in Excel or Google Sheets

Our CSV is saved as UTF-8 with a byte order mark. According to Microsoft, Excel then opens accents and special characters correctly with a double click.

If a CSV from another source shows garbled characters, open it from Data > Get Data > From Text/CSV instead. In Google Sheets, use File > Import.

Keep the original file untouched and work on a copy. Excel can turn phone numbers into plain numbers and drop the plus sign when you save.

How to import the CSV into a CRM

First decide what a row becomes. Each row is a business, so import it as a company or account with its email and phone, then map the columns:

CSV column CRM field
Company Name Company name
Website Company domain name (HubSpot) or Website
Primary Email Email
Primary Phone Phone
Address, City, State/Region, Zipcode Address fields
Categories Industry, or a custom property
Google Maps, Last Seen Custom properties

In HubSpot, Company Domain Name is the key that finds existing companies, and it only accepts the domain. Strip "https://" and any path from the Website column first.

Pipedrive takes XLS, XLSX or CSV files with a header row, up to 200,000 rows and 50 MB. Salesforce has its Data Import Wizard. In any CRM, import a test batch of 50 rows first, and tag every record with its source and export date.

How to use the CSV in a first campaign

Start with one segment, one industry in one area, and send a small batch first. Verify the emails before you send: Google asks bulk senders to keep the spam rate in Postmaster Tools below 0.3%, and bounces hurt your sender reputation too.

The CAN-SPAM Act makes no exception for business-to-business email. Identify yourself, include an opt-out, and honor it within 10 business days.

Build the file from your AI assistant

SphereScout has a remote MCP server, so assistants such as Claude and ChatGPT can search businesses, preview counts and export lists. In Claude Code, one command connects it:


claude mcp add --transport http spherescout https://mcp.spherescout.io/mcp

Then ask in plain language:


How many plumbers are there in Texas, and how many have an email?
Export the ones with an email as a CSV.

Searching and previewing are free; exports need a paid plan. The API documentation covers the same workflow in code.

Our cold email guide covers the sequence, and B2B telemarketing covers the calls. For a worked example in one industry, see MSP lead generation.

FAQ

Is there a free business directory for the USA?

Yes, but without contact details. City open data portals, such as Los Angeles's, publish registered businesses as free CSV files, and the Census Bureau publishes counts by industry. For phones and emails, start with 100 free contacts.

Is CSV or Excel better for a business list?

CSV for imports, Excel for review. Most CRMs and outreach tools take CSV files. Excel is easier for filtering and notes, but work on a copy so the phone numbers stay intact.

What columns should a business directory CSV have?

Name, location, email, phone, website and a freshness date. Categories, social links and a source URL help you segment and check records later.

Can I use a business directory CSV for cold email?

Yes, if you follow CAN-SPAM. The law covers B2B email: identify yourself, include an opt-out and honor it within 10 business days. Verify the emails first to protect your sender reputation.

How much does a business email list cost?

From $49 a month for 5,000 contacts. Each US industry list can also be bought once, for example $509 for the 86,000+ plumbers. New accounts get 100 free contacts.

Final thoughts

The best business directory CSV isn't the biggest one. It's the one whose columns are filled for your industry, and that your CRM can take without a cleanup.

Check the counts and the sample first, then test one segment before scaling. For the full playbook, 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.