How to export large SharePoint list data to Excel like 60,000+

Recently i was trying to export the sharepoint list data to excel and if i say it was more than 60,000 data that resides in SharePoint List and when the client told me to export all these data to Excel that was seem little bit difficult to do so.

I have tried using export to excel and datasheet view but they are retrieving up to 53,000 items. So I tried to thinking that is there any way to retrieve all the list items without using PowerShell script and disabling list threshold. Because i hate to code :-D

Resolution

So, I found something good to perform this type of activity

If you could get access to Central Admin, you could increase the List View Threshold (LVT):

Login to Central Admin

Go to Application Management -> Manage Web Applications

Pick the Web application for which you want to change the LVT (If you only have 1 web app plus the central admin one, the one you want to pick is the 1 web app; changing this for the central admin does you no good)

In the ribbon above, click General Settings. That will bring down a menu, from which you should pick Resource Throttling

Change the LVT (first item in this list) to another value and press OK, but please try to keep it to a reasonable number!

NOTE: Don't forget to change it back to a reasonable number after you done your export.

Another option is to export items in batches, using views or script.

If you can't use Central Admin or script, views is the only option I guess. Create view with filter ID is less or equal 30.000 and another with filter ID is greater than 30.000 for example. Export them separately then merge them in Excel.

Thanks!!!!