How do I export opportunities from Dynamics 365?

Shawn Winters 0 Reputation points
2026-11-17T18:38:25.89+00:00

I'm trying to export my opportunities from Dynamics 365 but I am not able to figure out how to do.

Microsoft 365 and Office | Office Online Server
0 comments No comments

2 answers

Sort by: Most helpful
  1. Jay1 Tran 2,085 Reputation points Independent Advisor
    2026-11-17T18:47:20.8133333+00:00

    Hi Shawn Winters,

    Thank you for reaching out.

    Based on your description, you would like to export opportunities from Dynamics 365. If my understanding is correct, this question appears to be related to CRM functionality. Since this community mainly focuses on Microsoft 365 and Office applications, the CRM topic may be outside the primary scope of support available here.

    To help ensure you receive the most accurate guidance, I recommend posting your question in the following Dynamics community forum where CRM specialists and experienced users regularly share their expertise. This community is dedicated to Dynamics and CRM-related topics, so you are more likely to receive detailed assistance from members who work closely with these solutions.

    Thank you for your understanding, and I apologize for any inconvenience caused by directing you to another community. I hope the suggested forum will help you obtain the information you need.

    Wishing you a great day ahead.

    Was this answer helpful?

    0 comments No comments

  2. AI answer

    2026-11-17T18:38:59.3933333+00:00

    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

    1. In the Dynamics 365 Sales app, select Opportunities from the left navigation.
    2. Open the appropriate view, such as My Open Opportunities or All Opportunities.
    3. Apply filters or adjust the displayed columns so the view contains the data you want.
    4. On the command bar, select Export to Excel.
    5. 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.
    6. 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:

    1. Open the security role assigned to your account.
    2. Select the Privacy-related privileges tab.
    3. Locate Export to Excel (prvExportToExcel).
    4. 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

    1. Export data to Excel
    2. Export data to Excel
    3. Privacy-related privileges
    4. Create or edit a security role to manage access
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.