Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I read that we can store list items limitation for sharepoint 2010 is 30 million . Is this true ?

If yes , then can i have 25 million records in sharepoint list , and use "export to excel sheet" and it will work fine ?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Yes this is true, as per technet.

   Items 30,000,000 per list Supported
    You can create very large lists using standard views, site hierarchies, and metadata navigation. This value may vary depending on the number of columns in the list and the usage of the list.


But milage vary as in the description mentioned that its depend how many columns of different type.

I dont have a list this much items, so only way to check is test it.

I dont think so it's good idea to have list with 25Million items, this will be big performance hit on your site.

share|improve this answer
Yes , we have a list with folder structure . And the list has grown to 1 million records now . currently I want to find a archiving mechanism . –  Nikhil Aug 1 '14 at 15:20
check this one referpages.com/wp/2012/04/101 –  Waqas Sarwar MCSE Aug 1 '14 at 16:12
Thanks but i created a powershell script to move the list items to another list . –  Nikhil Aug 1 '14 at 16:23
that's fine, if you automate via powershell it will be fine...above is automated thing once setup it work all the time...chioces are yours –  Waqas Sarwar MCSE Aug 1 '14 at 18:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.