set multiple previously owned contacts to no owner

[EBrake]

A sales team member is leaving our team for the first time since we installed HubSpot. I have reassigned all of his companies to new owners, and many of his contacts have also been reassigned. However, this are ~160 contacts that will not receive new owners. Therefore the owner field should be blank.

I thought that if I left the field blank in my import file for those contacts that the blank field would overwrite the existing data. However that did not happen. The old owner is still associated with the record. (I know the import worked because the new owners were all successfully assigned in the same process.)

How can I remove contact owner designations and leave the field blank via import?

Thank you!

[lcoburn]

Is there a way to do this if you want to do it via import?  I have tried changing the data point to "No Owner" in the import sheet, and the import interface flags it as an error that I can either ignore or bulk change to a specific user, but "No Owner" is not an option in the import interface.

[karstenkoehler · Accepted solution]

Hi @EBrake,

Just to summarize, there are contacts who still have the contact owner assigned that have left the company and you want to clear it?

If so, you don't need an import here. Simply make the change directly in the HubSpot user interface: https://knowledge.hubspot.com/crm-setup/how-to-set-an-owner#assign-an-owner-from-the-object-s-index-...

On Menu > Contacts > Contacts, filter for contacts assigned to this user, then use the Assign button to assign them to no one:

Best regards!

[Ohska]

@karstenkoehler - What to do when you have thousends of records to assign? through the inteface it can take ages. what am I missing? 

I need to reassign to "no owner" 4.5k companies

[EBrake]

Thank you! I thought I would have to do them 1 at a time via the interface, so this was helpful.