How to Import Records and Activities Into HubSpot CRM

If you’ve ever had a campaign misfire or a deal fall flat because of missing or distorted data, you’re not alone. Many HubSpot admins and RevOps managers find their workflows grinding to a halt after a flawed import, with records going missing, activities not being linked, and reporting becoming a guessing game.

HubSpot’s import tool is powerful, but it’s not forgiving. Even a small mistake like a mislabeled header or inconsistent ID can throw your entire system out of sync. When your CRM structure depends on accurate associations between contacts, companies, and activities, there’s no room for error.

This guide walks you through how to import records and activities into HubSpot CRM with clarity and control. 

You’ll learn how the import tool functions, how to structure files correctly, and how to avoid costly mistakes in your data pipeline.

Where Imported Data Goes in HubSpot (And How Records Get Linked)

You’ll find HubSpot’s import tool by navigating to Settings > Data Management > Imports. It’s your go-to hub for adding or updating contacts, companies, deals, tickets, and even custom objects. You can also bring in engagement activities like calls, notes, or tasks to enrich records with interaction history.

When you upload a CSV or XLSX file, the import tool maps file data to HubSpot objects using matched headers or internal IDs. That mapping determines where each piece of data ends up and how it links to related records.

Once imported, your data populates the corresponding areas of HubSpot: contacts appear under the Contacts tab, deals appear under the Deals tab, and activities appear in each record’s timeline. HubSpot automatically links activities to records using unique internal object IDs so teams can pick up right where they left off.

HubSpot also handles deduplication intelligently. It uses email for contacts, company domain for organizations, and record ID for other objects. That logic cuts down redundancy and lets you refresh existing records rather than creating duplicates.

How It Works Under The Hood

Every import into HubSpot follows a structured pipeline. The system ingests your file, verifies header consistency, maps column data to internal CRM properties, applies object relationships, deduplicates as applicable, and then commits new or updated records to the database.

Inputs HubSpot Expects:

• A CSV or Excel file with headers that match HubSpot property names
• At least one consistent unique identifier (like an email, domain, or record ID)
• Data formatted correctly for each field type (for example, ISO date formats for date fields)

Outputs You Receive:

• A summary of created or updated records
• Detailed logs of import stats, including successes and errors
• Timeline entries for imported engagement activities

You can further configure:

• Whether to update existing records based on unique identifiers
• Whether to create associations between records (e.g. link contacts to deals)
• Whether to skip duplicate entries when in doubt about data integrity

HubSpot processes files in the background for larger volumes and flags any line-level issues via downloadable error logs from the Imports dashboard. This allows you to resolve formatting or validation issues before re-uploading.

Main Uses Inside HubSpot

Importing CRM Records For New Portals

If you’re launching a new HubSpot portal, a full data import is often your first move. You’ll want to bring in clean copies of contacts, companies, and deals from legacy CRMs or spreadsheets.

Let’s say you’re migrating from Salesforce: you split your data into one file for companies (with a required domain column) and another for contacts (with email and company domain). During import, HubSpot uses the domain value to associate contacts with the right companies automatically. You preserve the relationship structure without any post-upload cleanup.

For CRM rollouts, this kind of batch import saves hundreds of hours in manual data entry.

Importing Historical Activities For Context

Activity data like calls, emails, tasks, and meeting notes is critical context for anyone using the CRM. Without it, sales and support teams are flying blind. HubSpot lets you import these historical interactions the same way you import contacts or companies.

Say you’re moving from Pipedrive. You export call logs into a spreadsheet with the contact’s email, date, call type, and notes. HubSpot uses those emails to attach each activity to the correct contact timeline. After import, your team sees interaction history as if it always lived in HubSpot, reducing onboarding friction and improving pipeline context.

This use case is essential for companies transitioning from older systems while maintaining continuity.

Updating Records With New Data

You may also need to refresh existing records periodically without overwriting entire fields or creating duplicates. With HubSpot, you can perform incremental imports to update only specific values.

Picture a marketing team uploading refreshed lead scores and regional data. By selecting “Update existing records” and matching the Email field, HubSpot pinpoints which records to revise and which to skip. Properties not included in the import stay unchanged.

This kind of targeted import lets you scale enrichment processes without risking record quality.

Common Import Errors And Assumptions

Small oversights during the import process can create significant data inconsistencies. Here’s what to watch for:

Missing Unique Identifiers

If your file lacks a unique ID like an email, domain, or record ID, HubSpot can’t determine whether a record already exists. That leads to duplicates and bloated reports. Always include a single column that uniquely identifies each object.

Field Formatting Mistakes

Using the wrong data type, for instance, typing “March 10, 2024” in a Date field instead of “2024-03-10”, can make the entire row fail. Check that currency, number, and date fields match HubSpot’s format requirements before uploading.

Incorrect Object Associations

Importing contacts and companies separately without linking them severs important relationships. Be sure to use a two-file import or include association columns so HubSpot can establish record connections from the start.

Skipping The Preview Screen

HubSpot shows a sample of your data mappings during the import preview. This is your chance to fix mismatched fields or view errors before they impact your CRM. Avoid surprises, double-check mappings for every import.

Assuming Activities Import With Contacts

Activities like tasks, emails, or calls are not bundled with contact imports. These are separate actions and require their own CSV with associations tied to the relevant record. Treat these as distinct from record updates.

Step-By-Step Import Guide

Before you begin a new import, confirm that your HubSpot account has the correct permission level. Go to Settings > Users & Teams > Permissions and ensure “Import” access is enabled.

Prerequisites:

• Clean, UTF-8 encoded CSV or Excel files
• Headers aligned with HubSpot property names
• Unique IDs for matching existing records
• Clear understanding of which object types are included

Steps:

1. Navigate to Settings > Data Management > Imports. Click “Start an import.”
2. Choose your file source. Select whether you’re uploading from your computer or pulling from a connected service like Google Sheets. Decide if you’ll use one file or two to link records.
3. Select the object type: Contacts, Companies, Deals, or other CRM entities.
4. Upload your file. Ensure it’s properly encoded to avoid unexpected character issues.
5. Map your columns. Match each header in your file to a HubSpot property. You can create new properties during this step if needed.
6. Set import behavior. Choose whether to update existing records or create new ones, and whether to associate different record types.
7. Preview and confirm. Use the preview screen to review sample data, confirm field mappings, and look for anomalies.
8. Launch your import. Click “Finish import” and track progress in the Imports dashboard.
9. Spot-check results. Visit object dashboards to verify that records were imported correctly, paying special attention to timeline visibility for activities.
10. Save mapping presets and download logs. Archiving your import settings and error files will help accelerate future imports with fewer mistakes.

Measuring Results In HubSpot

Once your import is complete, it’s critical to analyze whether the process worked as intended. HubSpot offers multiple tools and reports to validate your data:

Useful Reports Include:

• Contact source reports: Confirm if contacts grew by imports vs forms or integrations
• Property completeness dashboards: Audit critical fields like lifecycle stage or lead owner
• Duplicate detection reports: Use the Data Quality Command Center to flag and remove overlaps
• Activity volume reports: Ensure calls or meetings were accurately imported and timestamped

Import Health Checklist:

• Record totals in HubSpot match the number of rows in your file
• High-priority fields (like email or stage names) were mapped correctly
• Relationships were preserved, contacts are linked to companies or deals
• Review your error log for failed rows and next steps
• For large datasets, run a weekly deduplication cycle to keep records in shape

Regular checks catch errors early and help maintain CRM integrity over time.

Short Example That Ties It Together

Suppose your RevOps team is pulling data from three tools: a mailing list, a deal tracker, and a call-recording app. You start by importing contacts using email and domain values. Then you import deals and associate them to those contacts using the “Deal Owner” and “Contact Email” columns. Finally, you upload call logs mapped to emails, duration, and time spent, categorized as Activities.

Each layer builds on the last: contacts are enriched with deal history and past interactions, and dashboard metrics like “Last Contacted” or “Call Volume per Rep” remain accurate out of the gate.

You now have a CRM that reflects reality, is context-rich, properly linked, and report-ready.

How INSIDEA Helps

HubSpot doesn’t leave much room for import error, and your business can’t afford a broken CRM launch or botched migration. That’s where our team comes in.

We specialize in clean, scalable HubSpot data management, helping you move from chaos to clarity. Whether you’re re-platforming from Salesforce or importing a decade’s worth of activity logs, our team ensures every field maps correctly and every association aligns. No duplicates. No bad data.

INSIDEA offers:

• HubSpot onboarding to ensure your foundation is solid
• Routine CRM maintenance to keep your records clean and audited
• End-to-end data migration from any platform into HubSpot
• Import QA and mapping validation to catch mismatches before they go live
• Clean reporting setup so imported data flows naturally into dashboards
• Process guidance so you can scale imports across departments without errors

Planning an import or migration? 

Get trusted support before you press “Finish Import.” Visit INSIDEA  to speak with a HubSpot expert and protect your most valuable resource: your data.

Accurate imports keep your HubSpot CRM clean, connected, and actionable, invest the time (or get help) to do it right.