On SharePoint Online, I've got this list which just recently went over 5000 items. We have indexed columns and filtered list views in place in preparation for this, but it's still not enough and is breaking custom script components on our site.

We figured that for the time being, we would place older items on an archive list with a similar structure to the original list.

Is this a sound plan? How would we go about doing this?

I've tried saving the list as a list template but it won't let me since I have the threshold limit exceeded. Is there any way around this besides manually creating this custom list? How would the items be moved as well without them losing their IDs?

2 Answers 2


Your best option here is to open the list with MS Access (List ribbon -> Open with Access). From access you can either save the data locally or export it to another list (Right click the list -> Export -> SharePoint List), and also delete the old items (after you save or export them) from the list.

When you export the list from access, the new list will contain the column _OldID which will contain the IDs from the original list.

  • I don't have 'access to Access' unfortunately. heh
    – Katie
    Commented Feb 3, 2017 at 21:16
  • If you're using browser other than IE this option is grayed out. Try opening the site in IE. Commented Feb 3, 2017 at 21:17
  • 1
    Other option is: open MS access, create simple blank database, go to External Data -> More -> SharePoint List, enter the url of your site and check the list (that should open the list in access). Commented Feb 3, 2017 at 21:19
  • Yep, tried on IE both 11 and Edge, still disabled. I was able to open it through your other option though. Thanks!
    – Katie
    Commented Feb 3, 2017 at 21:19
  • Access doesn't preserve the lookup columns unfortunately ):
    – Katie
    Commented Feb 3, 2017 at 21:27

Found a workaround with regards to saving the list as a template:

I was able to save the original list as a list template by deleting a few list items first from the list. Once I had the list template saved, I simply restored the deleted list items.

With regards to moving items over. I might have to rely on a third party tool such as Sharegate if I want to keep the IDs intact I guess

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.