Exporting data from Pipedrive is very simple!
First, go to your settings, then click the 'export' tab on the left hand side.
You'll then get the following page:
Pick what you'd like to export from the menu at the top - currently you can export Deals, Organizations, People, Products, Activities, and Notes. If you'd like to export multiple different categories, it's best to either export them separately from here, or in bulk from the List View.
Once you've picked what you'd like to export, click either CSV or Excel depending on what you would like to export.
Your export file will then appear in the 'exports available for download' list, with a green 'Download' button on the far right:
Download your file, then you're done!