How To Migrate/Copy List From One Site Collection To Another

Follow the steps mentioned below to migrate/copy a list from one site collection to another. 

Export the list

  • Login to SharePoint and go to List Settings. 
  • Under the Permissions and Management section click on Save list as template. 

Export list to another site collection 

  • On the top-level site of the site collection containing the list that you want to copy, click - > Site Settings. 
  • In the Galleries section, click - > List templates. 
  • On the List Template Gallery page, select the check box next to the list template that you want to export. 
  • In the ribbon Click - >Download a Copy. 

Uploading the list to a new site collection. 

  • You should now have a .stp file. Now go to the site collection you want to copy the list too. 
  • Click Site Settings. 
  • In the Galleries section, click on List templates. 
  • Click on the Documents tab. 
  • Click on Upload Document.
  • Click on Choose File and navigate and choose the .stp file you downloaded. 
  • Click on Ok. 

Problem: "Save List as Template" is missing in SharePoint Online modern sites.

Root Cause

"Custom script" feature is disabled! 

Solution

Enable Custom Scripting at SharePoint Admin Center and Site Collection Levels. 

How to Enable Custom Script in SharePoint Online? 

To allow custom script in SharePoint Online, follow these steps: 

  • Sign in to Office 365 and go to the SharePoint Online Admin Center. 
  • Click on Settings from the left navigation >> Scroll down to "Custom Script" section 
  • Under Custom Script section, set "Allow users to run custom script on personal site" and "Allow users to run custom script on self-service created sites" options.? 

How To Migrate / Copy List From One Site Collection To Another?

  • Click on "OK" to save your changes. 

This enables custom script in SharePoint Online. However, this change may take up to 24 Hours to reflect.

How To Migrate / Copy List From One Site Collection To Another?