Dynamics 365 Quick Tips · Functional Info · Low Code No Code

{Dynamics 365 Quick Tips} Export 1 million record using Excel static sheet

By default we can only export 10000 records at a time from Dynamics CRM 356 export to excel feature.

In today’s blog I am going to tell you trick to increase this limitation and then you shoud be able to export 1 million records.

Step 1:

Go to Github repository to download managed solution. Once downloaded, Navigate to settings and solutions then install the downloaded managed solution to your crm instance.

Step 2:

Once imported open the solution and navigate to Configuration tab and you will see list of settings which can be modified for the organization.


Step 3:

Look for MaxRecordsForExportToExcel settings and click on Add-> Accept changes->Click Ok-> Click Edit->Update value with 1000000 and publish. Currently In my instance I have set this value to 100000 but maximum value you can set for this setting is 1 Million.


Step 4:

Once published refresh your CRM instance and click export to excel. You should be able to Export 1 Million records from CRM.

Hope this helps!



2 thoughts on “{Dynamics 365 Quick Tips} Export 1 million record using Excel static sheet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s