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 ?

1 Answer 1


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.

  • 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 J
    Aug 1, 2014 at 15:20
  • check this one referpages.com/wp/2012/04/101
    – Waqas Sarwar MVP
    Aug 1, 2014 at 16:12
  • Thanks but i created a powershell script to move the list items to another list .
    – Nikhil J
    Aug 1, 2014 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 MVP
    Aug 1, 2014 at 18:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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