Email → to Emaillowercaseddavid.garcia@meridian.example.com
Mobile Phone → to Mobile Phone Number+1 503-555-0141
Work Direct Phone, Corporate Phone, Other Phone → to Phone Number1first with a value+1 503-555-0100
Not in the export → to Lifecycle Stage2set to LeadLead
Not in the export → to Lead Status2set to NewNew
Company Name, Company → to Company Name3first with a valueMeridian
Website → to Website URLmeridian.example.com
Person Linkedin Url → to LinkedIn URLlinkedin.com/in/david-garcia-example
City, Person City → to City4first with a valuePortland
State, Person State → to State/Region5first with a valueOregon
Country, Person Country → to Country/Regionfirst with a valueUnited States
Industry → to IndustryLogistics & Supply Chain
Seniority, Departments, Lists → to Notesjoined, with labelsSeniority: VP | Departments: Operations, Supply Chain | Apollo lists: PNW Logistics Q4
Not imported: Email Status, Home Phone, Company Linkedin Url, # Employees, Annual Revenue, Company Address and 10 more. The template leaves these out; map any to a custom field in Operelio.
Where Apollo.io and HubSpot don’t line up
1
Four phone columns, two phone fields
Apollo.io splits numbers across Mobile Phone, Work Direct Phone, Corporate Phone and Other Phone. HubSpot formats each one by its country code, so a number saved without one stays as it is.
The template sends Mobile Phone to Mobile Phone Number. Phone Number takes the first of Work Direct Phone, Corporate Phone and Other Phone that has a value.
Apollo.ioWork Direct Phone empty Corporate Phone +1 503-555-0100 Other Phone +1 503-555-0199
HubSpot+1 503-555-0100
2
No lifecycle stage or lead status in the export
Apollo.io's export has no lifecycle stage or lead status column. In HubSpot, an import can move a contact's lifecycle stage forward but never back.
The template sets Lifecycle Stage to Lead and Lead Status to New on every row. Change either, or drop them, before you import if your process differs.
Apollo.ioNo column
HubSpotLead · New
3
Two Apollo.io columns, one Company Name
Apollo.io can fill Company Name and Company, and HubSpot has one Company Name.
The template takes the first of Company Name or Company that has a value.
Apollo.ioCompany Name Meridian Company empty
HubSpotMeridian
4
Two Apollo.io columns, one City
Apollo.io can fill City and Person City, and HubSpot has one City.
The template takes the first of City or Person City that has a value.
Apollo.ioCity Portland Person City empty
HubSpotPortland
5
Two Apollo.io columns, one State/Region
Apollo.io can fill State and Person State, and HubSpot has one State/Region.
The template takes the first of State or Person State that has a value.
Apollo.ioState Oregon Person State empty
HubSpotOregon
Check your Apollo.io export before you import it
Looks for the 22 columns this template reads, and what HubSpot would skip.
Drop your Apollo.io CSV here
Runs in your browser. Nothing is uploaded, and results are counts only.
Apollo.io to HubSpot in three steps
Step 1Export from Apollo.io
In Apollo, go to Search, then People, and apply your filters or open a saved list.
Check the contacts you want, or use bulk selection at the top, then click Export.
Choose whether to include all contacts or only those with verified emails.
Optionally click Edit export CSV settings to change the fields.
Click Export records, then Download when the file is ready.
Exporting saved contacts may use export credits, depending on your Apollo plan.
Contacts you have already exported, and contacts without verified emails, do not use credits.
Fixes the capitals in names, formats phone numbers, standardizes countries, removes duplicate and blank rows, which the Excel file leaves to you. On every plan. Email verification, a check against your HubSpot records and dropdowns, and the push, from Starter.
Where does Apollo.io's export fill Email, which HubSpot requires?
Email comes from Apollo.io's Email column, lowercased. The checker above counts the rows with Email blank.
Where do Seniority, Departments and Lists go?
Into one note on each contact, labeled like "Seniority: VP | Departments: Operations, Supply Chain | Apollo lists: PNW Logistics Q4". Importing the same contacts again adds a second note.
Why is the Email column filled with email_not_unlocked@domain.com?
That's the placeholder Apollo writes for a contact whose email you haven't revealed. Every locked row carries the same address, so none of them can be emailed, and a push from Operelio would treat them all as one person. Filter those rows out, reveal the contacts in Apollo first, or choose to export only contacts with verified emails.
Apollo.io
HubSpot