How to Import a HubSpot Contact List Into Notion With Custom Fields

You have a HubSpot contact list with dozens of custom properties like deal stage, lead source, or last email open date. Manually copying each field into a Notion database is slow and error prone. Notion does not offer a native HubSpot connector, so you must use an intermediate tool to map and transfer your data. This article explains how to export your HubSpot contact list, prepare the CSV file, and import it into a new or existing Notion database while preserving all custom fields.

How HubSpot Contact Data Maps to Notion Database Properties

HubSpot stores contact information in properties. Standard properties include First Name, Last Name, Email, Phone, and Company. Custom properties are fields you created inside HubSpot, such as Lead Score, Product Interest, or Region. When you export contacts, HubSpot writes each property as a column header in the CSV file. Notion’s database import reads the first row of the CSV as column headers and creates matching database properties. If your Notion database already has properties with identical names, the import merges data into existing columns. If the names differ, Notion creates new properties. To keep your custom fields organized, you must align the CSV column headers with your Notion property names before importing.

Notion supports these property types during CSV import: Text, Number, Select, Multi-select, Date, Email, Phone, URL, and Checkbox. HubSpot custom fields that are dropdowns or checkboxes convert to Select or Multi-select properties in Notion. Free-text fields become Text properties. Date fields become Date properties. You cannot import HubSpot file attachments, notes, or activity logs directly into Notion through a CSV. Those require a third-party integration tool like Zapier or Make.

Steps to Export HubSpot Contacts and Import Into Notion

1. Export your HubSpot contact list as a CSV file
   Log into your HubSpot account. Go to Contacts > Contacts. Click the Filters button to apply any list or property filters you want. Click the Export button in the top-right corner. Select Export all contacts or Export specific properties. If you choose specific properties, check every custom field you need. Click Export. HubSpot sends a CSV file to your email. Download the file to your computer.
2. Open the CSV file and review column headers
   Open the CSV file in Excel, Google Sheets, or a text editor. The first row contains column headers like First Name, Last Name, Email, and any custom property names. Scroll horizontally to see all columns. Make sure every custom field you need is present. If a column is missing, repeat the export and select that property.
3. Rename CSV headers to match your Notion database property names
   Decide whether you will import into a new Notion database or an existing one. For an existing database, open that database in Notion and note the exact property names. For example, if your Notion property is called “Lead Source” but HubSpot calls it “Lead_Source_Original”, rename the CSV header to “Lead Source”. Change all header names to match exactly. Use consistent capitalization and spacing. Save the CSV file.
4. Prepare the CSV data for Notion property types
   Notion expects specific value formats. For Select properties, each cell must contain exactly one value. For Multi-select properties, separate values with commas inside the cell. For Date properties, use the format YYYY-MM-DD. For Checkbox properties, use TRUE or FALSE. For Number properties, use plain numbers without currency symbols or commas. Adjust any cells that do not meet these formats.
5. Import the CSV into Notion
   Open Notion in your browser. Go to Settings & Members in the left sidebar. Click Import. Under CSV, click Select file. Choose your prepared CSV file. Notion shows a preview of the first 10 rows. Verify that the column headers match your expected property names. Click Import. Notion creates a new database page with the imported data.
6. Move imported data into an existing database (optional)
   If you want the contacts in an existing database, open the newly imported database. Select all rows by clicking the checkbox column header. Press Ctrl+A to select all rows, then Ctrl+C to copy. Open your target database. Click the empty row at the bottom. Press Ctrl+V to paste. Notion duplicates the properties and values. Alternatively, use the “Move to” option in the database menu to move pages between databases.
7. Verify custom fields and fix mismatches
   Open a few contact records in Notion. Check that custom fields like Lead Score or Product Interest display correctly. If a field shows as plain text instead of a Select, edit the property type in Notion. Click the property name at the top of the column, choose Edit property, and change the type to Select or Multi-select. Add the options that match the values in your CSV.

Common Problems When Importing HubSpot Contacts to Notion

Custom fields appear as text instead of dropdowns

Notion imports all values as Text by default. After import, you must manually change the property type to Select or Multi-select. Click the property header, choose Edit property, and select the correct type. Then add each unique value as an option. Notion does not auto-detect dropdown values from CSV data.

Duplicate contacts after merging into an existing database

Notion does not deduplicate during import. If you paste contacts into an existing database, you may end up with duplicate rows. To prevent this, sort the existing database by Email before pasting. Delete any rows in the imported data that match existing email addresses. Use a third-party tool like Notion Automations or a script to remove duplicates after import.

Date fields show wrong timezone

HubSpot exports dates in UTC. Notion displays dates based on your workspace timezone setting. If a contact’s last activity date appears off by several hours, check your Notion workspace timezone. Go to Settings & Members > Settings > Workspace > Time zone. Change it to match your local timezone. The imported dates adjust automatically.

CSV file fails to import due to special characters

HubSpot CSV files sometimes contain special characters like em dashes, smart quotes, or non-breaking spaces. These characters can cause Notion to reject the file. Open the CSV in a plain text editor like Notepad. Use Find and Replace to replace em dashes with hyphens and smart quotes with straight quotes. Save the file as UTF-8 without BOM. Retry the import.

HubSpot Export Options vs Notion Import Capabilities

Item	HubSpot Export	Notion Import
Supported file format	CSV only	CSV, TSV, or plain text
Custom field support	All standard and custom properties	All CSV columns become properties
Property type detection	Exports values as plain text	Imports all values as Text
Date formatting	Exports as YYYY-MM-DD or UTC string	Requires YYYY-MM-DD format
Multi-value fields	Exports values separated by semicolons	Expects commas inside the cell
File attachments	Not included in CSV export	Not supported through CSV import

You can now export a HubSpot contact list, rename the CSV headers to match your Notion database, and import the data while preserving all custom fields. After import, convert text properties to Select or Multi-select types to maintain your original field structure. For recurring imports, consider using Zapier or Make to sync HubSpot contacts to Notion automatically without manual CSV handling.