Export Deals

Dale_8483

Does anyone know how to export Deals with contact info and notes in an excel or csv file?

ddutra

Thats not what I am seeing on my side for both exports (deals and notes).

For the notes export it is a bit messy yes because my notes have a bunch of formatting and sometimes HTML pasted by my users, but the columns are correctly formatted on the CSV file and I have the deal name and main person name.

I just noticed that there is no deal id and person id on the notes export. That would prevent you from associating notes to deals and persons with 100% certainty - imagine if you have two deals with the same name.

ddutra

@Dale_8483

Just go to this url in your pipedrive:

/settings/export

And select "Notes". You get the deal and person ID`s there associated with the notes.

Then you export the persons and deals separately and use Excel or Google Sheets to mix and match your data (vlookup is your friend).

Thats how I would tackle this.

I am available for hire if you need this done.

Dale_8483

Thanks for responding, I'm having trouble exporting deals individually, it lumps them all together in a big mess with no contact info included.

Dale_8483

Okay, I'll keep working on it. Thanks again for taking the time to give me some help.

Anna_Gogol

Hey @Dale_8483

I would like also to add one more way to export Deals and other essential Pipedrive data to Excel, Google Sheets and BigQuery with the help of Coupler.io.

Coupler.io is a is a data extraction tool that can easily pull the data from Pipedrive automatically and on a desired schedule (every week, day, hour, 30 and 15 minutes).

Coupler.io can fetch such Pipedrive data:

• Deals
• Persons
• Organizations
• Activities
• Files
• Leads
• Call logs
• Products

To learn more about Pipedrive to Excel integration please use this link.