Import data to checkbox properties
Last updated: January 18, 2023
Applies to:
All products and plans |
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.
Related content
-
Import records and activities
To add or update data in bulk, you can import files into HubSpot. You can import records, such as contacts...
Knowledge Base -
Review and troubleshoot import errors
When importing records or activities into HubSpot, you may encounter errors. Below, learn how to resolve...
Knowledge Base -
Assign ownership of records
HubSpot uses the [Object] owner properties to set the ownership of a contact, company, deal, ticket, or...
Knowledge Base