Bulk edit records
Last updated: March 22, 2023
Available with any of the following subscriptions, except where noted:
|
In HubSpot, you can edit your records in bulk. This includes your contacts, companies, deals, tickets, custom objects, and calls.
For example, you can edit records in bulk to:
- Assign records to a user
- Edit a property value for multiple records
- Create tasks associated with records
- Add records to a static list (Contacts and companies only)
Edit records from the object index page
- Navigate to your records:
- Contacts: In your HubSpot account, navigate to Contacts > Contacts.
- Companies: In your HubSpot account, navigate to Contacts > Companies.
- Deals: In your HubSpot account, navigate to Sales > Deals.
- Tickets: In your HubSpot account, navigate to Service > Tickets.
- Custom objects: In your HubSpot account, navigate to Contacts > [Custom object]. If your account has more than one custom object, hover over Custom Objects, then select the custom object you want to view.
- Calls: In your HubSpot account, navigate to Contacts > Calls.
-
Select the records you want to edit. You can apply a view to your table to filter out the records you want to edit.
- To select multiple individual records:
- In the table view, select the checkboxes next to the records.
- In the board view for deals and tickets, hover over a record, then select the checkbox. Once one record card is selected, checkboxes will appear on all remaining cards for you to select.
-
To select all of the records on your current page or pipeline, select the checkbox at the top left of the table or board. In table view, to select all of the records in the view, click the Select all [number] [records] link.
-
At the top of the table, select from the following actions:
-
-
Assign: select to assign the selected records to a new user. In the dialog box, select the user and click Assign.
-
Edit: select to edit the values of a specific property in these records. You can also edit property values directly in the table.
-
In the dialog box, click the Property to update dropdown menu and select the property you want to edit.
-
-
Please note: while in board view, you cannot bulk edit the pipeline or stage/status properties. To edit an individual record's stage/status property in board view, click and drag the record to another column. To update the stage/status or pipeline properties for multiple records, switch to table view.
-
-
-
In the field that appears, enter or select a new value for the selected property. For multi-select properties:
- To add new values while maintaining the existing values, select Append to current value(s).
- To overwrite the existing values, select Replace current values(s).
-
Click Update. For text or single-select properties, this will overwrite the old values in the property for these records.
-
-
-
-
Delete: select to delete the records. In the dialog box, enter the number of records and click Delete. Users must have Bulk delete permission to delete multiple records.
-
Create tasks: select to add a task to each selected record. In the right panel, enter values to create your tasks. This option will only create tasks for records selected on the current page, even if all records, including those on other pages, are selected.
-
Please note: the bulk actions available for custom object records and call records are only Edit and Delete.
-
For company records, at the top of the table, you can also select Add to Static List. In the dialog box, click the Search dropdown menu and select the static list you want to add the companies to, then click Add.
-
For contact records, at the top of the table, you can also select:
-
-
Enroll in sequence (Sales Hub or Service Hub Professional and Enterprise only): select to enroll the selected contacts in a sequence.
-
More: select additional options in the dropdown menu. The options are:
-
Edit records with an import
You can also update records in bulk with an import. In the import file, include the following data:
- Unique IDs for your existing records (Email for contacts, Company domain name for Companies, or [Object] ID for any object)
- Properties you want to update (e.g., an Owner column to assign records in bulk, a Lifecycle stage column to bulk update contacts’ lifecycle stages) and their values
Once you’ve set up your file with the records you’d like to update, import your file.
Edit records with a workflow
Users in Professional or Enterprise accounts can also set a property value for multiple records using workflows. Learn how to manage properties with workflow actions.
Related content
-
Deduplicate records in HubSpot
HubSpot automatically deduplicates contacts using email addresses, and companies using domain names. Record...
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 -
Create and edit properties
Properties are fields that store information on HubSpot records. For example, you can use the City company...
Knowledge Base