How to Import Records into HubSpot for a Single Object

Importing data into HubSpot correctly is essential for clean reporting, automation, and day-to-day sales and marketing work. This guide walks you step-by-step through importing a single object, such as contacts, companies, deals, tickets, products, calls, or notes, using CSV files and proper property mapping.

Before you begin, make sure you have the right access in your account and that your spreadsheet is formatted to match the required structure for each object type.

HubSpot import prerequisites and access

To import records into your CRM, you must have permission to import for that specific object. In many accounts this is restricted to admins or specific roles to avoid accidental data overwrites.

Check the following before starting:

• You have Import permissions for the object you want to import.
• You understand which records you want to create or update.
• You know which fields in your spreadsheet correspond to existing properties in your HubSpot database.

If you are planning a complex migration or multi-object import, consider partnering with a CRM consultant such as Consultevo to prepare a strategy and field mapping plan.

Prepare your file for a HubSpot import

Every successful import into the CRM starts with a clean, well-structured file. For a single-object import, HubSpot supports CSV, XLS, and XLSX files, but CSV is typically the most reliable format.

General file formatting rules for HubSpot

• Use one sheet per file when importing Excel workbooks.
• Ensure the first row contains column headers only.
• Remove blank rows and unnecessary columns.
• Save text values as plain text, not formulas.
• Use UTF-8 encoding to avoid character issues.

Required columns for each object type in HubSpot

Different objects require different identifying fields. Include at least the following columns depending on what you are importing:

• Contacts: Email (for unique identification and updating existing records)
• Companies: Company domain name or Company name
• Deals: Deal name and Pipeline/Deal stage (optional but strongly recommended)
• Tickets: Ticket name and Pipeline/Status where applicable
• Products: Name and optionally SKU or other unique identifier
• Calls and notes: Association identifiers (such as Contact ID) and content fields

For updates to existing records, include the unique identifiers that your HubSpot account uses, such as Contact ID, Company ID, Deal ID, or Ticket ID. This tells the system which records to modify instead of creating duplicates.

Launch the HubSpot import wizard

Once your file is ready, you can start the import process from inside the CRM. The steps are similar for all supported objects.

1. In your account, navigate to the object you want to import (for example, Contacts).
2. Click the Import button, usually found in the upper-right corner.
3. Select Start an import.
4. Choose File from computer as the source.
5. Select One file and then choose the applicable single object type.
6. Upload your prepared file and continue.

The interface may slightly differ depending on the object selected, but the overall flow remains consistent across the CRM.

Map your file columns to HubSpot properties

After uploading your spreadsheet, you will be prompted to map your column headers to existing CRM properties. Correct mapping ensures the right data lands in the right place.

Automatic property mapping in HubSpot

The system attempts to match your column names to existing properties automatically. Review these suggestions carefully:

• Confirm that key identifiers, such as email or company domain name, map correctly.
• Check that custom fields from your file map to corresponding custom properties that already exist.
• Look for any warning icons indicating unmapped or partially mapped fields.

Manually mapping or creating properties in HubSpot

For any unmapped column:

1. Click the dropdown beside the column name.
2. Select the appropriate existing property if it appears.
3. If you do not see a match, choose the option to create a new property.
4. Assign a label, internal name, field type, and group for the new property.

Make sure the data type in your spreadsheet (text, number, date, dropdown value) aligns with the property type you select, so that the import proceeds without errors.

Set import options and create lists or associations

Depending on the object you are importing, you may see additional options to organize or categorize the new records during the import.

HubSpot contact and company import options

• Create a list of imported contacts: Automatically generate a static list containing only the records from this import, useful for follow-up campaigns or quality checks.
• Update existing records: Use matching identifiers to update existing contacts or companies. Leave this option on when performing a data clean-up or enrichment import.

HubSpot deal, ticket, and product import options

For objects like deals, tickets, or products, you may be able to:

• Specify default pipeline or stage values if not present in your file.
• Associate records with companies or contacts using IDs or emails.
• Define owner assignments during import based on email or owner ID columns.

Always double-check these settings to ensure records follow the correct sales or service processes after they are created in the CRM.

Run the HubSpot import and validate results

When you are satisfied with your mappings and options, you can finalize the import.

1. Review the summary screen, which typically includes the object type, file name, and record count.
2. Click Finish import to start processing.
3. Wait for the confirmation notification or email indicating completion.

After it finishes, open the relevant object view (for example, the Contacts or Deals index page) and filter by the new import name or by create date to verify that records look correct.

Handling HubSpot import errors

If issues are detected, the system usually provides an error file or error summary. Use it to identify and fix problems such as:

• Missing required fields.
• Invalid data formats (for example, incorrect date formats or values outside allowed dropdown options).
• Duplicate records caused by inconsistent identifiers.

Correct your source file based on the feedback, then re-run a smaller test import to confirm the fix before repeating it at full scale.

Best practices and additional HubSpot resources

To keep your CRM healthy over time, follow these practices every time you import data:

• Run a test import with a small sample file first.
• Document which fields map to which properties for future reference.
• Standardize naming conventions and picklist values before importing.
• Schedule periodic audits of recently imported data.

For detailed object-specific requirements and the latest interface screenshots, refer to the official documentation: HubSpot single-object import guide.

Investing time in careful mapping and testing will help you build a reliable database that powers accurate reports, workflows, and ongoing marketing and sales automation.

Need Help With Hubspot?

If you want expert help building, automating, or scaling your Hubspot , work with ConsultEvo, a team who has a decade of Hubspot experience.

Scale Hubspot

“`