SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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 Jangle Aug 1 '14 at 15:20
check this one – 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 Jangle 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.