Importing Data to HubSpot: The Complete Best Practices Guide | Vantage Point

Introduction

Every CRM implementation begins with data—and how you get that data into your system determines whether your teams hit the ground running or spend weeks untangling errors. If you're adopting HubSpot CRM, the import process is the single most important step between your old workflows and a fully operational, automation-ready platform.

Yet data imports remain one of the most underestimated tasks in CRM implementations. Mismatched properties, duplicate records, broken associations, and formatting errors don't just create technical debt—they erode trust in your CRM before your team even starts using it. According to industry research, more than half of CRM data quality issues originate from the initial import process.

In this guide, we'll walk through everything you need to know about importing data to HubSpot in 2026—from pre-import planning and file preparation to mapping, associations, error resolution, and post-import validation. Whether you're migrating 500 contacts from a spreadsheet or 500,000 records from another CRM, this guide will help you do it right the first time.

What Can You Import Into HubSpot?

HubSpot's import tool supports a wide range of CRM objects and activities. Understanding what you can bring in—and how records relate to each other—is the first step to a clean migration.

Supported Objects

Supported File Formats

HubSpot accepts three file types for imports:

• CSV (comma-separated values) — most common and recommended
• XLS (Excel 97–2003)
• XLSX (Excel 2007+)

Important file requirements:

• Maximum file size: 512 MB
• Maximum rows per file: 1,048,576
• Only one sheet per file (for XLS/XLSX)
• Column headers must be in the first row
• UTF-8 encoding recommended for special characters

How to Prepare Your Data Before Importing

The difference between a smooth import and a disaster almost always comes down to preparation. These steps will save you hours of cleanup.

Step 1: Audit Your Existing Data

Before you touch HubSpot's import tool, conduct a thorough data audit:

• Identify incomplete records: Flag contacts without email addresses, companies without domains, and deals without stage assignments
• Check for duplicates: Search for duplicate emails, company names, and phone numbers
• Validate data accuracy: Spot-check a sample of records for outdated information, fake emails, and incorrect formatting
• Determine data scope: Decide how far back your historical data needs to go—importing five years of stale contacts may create more noise than value

Step 2: Clean and Standardize Your Data

Data cleaning is non-negotiable. Address these common issues before import:

• Email formatting: Lowercase all emails, remove leading/trailing spaces
• Phone numbers: Apply a consistent format with country codes (e.g., +1-555-123-4567)
• Date formats: Use YYYY-MM-DD, MM/DD/YYYY, or DD/MM/YYYY—but be consistent throughout your file
• State/country values: Standardize abbreviations (e.g., "CA" vs. "California")
• Remove HTML and special characters from text fields unless intentional
• Trim whitespace from all cells—invisible trailing spaces cause matching failures

Step 3: Map Your Fields to HubSpot Properties

Create a mapping document that aligns every column in your source data to a HubSpot property:

Pro tip: If your source data contains fields that don't exist in HubSpot, create custom properties in HubSpot before you import. This prevents the import wizard from skipping those columns.

Step 4: Understand Unique Identifiers

Unique identifiers are how HubSpot recognizes whether to create a new record or update an existing one. Getting these right prevents the most common import problems:

• Contacts: Email address (primary) or Record ID
• Companies: Company domain name (primary) or Record ID
• Deals, Tickets, Custom Objects: Record ID or a custom unique-value property

Critical rule: If Record ID is mapped during your import, it supersedes all other unique identifiers. Only use Record ID when updating records you've already exported from HubSpot.

How to Import Data Into HubSpot: Step-by-Step

Single Object Import

Use this when importing one type of record (e.g., contacts only):

1. Navigate to CRM > Contacts (or the relevant object page)
2. Click Import in the top right
3. Select Start an import
4. Choose File from computer and upload your CSV/XLS/XLSX
5. Select the object type (contacts, companies, deals, etc.)
6. Choose whether to create new records, update existing records, or both
7. Map each column header to the appropriate HubSpot property
8. Review the mapping guide for errors and warnings
9. Set a name for your import and click Import

Multi-Object Import (with Associations)

Use this when importing related records together (e.g., contacts + companies):

Option A: Single file with both objects

• Include columns for both objects in one file
• Each row represents an associated pair (e.g., contact + their company)
• Include unique identifiers for both objects (email + company domain)

Option B: Two separate files with a common column

• File 1: Contacts (with a shared identifier column like "Company Name")
• File 2: Companies (with the same shared identifier column)
• HubSpot uses the common column to associate records during import

Importing Activities

You can import calls, emails, meetings, notes, and tasks alongside records:

• Activities must be associated with at least one object
• Include the associated record's unique identifier in your activity file
• Note: Emails, meetings, and notes can only be created (not updated) via import
• Tasks can be created but not updated

How to Handle Associations During Import

Associations are the relationships between HubSpot records—linking a contact to their company, a deal to its associated contacts, or even contacts to other contacts (same-object associations).

Cross-Object Associations

To link contacts to companies during import:

1. Include both Email (contact identifier) and Company domain name (company identifier) in your file
2. During the import wizard, select the option to associate the two objects
3. HubSpot creates the link automatically

Same-Object Associations

For relationships like manager-to-employee:

1. Include two identifier columns (e.g., "Manager Email" and "Employee Email")
2. Select the same-object association option during import
3. Optionally add association labels to describe the relationship

Association Labels (Professional/Enterprise)

Association labels let you specify the nature of a relationship—like "Decision Maker," "Billing Contact," or "Primary Company." Include a column with the label name that matches a label you've already created in HubSpot.

Common Import Errors and How to Fix Them

Even with careful preparation, errors happen. Here are the most common HubSpot import errors and their solutions:

1. Failed Validation of Email

Cause: Email format doesn't match standard format (name@domain.com)
Fix: Check for missing @ symbols, spaces, or invalid characters. Ensure emails are properly formatted.

2. Invalid Enumeration Option

Cause: A dropdown/checkbox value in your file doesn't match any existing option in HubSpot
Fix: Compare your values against the property's options in HubSpot. Use the internal value, not just the display label.

3. Could Not Find Owner

Cause: The owner name/email in your file doesn't match any active HubSpot user
Fix: Use the owner's email address (not name) and verify they're an active user in your account.

4. Duplicate Unique Property Value

Cause: Two or more rows share the same unique identifier value
Fix: Remove duplicate rows or use Record ID to update specific records.

5. Association Record Not Found

Cause: The unique identifier used for association doesn't match any existing record
Fix: Verify unique identifier values exist in HubSpot. Export current records to get correct Record IDs.

6. Could Not Parse Date

Cause: Date values don't match the format selected during import
Fix: Ensure all dates use a consistent format and match your selection in the import wizard.

7. Missing Required Property

Cause: A required property has no value for one or more rows
Fix: Fill in the required fields before re-importing. Check which properties are marked as required in your HubSpot settings.

Best Practices for HubSpot Data Imports

Follow these proven strategies to ensure consistently clean imports:

Before Import

1. Back up your current HubSpot data — Export existing records before importing to create a safety net
2. Pause active workflows — Temporarily deactivate workflows triggered by record creation or updates to prevent unintended automations
3. Test in a sandbox first — HubSpot sandbox environments let you validate imports without affecting production data
4. Break large imports into batches — Import 5,000–10,000 records at a time for easier error detection and faster processing
5. Create custom properties in advance — Don't let the import wizard auto-skip columns because properties don't exist

During Import

6. Review the Mapping Guide carefully — HubSpot's mapping screen highlights errors in the first 1,000 rows; use this to catch issues early
7. Use "Don't import" wisely — Skip columns that contain data you don't need in HubSpot rather than mapping them incorrectly
8. Choose the right import mode — Select "create and update" only when you intend to modify existing records
9. Verify association mappings — Double-check that the correct unique identifiers are selected for each object relationship

After Import

10. Review the import summary — Check the number of records created, updated, and errored against your expectations
11. Download the error file — Fix errors in the downloaded file and re-import only the affected rows
12. Spot-check records manually — Open 10–20 records to verify data landed in the correct properties
13. Re-enable workflows — Turn automations back on only after confirming data quality
14. Document your import — Record what was imported, when, and any issues for future reference

Advanced Import Strategies

Using the HubSpot Import API

For organizations with technical resources, HubSpot's Import API enables programmatic imports:

• Automation: Schedule recurring imports from external databases
• Custom validation: Apply business rules before records reach HubSpot
• Large-scale migrations: Handle millions of records with rate-limiting and retry logic
• Endpoint: POST /crm/v3/imports

HubSpot Data Sync

For ongoing data synchronization (not just one-time migration), consider HubSpot's native Data Sync:

• Two-way sync between HubSpot and 100+ apps
• Automatic field mapping and conflict resolution
• Real-time or scheduled sync options
• No coding required

Third-Party Migration Tools

Tools like Import2, Trujay, and SyncMatters specialize in CRM migrations:

• Pre-built connectors for Salesforce, Zoho, Pipedrive, and other CRMs
• Automated field mapping and data transformation
• Relationship preservation across objects
• Ideal for complex migrations with custom objects and extensive history

How Vantage Point Helps with HubSpot Data Migration

At Vantage Point, we've guided hundreds of organizations through HubSpot CRM implementations—and we know that data migration is where projects succeed or fail. Our team brings deep expertise in:

• Migration planning and data auditing — We assess your current data landscape and create detailed mapping strategies before touching a single record
• Complex multi-system migrations — Moving data from Salesforce, legacy CRMs, or multiple disconnected systems into a unified HubSpot environment
• Custom property architecture — Designing HubSpot property structures that reflect your actual business processes, not just your old CRM's field names
• Post-migration validation and optimization — Comprehensive QA processes to verify data integrity, association accuracy, and automation readiness
• Ongoing data governance — Establishing processes to keep your CRM data clean long after the initial migration

Whether you're migrating from another CRM or consolidating data from spreadsheets and disconnected tools, Vantage Point ensures your HubSpot implementation starts with a rock-solid data foundation.

Frequently Asked Questions (FAQ)

What file formats does HubSpot accept for imports?

HubSpot accepts CSV (.csv), Excel 97-2003 (.xls), and Excel 2007+ (.xlsx) files. CSV is the most commonly used and recommended format. Files must be under 512 MB, contain only one sheet, and have column headers in the first row.

How do I prevent duplicate records when importing into HubSpot?

Use unique identifiers in your import file—email addresses for contacts and company domain names for companies. When updating existing records, include the Record ID column. Select "Create and update" during the import process so HubSpot matches existing records instead of creating duplicates.

Can I import data from Salesforce directly into HubSpot?

Yes. HubSpot offers a native Salesforce integration that can sync data between the two platforms. You can also export Salesforce data to CSV files and import them into HubSpot manually. For complex migrations, HubSpot's self-service transfer tool or a partner like Vantage Point can help ensure a smooth transition.

What is the maximum number of records I can import into HubSpot at once?

A single import file can contain up to 1,048,576 rows (the maximum for most spreadsheet applications). However, for best results and easier error handling, we recommend importing in batches of 5,000–10,000 records. The maximum file size is 512 MB.

How do I associate contacts with companies during import?

Include both the contact's email address and the company's domain name in your import file. During the import process, select the option to import multiple objects and associate them. HubSpot uses the unique identifiers to create the relationship automatically.

What should I do if my import has errors?

First, review the import summary for error details. Download the error file, which contains the specific rows and error codes. Fix the issues in your original file (formatting, missing values, incorrect identifiers), then re-import only the affected rows. Common errors include invalid email formats, unrecognized dropdown values, and missing required properties.

How long does a typical HubSpot data import take?

Small imports (under 5,000 records) typically complete in under 5 minutes. Larger imports (50,000–100,000+ records) may take 30 minutes to several hours depending on file complexity and association mapping. The total project timeline—including planning, cleaning, and validation—ranges from a few hours to several weeks for enterprise migrations.

Conclusion

Importing data into HubSpot isn't just a technical step—it's the foundation of your entire CRM strategy. Clean, well-structured data powers accurate reporting, reliable automation, effective segmentation, and ultimately, better customer experiences. Taking the time to audit, clean, map, and validate your data before import pays dividends for months and years to come.

Whether you're handling your first import or managing a complex multi-system migration, the principles remain the same: prepare thoroughly, use unique identifiers consistently, test before going live, and validate after every import.

Ready to get your HubSpot data migration right the first time? Contact Vantage Point to learn how our team can help you plan, execute, and optimize your data import for maximum CRM performance.

About Vantage Point

Vantage Point is a certified Salesforce and HubSpot partner specializing in CRM implementation, data migration, integration, and AI-powered automation. We help businesses of all sizes build connected, intelligent customer platforms using Salesforce, HubSpot, MuleSoft, Data Cloud, and Anthropic Claude AI. Learn more at vantagepoint.io.