Import data to checkbox properties

When importing records, you may have to format data to suit the property's field type.  Learn how to import and append values to a multiple checkboxes property and to update a regular checkbox property.

Add values to a multiple checkboxes property in an import

To add or append values to a multiple checkboxes property, add a semicolon before the first value. This will append the value instead of overwriting the existing property.

To import multiple values, in your import file, add a semicolon between each value (;value 2;value 3; value 4). These property options must be created prior to the import.

For example, if you have a Items property and a contact with the value lawn mowers, you can import additional values to the property for that contact. To do so, include the following in the corresponding column of your CSV for that contact:

;scissors;hedgers;clippers

Add values to a single on/off checkbox field in an import

In the import file, create a column for the single checkbox field and set the value on each line to:

• True or Yes, to display as Yes or checked in HubSpot; or
• False or No, to display as No or not checked in HubSpot.