# How clean or delete properties? **URL:** \ **Category:** CRM\ **Tags:** professional\ **Created:** [March 12, 2024, 9:06am UTC](https://community.hubspot.com/t/how-clean-or-delete-properties/102300 "2024-03-12T09:06:50Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![phtheref](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/phtheref/32/2490_2.png) [@phtheref](https://community.hubspot.com/u/phtheref)\ **Post date:** [March 12, 2024, 9:06am UTC](https://community.hubspot.com/t/how-clean-or-delete-properties/102300/1 "2024-03-12T09:06:50Z")
Hi! How can I clean companies properties if needed. I mean - I don’t want to delete property but for examples I have 100 companies with property name: sold\_products - where is multiple values I need to clean current values and update those new ones. What is best way to do this? ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [March 12, 2024, 9:11am UTC](https://community.hubspot.com/t/how-clean-or-delete-properties/102300/2 "2024-03-12T09:11:22Z")
Hi @phtheref, Just to confirm, you have one dropdown/checkboxes property and you want to update the values? Generally, if you can, your best option is to simply **rename** the existing options, instead of deleting them and creating new ones. While the internal label will stay the same (e.g. when referencing the property through API), the displayed value in the CRM will reflect your renamed update. If renaming is not an option, you would have to do the following: 1. Create new option in your property settings 2. On the company index page, filter all of the companies which have the old value 3. Bulk edit them and set/append the new value: [Bulk edit records](https://knowledge.hubspot.com/records/bulk-edit-records) 4. Delete the old value in the property settings If you share more details, I can elaborate. Best regards ---
**Author:** ![phtheref](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/phtheref/32/2490_2.png) [@phtheref](https://community.hubspot.com/u/phtheref)\ **Post date:** [March 12, 2024, 9:30am UTC](https://community.hubspot.com/t/how-clean-or-delete-properties/102300/3 "2024-03-12T09:30:16Z")
Hi! Thx for fast answer… I’ll describe better our situation. First of all - we don’t have integration between Economic ERP and Hubspot which causes this situation. I have customer\_type property for companies which values includes different services which we are offering to the customer. Then I have identical values for contac\_type\_marketing property and there is an automation which keeps these values same at company and contacts under this company (because marketing is doing with contacts). These customer\_type values are old and not updated properly and I got export from economical ERP which includes customer name, domain and all products/services we are invoicing from customers. What I need to do because customer\_type values are not valid anymore: - import new data from xls-file - delete old data values from this customer\_type property - Put this new data values for each customer customer\_type property ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [March 12, 2024, 9:34am UTC](https://community.hubspot.com/t/how-clean-or-delete-properties/102300/4 "2024-03-12T09:34:13Z")
> * * * > > @phtheref wrote: > > Then I have identical values for contac\_type\_marketing property and there is an automation which keeps these values same at company and contacts under this company (because marketing is doing with contacts). > > * * * This isn’t needed, are you aware of that? You can easily build contact lists off company properties - and I’d strongly recommend doing so. I’m not sure I 100% follow your explanation but generally, the steps remain the same: 1. Store the old values in a safe place (export, other property, new value) 2. Remove the old value after Best regards! ---
**Author:** ![phtheref](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/phtheref/32/2490_2.png) [@phtheref](https://community.hubspot.com/u/phtheref)\ **Post date:** [March 12, 2024, 10:39am UTC](https://community.hubspot.com/t/how-clean-or-delete-properties/102300/5 "2024-03-12T10:39:29Z")
Hmm… I should probably use chatgpt or something for better English 😉 Point 1: This is clear and easy Point2: How am I able to remove old values from 3647 companies? So… if I am import “new data” to the customer\_type value - how old values are deleted? ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [March 12, 2024, 10:43am UTC](https://community.hubspot.com/t/how-clean-or-delete-properties/102300/6 "2024-03-12T10:43:17Z")
@phtheref to my knowledge, it’s currently not possible to remove values from multiple checkboxes via the user interface or via import, see here: [https://community.hubspot.com/t5/HubSpot-Ideas/Delete-or-clear-specific-values-from-multiple-checkbox-property/idi-p/34405](https://community.hubspot.com/t5/HubSpot-Ideas/Delete-or-clear-specific-values-from-multiple-checkbox-property/idi-p/34405) You would have to clear the entire property including all values (e.g. using the “Clear property value” in workflows or by bulk editing and removing all values). This in turn means that you need to store all values before making changes. ---
**Author:** ![Lucila-Andimol](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lucila-andimol/32/69276_2.png) [@Lucila-Andimol](https://community.hubspot.com/u/Lucila-Andimol)\ **Post date:** [March 12, 2024, 11:29am UTC](https://community.hubspot.com/t/how-clean-or-delete-properties/102300/7 "2024-03-12T11:29:09Z")
If you are doing this in bulk from the Contacts/company records list the tool will ask you if you want to replace or append the value to the Multiple check property like this ![Screenshot 2024-03-12 at 12.22.15.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/5/25a6ee8c2b23539232ca80f0773304825266c286.png) If you want to this from an import I will clear all the info the Property and then let the import set the new values To clear the values in the property you select all the companies select the edit button ![Screenshot 2024-03-12 at 12.28.03.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/7/07a2e7eaa95df592f9140ca3c902361ae2491899.png) search for the property you want to clear “customer\_type property” and choose Replace value and leave the option blank like this ![Screenshot 2024-03-12 at 12.26.35.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/2/325454889b361de9ed4ecdb1a38e5fa7a20e554f.png) This will reset in bulk the property values. Then you import and set the new values ---
**Author:** ![Lucila-Andimol](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lucila-andimol/32/69276_2.png) [@Lucila-Andimol](https://community.hubspot.com/u/Lucila-Andimol)\ **Post date:** [March 12, 2024, 10:30am UTC](https://community.hubspot.com/t/how-clean-or-delete-properties/102300/8 "2024-03-12T10:30:59Z")
Hey @phtheref so you have multiple options here you can create a new property and migrate the information from the old property into the new one (of course if you are using automations you will need to modifiy and add the new property) Another options is within the same property you are already using, to create the new values needed, and import the file to match this new values. Then you can merge the old values with the new one to unify and update all the information. here is an example ![Screenshot 2024-03-12 at 11.30.07.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/e/fe7f3846564114f7b1cf19997b3076cc0f185fe6.png) ![Screenshot 2024-03-12 at 11.30.28.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/d/1dd59f524c9625427ac9d25458d6b84b31ba0d0e.png) . Hope this helps. Let me know if you have any question