Open Opportunities in Dynamics 365 Sales, choose the view containing the records you need, and select Export to Excel from the command bar.
Export the opportunities
- In the Dynamics 365 Sales app, select Opportunities from the left navigation.
- Open the appropriate view, such as My Open Opportunities or All Opportunities.
- Apply filters or adjust the displayed columns so the view contains the data you want.
- On the command bar, select Export to Excel.
- Choose an export type:
- Static Worksheet — creates a snapshot suitable for sharing.
- Dynamic Worksheet — can be refreshed to retrieve current Dynamics 365 data.
- Dynamics PivotTable — exports the data for pivot-table analysis.
- Excel Online — opens the data for online analysis or bulk editing.
- Save the downloaded file before opening it in Excel. If prompted that external data connections are disabled, select Enable Content. ^1^
A static worksheet is a local copy and remains unchanged when Dynamics 365 records change. A dynamic worksheet maintains a connection and requires authentication whenever it is refreshed; it only returns records the signed-in user has permission to view. ^2^
If Export to Excel is missing or disabled
Export access is controlled through Dynamics 365 security roles. Ask a Dynamics 365 or Power Platform administrator to:
- Open the security role assigned to your account.
- Select the Privacy-related privileges tab.
- Locate Export to Excel (
prvExportToExcel).
- Enable that privilege, save the role, and have you reopen the Sales app.
The administrator can also restrict which opportunity records you can read, so an export contains only records accessible through your existing security roles. ^3^ ^4^
If the export times out
Export a smaller dataset by:
- Applying narrower filters to the opportunity view.
- Removing unnecessary columns.
- Removing lookup columns that retrieve data from related tables.
Export capacity and timeout behavior depend on the number of rows, columns, lookup fields, and relationship types included in the query. ^1^
References
- Export data to Excel
- Export data to Excel
- Privacy-related privileges
- Create or edit a security role to manage access