# Allow importing empty property values **URL:** \ **Category:** HubSpot Ideas\ **Tags:** properties\ **Created:** [August 6, 2021, 9:00am UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934 "2021-08-06T09:00:29Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Andreas007](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/andreas007/32/62359_2.png) [@Andreas007](https://community.hubspot.com/u/Andreas007)\ **Post date:** [August 6, 2021, 9:00am UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/1 "2021-08-06T09:00:29Z")
Hi I have created a new property (because we got smarter over time) and I wanted to transfer the values of an existing property to that new property. Populating the new property was easy. But emptying the values of the existing property turned out to be difficult. HubSpot seems to prohibit this intentionally, when you consult the support page ([Review and troubleshoot record import errors](https://knowledge.hubspot.com/crm-setup/troubleshoot-import-errors)). I couldn’t figure out why, and felt a bit like a user, which needs to be protected from himself :-). There are workarounds, but not very nice ones: “Bulk edit” or creating a workflow to empty the property values are two. But the stay workarounds. I think, HubSpot should offer the possibility to empty property values via the import functionality. Thanks for considering this request. KR, Andreas ---
**Author:** ![CPurcell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/cpurcell/32/84335_2.png) [@CPurcell](https://community.hubspot.com/u/CPurcell)\ **Post date:** [August 12, 2021, 9:39pm UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/2 "2021-08-12T21:39:45Z")
I am having issues with this recently as well. I would expect that there should be a box to tick if you want to enable overwriting a populated field to blank via a list import. Like it doesn’t need to be on by default, but should be a choice. ---
**Author:** ![CChristenson2](https://avatars.discourse-cdn.com/v4/letter/c/e8c25b/32.png) [@CChristenson2](https://community.hubspot.com/u/CChristenson2)\ **Post date:** [May 4, 2022, 1:46pm UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/3 "2022-05-04T13:46:13Z")
I agree this feature would be very helpful in managing the ever changing propery values in our contact list. For us not being able to easily clear a property value for a contact leads to contacts staying on lists that they no longer qualify for and receiving marketing emails that are not relevent to them. Please update the Import API to add this feature. ---
**Author:** ![dambra](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dambra/32/87321_2.png) [@dambra](https://community.hubspot.com/u/dambra)\ **Post date:** [July 7, 2022, 1:49am UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/4 "2022-07-07T01:49:45Z")
I’d love to see this as well. Our sales team was using some of the standard properties incorrectly and entered data into the incorrect property. It’s easy to move that data to another property via workflow or import, but I cannot easily clear the property after the data is moved. ---
**Author:** ![RLightfoot](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rlightfoot/32/2317_2.png) [@RLightfoot](https://community.hubspot.com/u/RLightfoot)\ **Post date:** [July 21, 2022, 12:20am UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/5 "2022-07-21T00:20:35Z")
**100% Agree! 🙂** When Importing a list, we should be able to select, “Allow NULL Values to overwrite existing HS values” - this would still protect those that need protecting 🙂 Provide this option for every mapped field/property (maybe in the same dropdown list where we can choose, “do not import”) There are so many powerful features in HubSpot, this would definitely be another. ---
**Author:** ![BBellon](https://avatars.discourse-cdn.com/v4/letter/b/59ef9b/32.png) [@BBellon](https://community.hubspot.com/u/BBellon)\ **Post date:** [August 9, 2023, 11:53pm UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/6 "2023-08-09T23:53:05Z")
This is necessary. Salesforce makes this easy with an option to toggle on to allow an overwrite of null values. ---
**Author:** ![PranasZiaukas](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@PranasZiaukas](https://community.hubspot.com/u/PranasZiaukas)\ **Post date:** [August 10, 2023, 10:00am UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/7 "2023-08-10T10:00:13Z")
Lack of this setting makes it unreasonably difficult to delete property values. No official response in 2+ years though, so I’m not holding my breath… ---
**Author:** ![DHalliNet](https://avatars.discourse-cdn.com/v4/letter/d/9de053/32.png) [@DHalliNet](https://community.hubspot.com/u/DHalliNet)\ **Post date:** [November 8, 2023, 6:24pm UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/8 "2023-11-08T18:24:25Z")
This needs to be implemented. For Customer who migrate from another CRM to Hubspot, they must be able to come though and reset and No or NA dropdown values to have (No value) in order to work the way Hubspot wants to work. ---
**Author:** ![dbarbuti](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dbarbuti/32/29572_2.png) [@dbarbuti](https://community.hubspot.com/u/dbarbuti)\ **Post date:** [November 14, 2023, 8:44am UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/9 "2023-11-14T08:44:20Z")
I completely agree. An “empty string” should clear the value like using APIs. ---
**Author:** ![fborgosano](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fborgosano/32/18373_2.png) [@fborgosano](https://community.hubspot.com/u/fborgosano)\ **Post date:** [January 20, 2024, 2:13am UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/10 "2024-01-20T02:13:38Z")
I have the same problem since the beginning. In the first imports, when I migrated my database to Hubspot, I did a horrible mistake and now I have thousands of contacts with the company name (for example) in the First Name or Last Name fields. I’d like to just bulk erase the values in those fields of those contacts but no way… ---
**Author:** ![fborgosano](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fborgosano/32/18373_2.png) [@fborgosano](https://community.hubspot.com/u/fborgosano)\ **Post date:** [January 20, 2024, 9:50pm UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/11 "2024-01-20T21:50:20Z")
I’m trying, with the help of ChatGPT, to build up a private app that could help us to resolve this issue with a Python script. Any help and ideas are very welcomed. At the moment, I’m trying to understand how the endpoint URL of the app should be. ---
**Author:** ![YvonneKlich](https://avatars.discourse-cdn.com/v4/letter/y/5e9695/32.png) [@YvonneKlich](https://community.hubspot.com/u/YvonneKlich)\ **Post date:** [December 10, 2024, 10:12am UTC](https://community.hubspot.com/t/allow-importing-empty-property-values/41934/12 "2024-12-10T10:12:17Z")
Solution Idea: in workflows there is the action “clear property value”, so in import you create a list and then set a one-off workflow to clear the property value for the list imported. Hope this helps 🙂