HubSpot
Monday.com Contacts4 fieldsHow to import HubSpot data into Monday.com
Moving from HubSpot to Monday.com? This template combines First Name and Last Name into Monday.com's single Name column, then maps email, phone, and company to board columns. Monday.com doesn't deduplicate on import, so dedupe your CSV first if HubSpot has historical duplicates.
Field-by-field mapping
This is the complete column mapping from HubSpot to Monday.com. The left column is the header in your CSV export. The right column is the Monday.com field it should map to.
| HubSpot column | Monday.com field | |
|---|---|---|
| First Name + Last Name | Name* Monday.com uses a single Name column on the item, so we combine the two HubSpot columns into one. TransformFirst Name and Last Name combined with a space | |
| Email TransformLowercased and trimmed | ||
| Phone Number | Phone TransformStandardized to international format (+1, +44, etc.) | |
| Company Name | Company |
Required by Monday.com.
Columns we don't use
Your HubSpot export includes 9 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Monday.com.
- Job Title
Monday.com boards don't have a default job-title column.
If you need it. Add a Text column to your Monday.com board called Job Title, then re-run this template to map it.
- Website URL
Monday.com boards don't have a default website column.
If you need it. Add a Link column to your Monday.com board called Website, then re-run this template to map Website URL into it.
- Street Address, City, State/Region, Postal Code, Country/Region
Monday.com boards don't have a default address-block column set. Each piece needs its own column on the board.
If you need it. Add Text columns to your Monday.com board for each address piece, then re-run this template to map them.
- Lifecycle Stage, Lead Status
HubSpot's funnel-tracking columns don't have a direct Monday.com equivalent. Monday.com uses Status columns with custom values per board.
If you need it. Add Status columns to your Monday.com board (e.g. Stage, Status) with values matching your HubSpot Lifecycle Stage and Lead Status, then re-run this template to map them.
Formatting and cleanup
HubSpot exports rarely match the format Monday.com expects. Fix these before you import.
- 1.Combines First Name and Last Name into Monday.com's single Name column
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Drops HubSpot columns that don't have a default Monday.com board column
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your HubSpot export and download a clean, import-ready file for Monday.com.
HubSpot to Monday.com FAQ
How do I export contacts from HubSpot?
In HubSpot, go to Contacts, click the Actions menu, choose Export, select 'All properties' and CSV format, then download. HubSpot will email you the file when it's ready.
Why do you combine First Name and Last Name?
Monday.com items have a single Name column, not separate first and last name columns. The template combines the two HubSpot columns with a space so each item displays correctly.
How does Monday.com handle duplicates on import?
Monday.com boards don't deduplicate on import. Every row in your CSV creates a new item. Run a deduplication pass on your CSV before uploading, especially with HubSpot exports that may include historical duplicates.
What about HubSpot's Lifecycle Stage?
Monday.com uses Status columns with custom values per board. Add a Status column to your Monday.com board with values matching your HubSpot stages, then re-run this template to map Lifecycle Stage into it.
Where do I import the CSV into Monday.com?
Open your contacts board, click the + at the top-right, choose 'Import from spreadsheet', and upload the file Operelio produces. The import wizard matches the column headers to your board columns.
