Using the Report Builder, you can create custom Reports to better analyse key data from the CRM.
Whilst the Report Builder gives you powerful reporting capabilities with just a few clicks, there may be scenarios where you need to export this data to Excel for further analysis (e.g. create pivot tables etc.).
You'll need CRM Print Lists rights within the CRM to use this - visit this link, select the user who needs the rights, and select 'CRM Print Lists'
Step 1: Open a Report
The first step is to open a saved Report. If you're creating a Report from scratch, make sure you save it using the save icon in the top right-hand corner before trying to export it. On the Report, click the further options (three dots) and choose 'Export to Excel' from the drop-down.
Step 2: Open your Excel File
This will automatically generate and download an Excel spreadsheet. Simply click on the Excel file to open it.