HubSpot CSV Import Template for Contacts
Importing contacts into HubSpot via CSV is the most common way to bulk-add leads. But getting the format right the first time saves a lot of frustration. This guide gives you the exact CSV template HubSpot expects, explains field mapping, and shows how to export directly from CAPT in the correct format.
The HubSpot CSV Format
HubSpot expects a standard CSV file with headers in the first row. The minimum required field is Email. Here's the template for the most common contact fields:
| CSV Column Header | HubSpot Property | Required |
|---|---|---|
| Yes | ||
| First Name | First name | No |
| Last Name | Last name | No |
| Company | Company name | No |
| Phone | Phone number | No |
| Job Title | Job title | No |
| Website | Website URL | No |
Example CSV
Email,First Name,Last Name,Company,Phone,Job Title,Website
jane@acme.com,Jane,Doe,Acme Inc,+1-555-0123,Marketing Director,https://acme.com
bob@startup.io,Bob,Smith,Startup.io,,CTO,https://startup.ioHow to Import: Step by Step
- In HubSpot, go to Contacts > Contacts
- Click Import (top right)
- Select File from computer
- Choose One file and One object
- Select Contacts as the object type
- Upload your CSV file
- Map columns to HubSpot properties (HubSpot auto-matches most column names)
- Review and click Finish import
Column Name Matching
HubSpot's auto-mapping works best when your column headers match the property names exactly. Here are the most commonly mismatched fields:
| Your Column | HubSpot Auto-Match? | Fix |
|---|---|---|
email |
Yes | - |
first_name |
No | Rename to First Name |
company_name |
No | Rename to Company |
url or source_url |
No | Rename to Website |
notes |
No | Map manually to a custom property |
CAPT's HubSpot Export
If you're using CAPT with HubSpot, the Pro plan includes a one-click HubSpot CSV export. The file is pre-formatted with the correct column headers, so HubSpot's auto-mapping picks up all fields without manual intervention.
CAPT maps its fields to HubSpot like this:
| CAPT Field | HubSpot CSV Column |
|---|---|
| Source URL | Website |
| Tags | Lead Source (or custom) |
| Notes | Description |
| Date Added | Create date |
Export HubSpot-ready CSV in one click
CAPT Pro generates CSV files with the exact column headers HubSpot expects. No reformatting needed.
Learn MoreHandling Duplicates During Import
HubSpot automatically deduplicates on the Email field. If a contact with the same email already exists in your CRM, HubSpot will update the existing record with any new data from your CSV rather than creating a duplicate.
This means you can safely re-import an updated CAPT export without worrying about creating duplicate contacts. Only new or modified fields will be updated.
Common Import Errors
- "Invalid email format": Check for extra spaces, missing @ symbols, or malformed addresses. CAPT's extraction already validates email format, so this is rare with CAPT exports.
- "Unmapped column": HubSpot didn't recognize a column header. Either rename it or map it manually during import.
- "File too large": HubSpot's import limit is 150MB. For very large lists, split the file or use the HubSpot API.
- Encoding issues: Use UTF-8 encoding. CAPT exports in UTF-8 by default.
Conclusion
Getting your CSV format right before importing into HubSpot saves significant time. Use the template above as a reference, or let CAPT generate the correct format automatically. Combined with HubSpot's built-in deduplication, you'll have a clean, up-to-date contact database without manual data wrangling.