# Import Close Date for Deal

**URL:** <https://community.hubspot.com/t/import-close-date-for-deal/47789>\
**Category:** CRM\
**Tags:** free, professional, starter\
**Created:** [December 1, 2021, 12:28pm UTC](https://community.hubspot.com/t/import-close-date-for-deal/47789 "2021-12-01T12:28:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![TAppleton](https://avatars.discourse-cdn.com/v4/letter/t/b4bc9f/32.png) [@TAppleton](https://community.hubspot.com/u/TAppleton)\
**Post date:** [December 1, 2021, 12:28pm UTC](https://community.hubspot.com/t/import-close-date-for-deal/47789/1 "2021-12-01T12:28:33Z")

</div>

Hi , Any help appreciated.

My issue is that close date won’t import for Deals using Excel import.

I have tried dates with and without times

and tried these against all three imput formats (DD/MM/YY , MM/DD/YY and YYYY/MM/DD within the import routine.

My account is UK set to UTC.

I have imported deals via the api no problem using the full T Z format with milliseconds.

This is fine for ongoing transactions.

Howver I need to use file import to being over the history.

I’m out of ideas.

---

<div class="post-metadata">

**Author:** ![Lucila-Andimol](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lucila-andimol/32/69276_2.png) [@Lucila-Andimol](https://community.hubspot.com/u/Lucila-Andimol)\
**Post date:** [December 1, 2021, 3:55pm UTC](https://community.hubspot.com/t/import-close-date-for-deal/47789/2 "2021-12-01T15:55:13Z")

</div>

Hi @TAppleton hope you are doing well.

I think you are missing the time part

the complete format for date is , for example, 2020-09-04 18:29

That may be the problem.

Try it out and let us know.

---

<div class="post-metadata">

**Author:** ![TAppleton](https://avatars.discourse-cdn.com/v4/letter/t/b4bc9f/32.png) [@TAppleton](https://community.hubspot.com/u/TAppleton)\
**Post date:** [December 1, 2021, 5:33pm UTC](https://community.hubspot.com/t/import-close-date-for-deal/47789/3 "2021-12-01T17:33:20Z")

</div>

Hi Lucila,

Thanks for the response.

[PREVIEW](https://community.hubspot.com/t5/CRM/Import-Close-Date-for-Deal/m-p/534712/thread-id/130273#)

The issue was that the import was mapping Close date to Customer rather than the Deal.

Once I manually remapped to Deal Closed Date it worked fine.

Evey day is a school day !

---

<div class="post-metadata">

**Author:** ![CCaffrey](https://avatars.discourse-cdn.com/v4/letter/c/e19adc/32.png) [@CCaffrey](https://community.hubspot.com/u/CCaffrey)\
**Post date:** [April 9, 2022, 6:08pm UTC](https://community.hubspot.com/t/import-close-date-for-deal/47789/4 "2022-04-09T18:08:31Z")

</div>

@TAppleton I am having the same issue. Can you explain how you resolved this? I am trying to import Deal’s and am having issues with the Close Date importing. Any time I try to import Deals with multiple associations such as Contact or Company then the Close Date can no longer be associated with the Deal. It only allows it to be associated with a Contact or Company, rendering it to not actually import into the Deal.

It works just fine if I import a Deal without a Contact or Company associatation. However, I need to associate the Deal with a Contact so I cannot forgo importing with this association.

Please help!