Import local business leads into HubSpot
Yes. Pick HubSpot under Export in 67Leads and the CSV comes out with 10 columns named the way HubSpot names its fields, the owner's name already split into first and last. Only rows with an email go into this layout, and they are filtered before any credit is counted. 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 HubSpot layout chosen under Export. No card. Search is free with contacts masked.
The HubSpot columns
HubSpot is a CRM. The file has these columns, in this order. Rating and review counts are left out of every tool layout.
| Column | What it holds |
|---|---|
Email | The email address read from the company's own website. |
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. |
Company name | The business name. |
Phone number | The main phone number in +1 format. |
Website URL | The company's website, where it has one. |
City | City. |
State/Region | Two-letter state code. |
Postal code | ZIP code. |
Industry | The trade the business was graded into. |
Import steps in HubSpot
- Start a contacts-only import from one file in HubSpot.
- Upload the 67Leads CSV. HubSpot matches each column header to a contact property, and column order does not matter.
- The headers are HubSpot's default property labels (First name, Phone number, Company name, Website URL, State/Region), so each should find its property; check the matches and finish.
What HubSpot's import requires
- Email is the one required column for contacts, and it is what updates an existing contact instead of creating a duplicate.
- One sheet with a header row and fewer than 1,000 columns; UTF-8 for accented names.
- File and row limits depend on the HubSpot plan, from 20 MB a file on the free tools.
Niches that suit HubSpot
Live counts. Each link opens that niche in the app with the HubSpot layout chosen.
| Niche | Companies | |
|---|---|---|
| Tree service companies | 6,187 with a verified email | Open in the app with the HubSpot layout |
| HVAC contractors | 430 with a verified email | Open in the app with the HubSpot layout |
| Insulation contractors | 314 with a verified email | Open in the app with the HubSpot layout |
| Roofing contractors | 75 with a verified email | Open in the app with the HubSpot layout |
| Plumbers | 40 with a verified email | Open in the app with the HubSpot layout |
| Electricians | 8 with a verified email | Open in the app with the HubSpot 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 HubSpot under Export in 67Leads and the CSV comes out with 10 columns named the way HubSpot names its fields, the owner's name already split into first and last. Only rows with an email go into this layout, and they are filtered before any credit is counted. 7,056 of the 150,200 US local businesses we list carry an email confirmed by an SMTP mailbox check.
Email, First name, Last name, Company name, Phone number, Website URL, City, State/Region, Postal code, Industry.
No. The headers follow HubSpot's own import documentation, linked on this page. Check the mapping screen HubSpot 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
InstantlySmartleadlemlistGoHighLevelClayApolloAll integrations
PricingLead tool pricing comparedHow the data is builtHTTP API