SharePoint Online 5000 Items List Limitation


I have an Office 365 (E3 Plan), it has a SharePoint with it. 

I am manging an excel sheet with around 30,000 record (the records are getting bigger and bigger day by day). 

Is there any way to upload this data to a specific SharePoint list, or I should divide the excel file into sub lists (5000 records per list).

Please note that i'm using Spservices to read this list items and display them in a webpart.

Thank you

Musa'ab Ghannaj 

May 24th, 2015 9:59am

A SharePoint list can store millions of items. 5000 is default list view threshold. It means that if there is a query which attempts to retrieve items which are more than this number, then the query will be throttled. This issue can be averted by creating views using indexed columns.   
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2015 2:23am


I believe the upper limits for items in list in SharePoint Online are the same as for SharePoint 2013 described here (30,000,000 items).

To upload the data to SharePoint list, we can use Client Object Model to achieve it.

Using the C# CSOM to interact with SharePoint Online

As this question is more relate to Office 365, I suggest you post it to Office 365 Forum, you will get more help and confirmed answers from there.

Best Regards,


May 25th, 2015 3:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics