Knowledge Base

There are two ways to export data from Pipedrive: from the list view to combine data from different items (deals, organizations and people) and build reports of what you need, or from Settings to export all data for each item individually.

Exporting from the detail view

Go to a deal’s detail view and click on the “...” (more) icon > Export as XLS in the top right corner. The spreadsheet will include deal details and any linked person or organization data.

Exporting from the list view

You can export custom reports on your deals, organizations, or other items in Pipedrive from the list view. First, go to the list view of an item and filter for the specific data you want to export.

For example, to export lost deals, select the filter “All lost deals” to only pull up deals that fit the criteria.

Once you have the filter, select the data fields you want to export by editing your list view columns. You can choose from deal, person and organization fields, mixing and matching data from all three to get your perfect combination.

Then click the three dots in the top right of the screen and select “Export filter results.”

Exporting from “Export data”

You can also export your data by going to “...” (More)> Export data. This will allow you to export data related to leads, deals, organizations, people, activities, products or notes individually.

Select the type of data you want to export and click on either “CSV” or “Excel.” Your export file will appear in the “Exports available for download” list with a green Download button.

Exporting from Insights

There are two ways you can export data from your Insights tool.

Exporting charts

To export a report, goal, or dashboard, click the “Export” dropdown in the top right corner, and select one of the available file types:

This will give you a file containing the charts, title and any filters applied.

Exporting to spreadsheets

You can export the table view of your report as a spreadsheet by clicking the “Export” button above the table.