# Error when using Record ID for import

**URL:** <https://community.hubspot.com/t/error-when-using-record-id-for-import/72070>\
**Category:** CRM\
**Tags:** crm\
**Created:** [January 2, 2023, 2:46pm UTC](https://community.hubspot.com/t/error-when-using-record-id-for-import/72070 "2023-01-02T14:46:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![BHSMgr](https://avatars.discourse-cdn.com/v4/letter/b/b9bd4f/32.png) [@BHSMgr](https://community.hubspot.com/u/BHSMgr)\
**Post date:** [January 2, 2023, 2:46pm UTC](https://community.hubspot.com/t/error-when-using-record-id-for-import/72070/1 "2023-01-02T14:46:52Z")

</div>

Greetings in the New Year.

I have an existing CRM with ~3500 records. I exported the Contact information, including HubSpot’s Record ID, to an Excel spreadsheet. The Record ID is exported as text, not a number, and has 5 digits. I used that spreadsheet to construct an import for new Deals, one for each contact.

On import, I consistently get an error when I try to map the Record ID column to the Record ID. I have tried importing the file as an .xslx, a .csv, and formatted the Record ID as a 10 digit number, a 5 digit number, and as text. All attempts fail.

Note that I am importing with the newer step of mapping Record ID in the “Map” screen:

 ![BHSMgr_0-1672670764982.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/4/f/4fabfad835291d1012931c22713d9c3bafbbdc1e.png)

Thanks in advance for any help on this issue!

---

<div class="post-metadata">

**Author:** ![franksteiner79](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franksteiner79/32/34443_2.png) [@franksteiner79](https://community.hubspot.com/u/franksteiner79)\
**Post date:** [January 2, 2023, 3:07pm UTC](https://community.hubspot.com/t/error-when-using-record-id-for-import/72070/2 "2023-01-02T15:07:07Z")

</div>

Hi @BHSMgr

When you say you have an existing CRM, is that also HubSpot or a different tool?

What object are you importing? Deals or contacts?

You won’t be able to import deals using a record ID for contacts, that’s probably what causes the error.

You should try and import multiple objects (deals and contacts), the import file should contain the deal information and all you need to match your existing contacts is either the contact email or record id.

Hope that helps.

Frank

---

<div class="post-metadata">

**Author:** ![ContentNinja](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/contentninja/32/39174_2.png) [@ContentNinja](https://community.hubspot.com/u/ContentNinja)\
**Post date:** [January 2, 2023, 5:34pm UTC](https://community.hubspot.com/t/error-when-using-record-id-for-import/72070/3 "2023-01-02T17:34:16Z")

</div>

Hi @BHSMgr looking at the image you uploaded, it looks like you are probably improrting contacts into the Deal object which is causing the error. Try uploading into the Contacts object and that should work. Hope it helps

---

<div class="post-metadata">

**Author:** ![BHSMgr](https://avatars.discourse-cdn.com/v4/letter/b/b9bd4f/32.png) [@BHSMgr](https://community.hubspot.com/u/BHSMgr)\
**Post date:** [January 3, 2023, 1:29am UTC](https://community.hubspot.com/t/error-when-using-record-id-for-import/72070/4 "2023-01-03T01:29:05Z")

</div>

Perfect. Recall, you kiddos at home, that Contacts and Deals never mix!