Export to Excel is a great feature in Dynamics CRM, but it has always come with two limitations
Even though CRM says that it is exporting to Excel, what it is exporting to, is not xlsx format. This limitation has been addressed in CRM2015 Update 1. The number of records, you can export, has also been increased to 100,000.
But if you still want to export the whole dataset, the easiest way I found, is to export it from the filterview in the MSCRM database. This is obviously not possible, if you are using CRM Online. Hence, I developed this tool, to do just that.
How to Use it
Download the tool from https://github.com/rajyraman/mscrmexporttoexcel/releases/download/v188.8.131.52/Ryr.ExcelExport.v184.108.40.206.zip
Export to Excel Too
The tool displays the progress of the file export, while retrieving records from CRM. The total number of records retrieved is also displayed, upon successfully writing the data to the output file.
This tool uses code from Tanguy’s View Layout Replicator, for most of the UI and event handling logic.