# Importing Updated Contacts Without Contact ID

**URL:** <https://integration.keap.com/t/importing-updated-contacts-without-contact-id/43712>\
**Category:** Max Classic\
**Created:** [June 15, 2018, 5:57pm UTC](https://integration.keap.com/t/importing-updated-contacts-without-contact-id/43712 "2018-06-15T17:57:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kelly\_Ehrlich](https://avatars.discourse-cdn.com/v4/letter/k/ea666f/32.png) [@Kelly\_Ehrlich](https://integration.keap.com/u/Kelly_Ehrlich)\
**Post date:** [June 15, 2018, 5:57pm UTC](https://integration.keap.com/t/importing-updated-contacts-without-contact-id/43712/1 "2018-06-15T17:57:28Z")

</div>

I exported a list of clients, updated their information in Excel, in the process the Contact ID column was removed somehow and now I need to import these contacts back into InfusionSoft to update their information. How can I do this without the Contact ID in my new .csv file? WIll that duplicate records?

---

<div class="post-metadata">

**Author:** ![John\_Borelli](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/john_borelli/32/11880_2.png) [@John\_Borelli](https://integration.keap.com/u/John_Borelli)\
**Post date:** [June 15, 2018, 6:02pm UTC](https://integration.keap.com/t/importing-updated-contacts-without-contact-id/43712/2 "2018-06-15T18:02:01Z")

</div>

Two ways,

1. you can do the import and then merge the contacts by email address (assuming you ensure emails to be unique among contacts)

or

1. Use a vlookup method in Excel to corrolate the contact id before doing the import, which will then just update the contacts by id number. @Greg_Jenkins has a video on this:

[![](https://us1.discourse-cdn.com/flex019/uploads/infusionsoft1/original/2X/4/461d852879d8e7c3444888fa8d7788bacf8d7518.jpeg "How to Import Contacts in Infusionsoft without creating dupicates - Vlookup Training") ](https://www.youtube.com/watch?v=kBN0g1mdbNA)