# Issues when importing contact data **URL:** \ **Category:** CRM\ **Tags:** crm\ **Created:** [July 12, 2023, 12:47pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171 "2023-07-12T12:47:21Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![RM88](https://avatars.discourse-cdn.com/v4/letter/r/47e85d/32.png) [@RM88](https://community.hubspot.com/u/RM88)\ **Post date:** [July 12, 2023, 12:47pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/1 "2023-07-12T12:47:21Z")
I have imported a list of contacts from an old ESP and i have come across a record where the import has added an additional email address to the same record. However they are two seperate contacts and it should not have added the email address as an additonal email and it has also overwritten the last name field. How can i stop this going forwards? How can i identify any other records this might have occured to? ---
**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:** [July 12, 2023, 12:52pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/2 "2023-07-12T12:52:30Z")
Hi @RM88, This depends a bit on how your import file was set up but generally, if a contact has two email addresses and they appear in different rows of an import file, HubSpot has no way of knowing that they should be automatically merged. When you find these duplicates, you can follow these steps to merge them: [Deduplicate records in HubSpot](https://knowledge.hubspot.com/crm-setup/deduplication-of-contacts-companies-deals-tickets) If you want to implement a system to automatically identify these duplicates, I’d recommend integrating with Insycle: [HubSpot Data Standardization & Cleansing | Insycle](https://www.insycle.com/hubspot/) Best regards! ---
**Author:** ![RM88](https://avatars.discourse-cdn.com/v4/letter/r/47e85d/32.png) [@RM88](https://community.hubspot.com/u/RM88)\ **Post date:** [July 12, 2023, 2:45pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/3 "2023-07-12T14:45:33Z")
@karstenkoehler its not case of two records being created and needed to be merged but actually an extra email address added to a contact record when it should have created a new record as the email address does not match. ---
**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:** [July 12, 2023, 2:46pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/4 "2023-07-12T14:46:30Z")
@RM88 could you please give an example? I’m not sure I can follow. ---
**Author:** ![RM88](https://avatars.discourse-cdn.com/v4/letter/r/47e85d/32.png) [@RM88](https://community.hubspot.com/u/RM88)\ **Post date:** [July 12, 2023, 2:50pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/5 "2023-07-12T14:50:11Z")
@karstenkoehler I imported a record with the email address [a.glad@bt.com](mailto:a.glad@bt.com) It added this email address to a contact record which has the email address [pglad@hotmail.com](mailto:pglad@hotmail.com) You can see these are 2 different email addresses so it should not have added the a.glad email address to this record. I would expect it to create a new record. ---
**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:** [July 12, 2023, 2:51pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/6 "2023-07-12T14:51:58Z")
Hi @RM88, HubSpot usually only does this when you’re importing and mapping the record ID. Did that import include the record ID? Are you sure the email was overwritten by the import? Could you share a screenshot of the property history for _Email_? [View a record's property history](https://knowledge.hubspot.com/crm-setup/view-property-history) Best regards ---
**Author:** ![RM88](https://avatars.discourse-cdn.com/v4/letter/r/47e85d/32.png) [@RM88](https://community.hubspot.com/u/RM88)\ **Post date:** [July 12, 2023, 2:57pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/7 "2023-07-12T14:57:08Z")
@karstenkoehler see screen below i have blurred the personal info. I dont think i did include the record ID to match on. How can i find this within Imports? ![RM88_0-1689173732680.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/c/c5376eee94e0d35a7aeedd294ce3557878134399.png) ---
**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:** [July 12, 2023, 3:00pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/8 "2023-07-12T15:00:14Z")
Hi @RM88, The only way that I’m aware of that would update a contact’s email address via import is by including the record ID. If that’s the case, the import file explicitly “told” HubSpot to update the record with the specific ID with a new email address. If the import was done in the last 6 months, you can go into the imports section, find the import, hover your mouse over it, click more and download the original file: ![karstenkoehler_0-1689173988642.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/b/3b76de92ff1bf9ea7f09479e737a8bdf9b8c9918.png) Best regards ---
**Author:** ![RM88](https://avatars.discourse-cdn.com/v4/letter/r/47e85d/32.png) [@RM88](https://community.hubspot.com/u/RM88)\ **Post date:** [July 12, 2023, 3:07pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/9 "2023-07-12T15:07:44Z")
@karstenkoehler I have downloaded the original file and there is no record ID fields for it to match on. The only other fields are first name and last name but these do not match the original contact ---
**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:** [July 12, 2023, 3:08pm UTC](https://community.hubspot.com/t/issues-when-importing-contact-data/85171/10 "2023-07-12T15:08:55Z")
Hi @RM88, This is difficult to troubleshoot without access to your portal. Can you reach out to HubSpot support to investigate this? Best regards