# Import error "validation failed"

**URL:** <https://community.hubspot.com/t/import-error-validation-failed/147447>\
**Category:** CRM\
**Tags:** crm, professional, object\
**Created:** [March 19, 2026, 12:51pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447 "2026-03-19T12:51:09Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![OVeenstra](https://avatars.discourse-cdn.com/v4/letter/o/858c86/32.png) [@OVeenstra](https://community.hubspot.com/u/OVeenstra)\
**Post date:** [March 19, 2026, 12:51pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/1 "2026-03-19T12:51:09Z")

</div>

Hi, I am trying to import a file with deals to import from one HubSpot account to another. I created a new pipeline, stages and properties to the new account so the imported deals have a place.  
But whenever I try to import, about half of the deals (from specific stages) get imported correctly, but the other half don’t and I get the “Validation failed” error.

When I look at the knowledge base article about it, it tells me to check stage, status, and pipeline name. I did (and carefully checked spelling mistake or typos) but I keep getting the error message.

Does anyone have experience with this and have any solutions or tips?

---

<div class="post-metadata">

**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:** [March 19, 2026, 12:52pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/2 "2026-03-19T12:52:51Z")

</div>

Hi @OVeenstra,

Could you please share a screenshot of the exact, full error message?

During the mapping step, HubSpot should already flag these values that can’t be mapped. Have you checked during the mapping steps if some mappings have a yellow exclamation mark on them?

Best regards

---

<div class="post-metadata">

**Author:** ![OVeenstra](https://avatars.discourse-cdn.com/v4/letter/o/858c86/32.png) [@OVeenstra](https://community.hubspot.com/u/OVeenstra)\
**Post date:** [March 19, 2026, 12:57pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/3 "2026-03-19T12:57:38Z")

</div>

Hi, thanks for the quick reply!

Yes, I checked for the yellow marks. I remapped to the correct place whenever there was one.

Here is a screenshot of the error message when I tried to import all the remaining deals that were not imported in the first try.

 ![Scherm­afbeelding 2026-03-19 om 13.55.25.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/c/ccfa75eac4f816a7d388443832ab48f1b6f1fb57.png)

---

<div class="post-metadata">

**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:** [March 19, 2026, 12:58pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/4 "2026-03-19T12:58:29Z")

</div>

@OVeenstra have you reviewed “View rows with errors”? Which details do you see here?

---

<div class="post-metadata">

**Author:** ![OVeenstra](https://avatars.discourse-cdn.com/v4/letter/o/858c86/32.png) [@OVeenstra](https://community.hubspot.com/u/OVeenstra)\
**Post date:** [March 19, 2026, 1:03pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/5 "2026-03-19T13:03:01Z")

</div>

I see this

 ![Scherm­afbeelding 2026-03-19 om 14.01.47.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/3/e3c3212add3e86e8c4abe8f56935b24e51411700.png)

---

<div class="post-metadata">

**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:** [March 19, 2026, 1:08pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/6 "2026-03-19T13:08:56Z")

</div>

@OVeenstra I only see an unmapped record ID column and empty columns - is this intentional? Is there more information to the right about the error?

---

<div class="post-metadata">

**Author:** ![OVeenstra](https://avatars.discourse-cdn.com/v4/letter/o/858c86/32.png) [@OVeenstra](https://community.hubspot.com/u/OVeenstra)\
**Post date:** [March 19, 2026, 1:33pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/7 "2026-03-19T13:33:39Z")

</div>

Not all properties are filled in for every deal, that is intentional. There are a lot more columns to the right that are filled in.

When I hover over the “i” sign. I get this message but I don’t know which property they are reffering to.

 ![Scherm­afbeelding 2026-03-19 om 14.07.00.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/9/098a1d42b4d8e8faae0cfdb42a5c34ed179095ee.png)

---

<div class="post-metadata">

**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:** [March 19, 2026, 1:34pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/8 "2026-03-19T13:34:53Z")

</div>

@OVeenstra can you share which fields you’re mapping in the mapping step? Is there any column that contains a 2?

---

<div class="post-metadata">

**Author:** ![OVeenstra](https://avatars.discourse-cdn.com/v4/letter/o/858c86/32.png) [@OVeenstra](https://community.hubspot.com/u/OVeenstra)\
**Post date:** [March 19, 2026, 1:54pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/9 "2026-03-19T13:54:01Z")

</div>

It doesn’t seem like there is a 2. There is 0.2 but that is between 0 and 1 so that shoudln’t be an issue.

 ![Scherm­afbeelding 2026-03-19 om 14.49.01.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/8/e8c2db7e8aa998cd51bcf6c49cbfa59f3a76e7dc.png)

 ![Scherm­afbeelding 2026-03-19 om 14.48.54.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/e/3eeaf6fe1676df3dc9f0e7512820e75452a5809c.png)

 ![Scherm­afbeelding 2026-03-19 om 14.48.47.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/3/c3bf22f1c1f5b06797fe8f67fea1851be5748a08.png)

---

<div class="post-metadata">

**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:** [March 19, 2026, 1:56pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/10 "2026-03-19T13:56:43Z")

</div>

@OVeenstra well, the deal probability field definitely causes the issue. Can you confirm that the original file does not contain any "2"s?

Alternatively, deal pipeline stages have an assigned probability in the deal stage settings anyway. If you can omit the column, it’ll likely save you the troubleshooting overall.

---

<div class="post-metadata">

**Author:** ![OVeenstra](https://avatars.discourse-cdn.com/v4/letter/o/858c86/32.png) [@OVeenstra](https://community.hubspot.com/u/OVeenstra)\
**Post date:** [March 19, 2026, 2:19pm UTC](https://community.hubspot.com/t/import-error-validation-failed/147447/11 "2026-03-19T14:19:20Z")

</div>

Omitting the column worked, thanks.

Still don’t understand since there were definitely no "2"s but maybe I don’t have to 😉

Thank you very much!
