Import local business leads into Apollo
Yes. Pick Apollo under Export in 67Leads and the CSV comes out with 9 columns named the way Apollo names its fields, the owner's name already split into first and last. Rows without an email are kept, because the tool accepts them. 7,056 of the 150,200 US local businesses we list carry an email confirmed by an SMTP mailbox check.
Updated . Counts are computed from the warehouse when this page is served.
Get 67 leads freeOpens the app with the Apollo layout chosen under Export. No card. Search is free with contacts masked.
The Apollo columns
Apollo is a B2B database and sequencer. The file has these columns, in this order. Rating and review counts are left out of every tool layout.
| Column | What it holds |
|---|---|
First Name | The owner's first name, split from the owner name where the company's site gives one; blank when it does not. |
Last Name | The owner's last name, split the same way; blank for a single name. |
Email | The email address read from the company's own website. |
Company Name | The business name. |
Company Website | The company's website, where it has one. |
Corporate Phone | The main phone number in +1 format. |
City | City. |
State | Two-letter state code. |
Industry | The trade the business was graded into. |
Import steps in Apollo
- In Apollo, open People, then Import, then CSV, and choose Select CSV File under Import contacts.
- Map each column header to its Apollo field: First Name, Last Name, Email, Company Name, Company Website and Corporate Phone are named as Apollo names them.
- Pick options such as adding the contacts to a list, then choose Import.
What Apollo's import requires
- You need permission to bulk import contacts by CSV; an Apollo admin can grant it.
Niches that suit Apollo
Live counts. Each link opens that niche in the app with the Apollo layout chosen.
| Niche | Companies | |
|---|---|---|
| Tree service companies | 6,187 with a verified email | Open in the app with the Apollo layout |
| HVAC contractors | 430 with a verified email | Open in the app with the Apollo layout |
| Insulation contractors | 314 with a verified email | Open in the app with the Apollo layout |
| Roofing contractors | 75 with a verified email | Open in the app with the Apollo layout |
| Plumbers | 40 with a verified email | Open in the app with the Apollo layout |
| Electricians | 8 with a verified email | Open in the app with the Apollo layout |
Filters worth setting
- HubSpot and Apollo both match contacts on email, so the verified-email filter keeps duplicates down on re-imports.
- Industry carries the trade, so a CRM view or list by niche needs no cleanup.
- A lead you already own re-downloads free, so exporting again in another layout costs nothing.
Questions
Yes. Pick Apollo under Export in 67Leads and the CSV comes out with 9 columns named the way Apollo names its fields, the owner's name already split into first and last. Rows without an email are kept, because the tool accepts them. 7,056 of the 150,200 US local businesses we list carry an email confirmed by an SMTP mailbox check.
First Name, Last Name, Email, Company Name, Company Website, Corporate Phone, City, State, Industry.
No. The headers follow Apollo's own import documentation, linked on this page. Check the mapping screen Apollo shows anyway; it is quick.
Each row says valid, risky or unverified. 7,056 addresses (12% of those on file) were confirmed by asking the mail server whether the mailbox exists. If an email we marked valid hard-bounces, tell us and we credit it back. Addresses marked risky or unknown carry no such guarantee.
Searching is free with contacts masked and no daily cap, no account needed. Sign up and your first 67 leads export free, no card. Paying unlocks the rest. Plans: $6.70 for 1,000 credits, one time, no subscription; $67 a month for up to 500 new leads a day, no credits; $677 once for lifetime access, 500 new leads a day, limited to 100 seats. Full refund within 7 days of your first payment.
Other integrations
InstantlySmartleadlemlistGoHighLevelClayHubSpotAll integrations
PricingLead tool pricing comparedHow the data is builtHTTP API