excel export of large list date beyond 50000 limit
Export to Excel needs to allow option to export more than just the first 50000 items in a large list. There should be an option to export more items since excel can handle large loads. Suggestion would be 500,000. If Excel and SharePoint Online have some sort of built in limitation, then Microsoft needs to create another export option and clearly document that option witin the system help. It is useless to be able to store millions of items in a list but only be able to export the first 50000 items when viewing the allitems.aspx view of the list. Creating multiple views to export the data in segments is cumbersome since only 5000 items are allowed in a view. This is not a realistic option for exporting a list of 100,000 items. It requires multiple excel exports, then users must stich together the multiple excel files. It is also not reasonable to expect admins to create 20 folders and move items to the folders to then try the export. Data should be exportable from the basic list, otherwise why are you allowing the lists to contain more than 5000 items?