Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Exporting to Excel

(1) ShareShare
ReportReport
Posted on by

I am trying to export all of our Active Accounts to an excel spreadsheet.  I am able to export the default "Active Accounts" view just fine.  But when I created a new view "with all the fields" I receive an error saying, "Failed to Generate Excel - An error occurred when CRM tried to generate the Excel file. If this problem persists, contact your system administrator."  I tried to look at the log file, but it is grayed out. 

Any thoughts?

Is there a limit to how many columns an can be exported? 

Thank you for your help!

*This post is locked for comments

  • Suggested answer
    Natalia LLano Prades Profile Picture
    10 on at
    RE: Exporting to Excel

    Today we have the same problem in our project. We have tried the duplicated display names solution, but unfortunately, it has not worked. Neither a problem with the number of records to export. Finally, we have discovered the problem, a value in a picklist had been eliminated!! When you re-create the value in the picklist (with the same id, of course) the problem has been solved magically. I hope it helps :) 

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Exporting to Excel

    This was exactly it for me, thanks!

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Exporting to Excel

    Check that you don't have two columns with the same display name, as this usually causes issues.

  • Community Member Profile Picture
    on at
    RE: Exporting to Excel

    Use the SDK to export the records. You can download the fetch xml of your view from the Advanced Find and then  just query the records via SDK and dump to excel. If that is not your cup of tea then you can use SSIS toolkit from KingswaySoft or CrazyRock  and write file to an excel destination file.

  • Community Member Profile Picture
    on at
    RE: Exporting to Excel

    Are you Accounts entity have same name field

  • Guido Preite Profile Picture
    54,077 Moderator on at
    RE: Exporting to Excel

    uhm, try with "Export to Excel" plugin (author RajYRaman) that you can find inside the XrmToolbox

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,017 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,852 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans