How to Bulk Update Record Owners in HubSpot

Record ownership in HubSpot determines who is responsible for a contact, company, deal, or ticket. It drives notifications, task assignments, activity feeds, reporting, and the daily view each rep sees when they log in. When ownership is wrong — or when it needs to change across hundreds of records — the impact ripples through your entire sales operation.

Ownership changes happen more often than most teams anticipate. A rep leaves the company. Territories get redrawn after a planning session. A new hire needs a book of business. An integration created leads without assigning owners. A round-robin misfired and sent everything to one person. Each situation demands a different approach to bulk reassignment.

Understanding HubSpot's owner property

The "owner" properties in HubSpot — Contact owner, Company owner, Deal owner, Ticket owner — are not simple text fields. They are HubSpot user references. The stored value is the owner's internal HubSpot user ID (a number), not their name or email.

This means:

• You can't set an owner by typing a name. You need to select from the list of HubSpot users.
• If a user is deactivated or removed from HubSpot, records assigned to them still show the owner (grayed out), but the owner can't log in, receive notifications, or see those records in their "My" views.
• Ownership is per-object. A contact, their associated company, and their deal can all have different owners. This is by design (supporting account executives vs. CSMs vs. SDRs) but also creates maintenance overhead.

When bulk ownership changes are needed

Rep departure

The most urgent scenario. A rep leaves the company, and their entire book — contacts, companies, deals, tickets — needs redistribution. Speed matters: unowned records mean missed follow-ups.

Territory realignment

Quarterly or annual territory changes mean hundreds of contacts shifting between reps based on geography, company size, industry, or other segmentation criteria. This is typically planned and can be executed methodically.

New hire onboarding

A new rep needs accounts to work. You might carve out a subset of another rep's book, assign unowned records, or distribute a fresh batch of leads.

Integration or import cleanup

Records created by integrations (Zapier, Salesforce sync, web forms) sometimes come in without an owner, or with the wrong owner. Bulk assignment fixes this.

Round-robin correction

HubSpot's round-robin assignment sometimes distributes unevenly, especially if reps were temporarily removed or if the assignment rotation was modified. Rebalancing requires moving records between reps.

Method 1: Bulk edit in the HubSpot UI

The simplest approach for moderate batches.

1. Navigate to the object you want to update (Contacts, Companies, Deals, or Tickets)
2. Filter to isolate the records that need reassignment. Common filters:
   • Current owner: Select the departing rep
   • Lead status: Select leads at a specific status
   • Company property (geography, industry, size): For territory-based reassignment
   • Create date: For recently imported records without owners
3. Select records using checkboxes (use "Select all" for the entire filtered list)
4. Click Edit in the toolbar
5. Select the owner property (e.g., "Contact owner")
6. Choose the new owner from the dropdown
7. Click Update

Key limitation: All selected records get the same new owner. If you're redistributing a departing rep's 600 contacts across three remaining reps (200 each), you need to:

• Filter to the first 200 (use an additional filter like company name range or creation date to split them)
• Assign to Rep A
• Filter to the next batch
• Assign to Rep B
• Repeat for Rep C

This manual splitting is tedious and imprecise. For fair distribution, you're better off with a workflow or import.

Method 2: Workflows for automated assignment

Workflows handle conditional ownership assignment well, especially for ongoing automation.

Territory-based assignment:

1. Create a contact-based workflow
2. Enrollment trigger: Contact owner is [departing rep] (or Contact owner is unknown, for new leads)
3. If/then branch on geography (or industry, or company size):
   • If state is in [CA, OR, WA]: Set owner to [West Coast rep]
   • If state is in [NY, NJ, CT]: Set owner to [East Coast rep]
   • If state is in [TX, FL, GA]: Set owner to [South rep]
   • Default: Set owner to [Catch-all rep or round-robin]
4. Enable "Enroll existing contacts" to process current records

Round-robin assignment:

HubSpot workflows support a "Rotate record to owner" action that distributes records evenly across a list of users. Use this when you want equal distribution without specific criteria.

1. Enrollment trigger: Contact owner is [departing rep]
2. Action: Rotate record to owner > Select the receiving reps
3. Enable "Enroll existing contacts"

Watch out for:

• Associated records. Changing a contact's owner doesn't automatically change the associated company's or deal's owner. You may need separate workflows for each object type.
• Notification storm. When ownership changes trigger notifications (HubSpot can notify the new owner), a bulk reassignment of 1,000 records sends 1,000 notifications. Consider temporarily disabling ownership change notifications before running the bulk update.
• Workflow processing time. Enrolling thousands of records takes time. HubSpot processes workflow actions sequentially, so a batch of 5,000 contacts might take 15-30 minutes to fully process.

Method 3: CSV import

For complex redistribution with per-record control.

1. Export the records to reassign (include Record ID and current owner)
2. Add a column for the new owner — use the owner's email address (HubSpot maps email to user during import)
3. Assign new owners in the spreadsheet based on your criteria
4. Import the CSV, mapping the owner column to the appropriate owner property and the Record ID column to match existing records

CSV import advantages:

• You can assign different owners to different records in a single import
• It handles complex territory logic (using spreadsheet formulas like VLOOKUP against a territory mapping table)
• You have a complete before/after record in the spreadsheet

CSV import risks:

• An incorrect email address in the owner column will fail silently or create unexpected assignments
• No undo — export the current state as backup before importing
• Deactivated HubSpot users can't be assigned as owners via import

Method 4: Search and replace for owner text references

While the owner property itself is a user ID (not editable via text search and replace), there are text properties throughout HubSpot that reference owners by name:

• Deal descriptions: "Talk to Sarah's team about pricing"
• Notes: "Per John's recommendation, escalating to enterprise"
• Custom properties: "Referred by: Mike Thompson"

When ownership changes due to a rep leaving or territory change, these text references become stale. The records now belong to a new rep, but notes still reference the old one.

SearchReplace can find and update these text references. Search for the departing rep's name across notes, descriptions, and custom text properties, and replace with the new owner's name or a neutral reference. This keeps the historical context accurate for anyone reading the record later.

Handling all four object types

A complete ownership transition touches multiple object types. Here's the recommended order:

1. Contacts first

Contacts are the most numerous and the most actively worked. Reassign these first so reps can start engaging immediately.

2. Companies second

Company ownership determines who manages the account relationship. In many setups, the company owner should match the primary contact owner. After reassigning contacts, update company ownership to match.

If you use HubSpot's "sync owner between company and contact" setting (Settings > Objects > Companies), changing the contact owner may automatically update the company owner. Check your settings before running a separate company update — you might be doubling the work.

3. Deals third

Deal ownership determines pipeline visibility and forecasting attribution. Active deals (not Closed Won or Closed Lost) are the priority — these need immediate attention from the new owner.

For closed deals, you have a choice: reassign to the new territory owner (which changes historical reporting attribution) or leave with the original owner (preserving accurate historical attribution). Most sales leaders prefer to leave closed deal ownership unchanged for accurate reporting.

4. Tickets last

If you use HubSpot Service Hub, ticket ownership determines who handles support issues. Reassign open tickets to whoever is taking over the account relationship.

Post-reassignment checklist

After bulk ownership changes, verify and communicate:

Verify the numbers:

• Check each rep's record count in the Contacts, Companies, and Deals views
• Confirm the departing rep (if applicable) has zero assigned records, or only closed historical records

Update related settings:

• Meeting scheduling links: If the departing rep had a meetings link, update any pages or emails that referenced it
• Email sequences: Any active sequences owned by the departing rep will stop. Re-enroll affected contacts in new sequences with the new owner
• Tasks: Reassign any open tasks from the departing rep

Communicate the change:

• Notify receiving reps about their new records. Ideally, provide a list or saved view they can reference
• Brief reps on any context — "These contacts were in mid-conversation about X" or "These accounts were up for renewal in Q2"
• Update any dashboards or reports filtered by owner

Clean up the departing user:

• Deactivate the HubSpot user account (don't delete — deactivation preserves history)
• Remove from any teams, round-robin rotations, or workflow assignments
• Check for any workflows triggered by "owner is [departing rep]" and update the criteria

Ownership transitions are operationally complex because they touch every part of the CRM. The technical bulk update is actually the easy part — the communication, context transfer, and downstream cleanup are what determine whether the transition succeeds or whether leads fall through the cracks. Plan for the full scope, not just the property change.