# Prevent data overwriting on import **URL:** \ **Category:** CRM\ **Tags:** contacts\ **Created:** [June 15, 2020, 1:39pm UTC](https://community.hubspot.com/t/prevent-data-overwriting-on-import/21703 "2020-06-15T13:39:23Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Jzitek](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jzitek/32/9140_2.png) [@Jzitek](https://community.hubspot.com/u/Jzitek)\ **Post date:** [June 15, 2020, 1:39pm UTC](https://community.hubspot.com/t/prevent-data-overwriting-on-import/21703/1 "2020-06-15T13:39:23Z")
Our company would like to see a function available to stop data from being overwritten when importing. We would like something like a wizard with two columns to show existing data vs. new data being imported with the option to prevent overwriting for any property that has important existing information. ---
**Author:** ![AdamLPW](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/adamlpw/32/29368_2.png) [@AdamLPW](https://community.hubspot.com/u/AdamLPW)\ **Post date:** [June 15, 2020, 1:46pm UTC](https://community.hubspot.com/t/prevent-data-overwriting-on-import/21703/2 "2020-06-15T13:46:37Z")
Hi @Jzitek, This is a good idea - I’m often importing over the top of existing data and having to manually correct. I’d recommend you post this in the ideas board - [https://community.hubspot.com/t5/HubSpot-Ideas/idb-p/HubSpot\_Ideas](https://community.hubspot.com/t5/HubSpot-Ideas/idb-p/HubSpot_Ideas) as it’s more likely to be picked up by developers there. Ouf of interest, what data is it that’s being overwritten? I have some manual work-arounds I use to sanitise my data pre import which might help. ---
**Author:** ![Jzitek](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jzitek/32/9140_2.png) [@Jzitek](https://community.hubspot.com/u/Jzitek)\ **Post date:** [July 9, 2020, 8:44pm UTC](https://community.hubspot.com/t/prevent-data-overwriting-on-import/21703/3 "2020-07-09T20:44:46Z")
Hi @AdamLPW , thanks for the correction. I thought I had submitted in the correct area, but I’ve posted it to the ideas now! There isn’t necessarily one thing being overwritten, it is more of a concern of overwriting. We have a large company and so we are wanting to avoid super users from various areas overwriting some of the data for contacts that may overlap in different business interests. I would be curious to hear what your manual work around is to see if that could help our users. Thanks! ---
**Author:** ![Jzitek](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jzitek/32/9140_2.png) [@Jzitek](https://community.hubspot.com/u/Jzitek)\ **Post date:** [July 9, 2020, 9:13pm UTC](https://community.hubspot.com/t/prevent-data-overwriting-on-import/21703/4 "2020-07-09T21:13:25Z")
Hi again @AdamLPW , I guess I had it out on the idea forum as well (so now I have 2 idea submissions and one here…one way to get heard!) Here it is if you wouldn’t mind an upvote! [https://community.hubspot.com/t5/HubSpot-Ideas/Disable-overwrite-on-import-and-allow-option-to-choose-from-new/idi-p/335928](https://community.hubspot.com/t5/HubSpot-Ideas/Disable-overwrite-on-import-and-allow-option-to-choose-from-new/idi-p/335928) ---
**Author:** ![AdamLPW](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/adamlpw/32/29368_2.png) [@AdamLPW](https://community.hubspot.com/u/AdamLPW)\ **Post date:** [July 10, 2020, 8:17am UTC](https://community.hubspot.com/t/prevent-data-overwriting-on-import/21703/5 "2020-07-10T08:17:13Z")
Upvoted! In terms of work-arounds - I’m sure you’re already getting to know the “frequent offenders” in terms of the kind of data and/or the fields that get overwritten on import. I literally just spend some time vetting my data in Excel prior to import, while it’s all in one place, rather than fixing on individual contact records post-import. I will also, on occasion, NOT match columns in an import which I know will cause issues. This is especially true where the data in HubSpot for that property is more correct/up-to-date than my external data. ---
**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:** [June 8, 2021, 1:22pm UTC](https://community.hubspot.com/t/prevent-data-overwriting-on-import/21703/6 "2021-06-08T13:22:00Z")
Hi @Jzitek , It’s been a while since you posted this but I wanted to share an update: This is now possible! During the mapping step of the import process, you should see the option to not overwrite existing values: ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/3/33af7d09c4e59f317f6c80f19b54f62ff08760a3.png) If this answers your original question, you can help the community by marking this post as a solution. Cheers! ---
**Author:** ![Jzitek](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jzitek/32/9140_2.png) [@Jzitek](https://community.hubspot.com/u/Jzitek)\ **Post date:** [June 10, 2021, 3:31pm UTC](https://community.hubspot.com/t/prevent-data-overwriting-on-import/21703/7 "2021-06-10T15:31:56Z")
It is a good compromise solution for now. We would still like the ability to see what data exists already to say which data we want to keep and which we want to update.