How to import contacts via CSV on HubSpot
Navigate to Contacts > Import in HubSpot, upload your CSV file, and map the columns to HubSpot properties. HubSpot will process the import and notify you when complete.
Prerequisites
- Active HubSpot account with contact creation permissions
- CSV file with properly formatted contact data
- Column headers matching HubSpot contact properties
- Clean data with valid email formats
Step-by-Step Instructions
Access the Import Tool
Select Import Type
Upload Your CSV File
Select Import Objects
Map CSV Columns to HubSpot Properties
Configure Import Settings
Monitor Import Progress
Review Import Results
Common Issues & Troubleshooting
CSV columns not mapping correctly to HubSpot properties
Ensure your CSV headers exactly match HubSpot property names or use the dropdown to manually select the correct property for each column. Remove any special characters or extra spaces from column headers.
Import fails with 'Invalid email format' errors
Clean your email data to remove invalid entries, extra spaces, or formatting issues. Use Excel's TRIM function or similar to clean data before importing.
Duplicate contacts being created instead of updated
Ensure you've selected the correct duplicate handling option and that your CSV includes the email field which HubSpot uses as the primary identifier for matching existing contacts.
File upload fails or times out
Check that your file is under 512MB and in CSV format. Try splitting large files into smaller batches of 10,000-25,000 contacts each for better processing reliability.