How to Import Multiple Checkbox Property Values in HubSpot

Managing multiple checkbox properties in HubSpot during imports can be confusing if you are not clear on how values are added, replaced, or removed. This guide explains how imports interact with these properties so you can protect your data and update records accurately.

Multiple checkbox properties let you store several values in one field. When you import data into these properties, HubSpot follows specific rules that determine whether values are added, overwritten, or cleared. Understanding these rules before importing helps you avoid accidental data loss.

Key Concepts for Multiple Checkbox Imports in HubSpot

Before running any import, it is important to understand how multiple checkbox properties work in HubSpot and how the CRM reads values from your file.

• Each checkbox option in a property has an internal value.
• Your import file must match these internal values exactly.
• Fields can either be left blank, contain one value, or contain multiple values separated correctly.
• The import setting you choose determines whether values are added to existing ones or replace them.

If you are unsure how your properties are configured or need strategic help planning your data structure, you can consult a specialized HubSpot partner such as Consultevo for CRM setup and optimization.

How HubSpot Handles Multiple Checkbox Values on Import

When you import into a multiple checkbox property in HubSpot, the system treats each cell of your file as the complete set of values you want for that record, depending on the import options and the existing data.

There are two primary behaviors:

1. Adding new values while keeping existing ones.
2. Replacing existing values entirely.

The behavior depends on how you set up your import and whether the cell in your file is empty or contains specific option values.

Adding Values to Existing Multiple Checkbox Properties in HubSpot

You can configure your import so that new values are added to a multiple checkbox property without deleting what is already stored for those records.

When HubSpot Adds Values Without Overwriting

HubSpot can append new checkbox values to a record if your import file cell contains values and you choose the relevant import behavior. Existing values remain, and new ones are added if they are not already present.

For example, if a contact currently has a multiple checkbox property set to Option A; Option B and your import file includes Option C in that column for the same contact, the result can become Option A; Option B; Option C depending on your import settings.

Required Formatting for Multiple Checkbox Values in HubSpot

To ensure values are added correctly, your import file must be formatted properly:

• Use the exact internal value for each checkbox option.
• Separate multiple values for the same property with a semicolon and a space (e.g., Option A; Option B), or with the separator format defined in the import instructions.
• Do not include values that do not exist as options in the property settings.

If a value in your file does not match any existing option in HubSpot, the import will ignore that value for the multiple checkbox property.

Replacing Existing Multiple Checkbox Values in HubSpot

Sometimes you may want your import to overwrite the current values of a multiple checkbox property in HubSpot. This is useful when you are resetting preferences, updating subscription flags, or correcting incorrect data.

How Overwrite Behavior Works

When configured to replace values, your import file tells HubSpot what the final set of values should be for the property on each record.

• If the cell contains one or more valid values, HubSpot will replace any existing values with only the values from the file.
• If the cell is empty and you allow overwrites, HubSpot can clear out the existing values entirely for that property on the record.

Because replacement can erase values, always double-check the property mapping and the overwrite settings before starting the import.

Clearing Multiple Checkbox Values in HubSpot

You can also use imports to clear out multiple checkbox properties. This is controlled both by the values in your file and by the advanced property options you choose during the import process.

Common ways this is handled include:

• Leaving the column blank when overwrite behavior is enabled, causing HubSpot to remove existing values for that property.
• Using a dedicated clear or null behavior if provided in the import options.

Always review a small test import first so you can confirm that empty cells behave as expected before processing large datasets.

Step-by-Step: Importing Multiple Checkbox Values in HubSpot

The exact interface may change over time, but the general workflow for importing and updating multiple checkbox properties in HubSpot follows this pattern.

1. Prepare Your File

• Export a sample of existing records first so you can see how multiple checkbox data is currently stored.
• Create or edit a CSV or Excel file with columns that match your target properties.
• In your multiple checkbox column, enter the correct internal values for each record.
• For records that need more than one value, separate options using the standard delimiter (for example, Value 1; Value 2).

2. Start an Import in HubSpot

• Go to your contacts, companies, deals, tickets, or custom object index page.
• Click the import option to begin a new file upload.
• Upload your prepared CSV or Excel file.

3. Map Columns to Multiple Checkbox Properties in HubSpot

• When prompted, map your multiple checkbox column to the correct property in HubSpot.
• Verify you are mapping to a property of type Multiple checkboxes, not single checkbox or dropdown.
• Review that each property mapping looks correct before continuing.

4. Choose Add or Replace Behavior

During the import process, HubSpot may present options that control how property values are updated. The exact labels can vary, but they will typically govern whether to append or overwrite values.

• Select the behavior that adds values if you want to keep existing options and only append new ones.
• Select the behavior that replaces existing values if you want the import to define the final set of options for each record.
• If there is an option related to clearing empty values, decide whether blank cells should remove existing property values.

5. Review and Complete the Import

• Use the final review screen to confirm the mapped properties and behavior.
• Start the import and wait for processing to finish.
• Once done, open a few records and inspect the multiple checkbox property to confirm that values were added, replaced, or cleared as intended.

Best Practices for Multiple Checkbox Imports in HubSpot

To keep your CRM reliable, follow these recommended practices whenever you work with multiple checkbox properties in HubSpot.

• Test with a small file first: Import a few rows to validate behavior before running a full update.
• Use consistent internal values: Copy internal values directly from the property settings to avoid typos.
• Document your import rules: Record when you use add vs. replace behavior so your team understands historical changes.
• Back up critical data: Export affected records before large imports in case you need to restore previous values.

For a complete, authoritative reference straight from the platform documentation, review the official HubSpot guide on importing multiple checkbox values here: HubSpot multiple checkbox import documentation.

Conclusion: Control Your Checkbox Data in HubSpot

When you understand how multiple checkbox imports behave in HubSpot, you can safely update complex preference fields, segment data more accurately, and avoid unexpected overwrites. By planning your file structure, choosing the right add or replace options, and testing on a small sample first, you ensure that your imports enhance your CRM instead of disrupting it.

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

“`