# Export Deals

**URL:** <https://community.hubspot.com/t/export-deals/1210>\
**Category:** CRM\
**Created:** [March 3, 2017, 4:56pm UTC](https://community.hubspot.com/t/export-deals/1210 "2017-03-03T16:56:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\
**Post date:** [March 3, 2017, 4:56pm UTC](https://community.hubspot.com/t/export-deals/1210/1 "2017-03-03T16:56:55Z")

</div>

Is it possible to export Deals with company details, i.e. address, phone number and email address?

---

<div class="post-metadata">

**Author:** ![roisinkirby](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@roisinkirby](https://community.hubspot.com/u/roisinkirby)\
**Post date:** [March 3, 2017, 5:22pm UTC](https://community.hubspot.com/t/export-deals/1210/2 "2017-03-03T17:22:05Z")

</div>

Hey [@shallett](https://community.hubspot.com/t5/user/viewprofilepage/user-id/4721) check out the knowledge base, this article should help anser your question: [How can I export my Contacts, Companies, and Deals from the CRM?](https://knowledge.hubspot.com/articles/kcs_article/contacts/how-can-i-export-my-contacts-companies-and-deals)

You can export all of the contact, company, or deal records that exist in a view (for more information on creating views, [click here](https://knowledge.hubspot.com/articles/kcs_article/contacts/how-can-i-segment-contacts-in-the-crm)).

**Please note:** HubSpot CRM will export all properties that are added as columns to the view you are exporting. This does not include [Notes](https://knowledge.hubspot.com/articles/kcs_article/contacts/can-i-export-notes-from-my-contact-records) or other engagements. To learn how to customize which properties appear in your view, check out [this article](https://knowledge.hubspot.com/articles/kcs_article/contacts/how-do-i-change-the-displayed-columns-in-a-view-in-hubspot-crm).

---

<div class="post-metadata">

**Author:** ![AndreaTinner](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/andreatinner/32/62874_2.png) [@AndreaTinner](https://community.hubspot.com/u/AndreaTinner)\
**Post date:** [March 9, 2018, 8:28am UTC](https://community.hubspot.com/t/export-deals/1210/3 "2018-03-09T08:28:31Z")

</div>

How to export deals, contacts and companies is clear to me. What we were looking for is this: **We would need detailed adress information (Properties) from the related contact/company.** So properties from contact or/and company when exporting a deal overview. (I also tried to solve this with a workflow, sadly not possible to update deal properties based on related contact/company and kind of copy/paste properties.)

At the moment we export all and use Excel and VLOOKUP() and makros.

Looking forward to any inputs.

---

<div class="post-metadata">

**Author:** ![JanaB](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/janab/32/83773_2.png) [@JanaB](https://community.hubspot.com/u/JanaB)\
**Post date:** [November 26, 2018, 10:27am UTC](https://community.hubspot.com/t/export-deals/1210/4 "2018-11-26T10:27:21Z")

</div>

Hi @AndreaTinner, [@shallett](https://community.hubspot.com/t5/user/viewprofilepage/user-id/4721)

You can set up an export of the deals with associated company/contact details using Import2 Wizard - a third-party solution.

Here is a quick video overview of how it works: [https://youtu.be/RwoZ2RD3Q8c](https://youtu.be/RwoZ2RD3Q8c)

---

<div class="post-metadata">

**Author:** ![JFlores758](https://avatars.discourse-cdn.com/v4/letter/j/ba9def/32.png) [@JFlores758](https://community.hubspot.com/u/JFlores758)\
**Post date:** [November 10, 2023, 11:42am UTC](https://community.hubspot.com/t/export-deals/1210/5 "2023-11-10T11:42:04Z")

</div>

I want to export using an API. I’m using workato to export all the deals and I want to get the id of the companies or primary company the deal is associated with. Generally if I want a field in csv I need to give the property name of that field. What should be the property name to get the associated company ids? I tried associated\_company\_ids and got an error ( Please fix or remove these properties as they are not a part of the object: associated\_company\_id)

---

<div class="post-metadata">

**Author:** ![JacobM](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jacobm/32/25355_2.png) [@JacobM](https://community.hubspot.com/u/JacobM)\
**Post date:** [December 13, 2018, 2:49pm UTC](https://community.hubspot.com/t/export-deals/1210/6 "2018-12-13T14:49:50Z")

</div>

You can automatically export deals (including fields from other tables) as CSV files using [Skyvia](https://www.hubspot.com/integrations/skyvia). It is a code-free ETL web service with support for all major SaaS apps, databases and flat files.
