HubSpot contact import file formatter: a CSV that maps on the first try
In short: Upload any export (.xlsx or CSV) or paste cells. The tool writes Email, First Name, Last Name and Phone Number in +country-code form, puts extra addresses in Additional email addresses separated by semicolons, and merges repeats. Limit: Only Email, First Name, Last Name, Phone Number and Additional email addresses are written; map other properties in HubSpot.
HubSpot needs an Email column to create contacts, with first and last name optional, and wants phone numbers as +country code then number. Upload your export here and it writes a CSV with Email, First Name, Last Name and Phone Number, puts any extra addresses in an Additional email addresses column with semicolons, and merges repeats.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Used only to complete phone numbers.
Sample result
Jane's row becomes [email protected] with +14155550132, and Leo's second address goes in Additional email addresses.
- Contacts
- 2 contacts
- Phone
- +14155550132
- Extra emails
- Semicolon separated
What this means for you
Email is the one required column; phones are written as +country code and number, as HubSpot asks.
- Email, name and phone columns
- Extra emails in their own column
- +country-code phones
- Repeats merged
- HubSpot
- Contacts
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Check the addresses before they go into HubSpot.
- Export the email column from the file you just made, or use the check button under the result.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I prepare a contact file for a HubSpot import?
- Upload the export (.xlsx or CSV), or paste the cells with the header row first.
- Choose the country used for phone numbers written without a + country code.
- Check the columns found and the rows left out, then download the CSV.
- In HubSpot, start an import from a file, upload it and confirm each column maps to the property you expect.
Example
- You enter
- A sheet with Full Name, Work Email, Mobile, Country and Company:
Jane Doe,[email protected],(415) 555-0132,United States,Northwind;Leo Martinwith[email protected]; [email protected]; a repeat row for[email protected]; and a row with only a phone,(212) 555-0100. - You get
- Two contacts under Email, First Name, Last Name, Phone Number and Additional email addresses:
[email protected]with+14155550132, and[email protected]with[email protected]in the additional column. The repeat is merged and the phone-only row left out. - Limits
- Runs in your browser; nothing is uploaded. Files up to 25 MB.
What does HubSpot require in a contact file?
HubSpot's import guide says contacts need an Email column; First name and Last name are optional basics. The file is a .csv, .xlsx or .xls with one sheet and a header row where each header corresponds to a property, saved as UTF-8 if it holds non-English characters. See HubSpot's import file guide.
How are several emails and phone numbers handled?
HubSpot's guide uses an "Additional email addresses" column for secondary addresses, separated by semicolons. When one cell in your export holds several addresses, the first goes in Email and the rest here. For the Phone number property HubSpot asks for + then the country code and number, so numbers are written that way using the country you choose.
What is left out?
Rows with no valid email are counted and left out, because Email is how HubSpot identifies a new contact. Repeats of one address are merged into one row. Custom properties, lifecycle stages and owners are not written; add those columns in the import mapping step.
Who uses this tool, and for what?
- Marketing ops
- Clean a trade-show or webinar export before it becomes contact records.
- Sales teams
- Turn a lead-database export into a HubSpot-ready file with proper phone numbers.
- Agencies
- Prepare a client's list the same way for every HubSpot portal.
What can’t this tool tell you?
- Only Email, First Name, Last Name, Phone Number and Additional email addresses are written; map other properties in HubSpot.
- HubSpot's file-size and row limits depend on your plan and aren't enforced here beyond a size warning.
- Header names follow HubSpot's property labels; confirm them on the mapping screen.
- Phone numbers that can't be read are left blank and counted.
Common questions
- What is the only required column in a HubSpot contact import?
- Email. First and last name are optional, but HubSpot lists them as the basic identifying fields.
- How do I import more than one email per contact?
- Use an Additional email addresses column with the extra addresses separated by semicolons. This tool fills it from cells that hold several addresses.
- What phone format does HubSpot expect?
- + then the country code and number, for example +11234567890, with an extension written as ext followed by the number.
- Which file types can I import?
- HubSpot's guide lists .csv, .xlsx and .xls with a single sheet. This tool downloads a CSV.
- Is my list uploaded to SimpleVerifier?
- No. The file is read and rewritten in your browser.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.