How to migrate the SharePoint list to another site?
When admins look to simplify site organization and undergo a full-scale site restructuring, the migration of the SharePoint site to another site becomes vital. With this migration, the data is not just transferred but there is full preservation of the listโs schema, settings, and associated metadata. Whatever the reasons are for such a migration, users need to learn about the complexities of list migration.
Users must know about handling custom views, complex column types, and permissions. We will discuss the basic manual method, usage of PowerShell commands along with an automated utility. We will help you to make this complex technical process an easy one with our step-by-step guidance.
How to migrate SharePoint list to another site?
Below, we will help you with the basic steps to migrate SharePoint list to another site. But before we get started, sign-in to SharePoint and locate all the lists that you want to move. You can now follow the steps.
- Navigate to the List Template Gallery in SharePoint.
- Choose the SharePoint list template and you need to download it to your PC.
- Navigate to another site collection and go to Settings. Tap on Site Settings. Click on the List templates.
- Click on the File button and upload documents.
- Go to Settings. Tap on Apps You Can Add and give the template a name and add it.
After the above steps, users can copy the SharePoint list from one to another with ease.
Using PowerShell
To migrate the SharePoint lists via PowerShell commands needs a lot of expertise but it is a top solution for admins. You can easily transfer data across sites and maintain list configurations and metadata integrity. This procedure is free, but you need to follow a complex sequence of steps. Moreover, a solid understanding of PowerShell scripts is needed to avoid errors.
As we start, you must make sure that the source and target SharePoint sites have lists with identical columns. Moreover, admin privileges are a must. Follow the PowerShell commands as given below.
- Install PnP PowerShell module:
Install-Module -Name PnP.PowerShell
- Connect to the Source SharePoint Site:
Connect-PnPOnline -Url “https://[tenantname].sharepoint.com/sites/[source-site]” -Interactive
- Export the SharePoint List to a Template:
Get-PnPSiteTemplate -Out “C:\Temp\Lists.xml” -ListsToExtract “Your List Name” -Handlers Lists
- Reconnect to the Target SharePoint Site:
Connect-PnPOnline -Url “https://[tenantname].sharepoint.com/sites/[target-site]” -Interactive
- Import the SharePoint List from the Template:
Invoke-PnPSiteTemplate -Path “C:\Temp\Lists.xml”
The above given steps guarantee that all the list data and associated settings are migrated to the target site. But, as said earlier, follow all the commands carefully as per your SharePoint environment details.
These manual methods are effective but at the same time, these approaches are difficult to execute, need a lot of time and patience and are prone to errors. Thus, you must look for an automated resolution like Kernel Migration for SharePoint to get away from any kind of migration failures.
This utility simplifies the complex task of SharePoint list migration to another site. This tool is designed to handle the complexities of SharePoint environments effortlessly. All in all, this makes it an ideal solution for businesses that need a dependable method for data migration.
It supports not only SharePoint online migrate list to another site but also the migration between different SharePoint versions, from SharePoint Online to SharePoint On-Premises, and vice versa.
Last thoughts
This blog has outlined the best manual ways to migrate or copy SharePoint list to another site. Using the basic approach to using PowerShell commands, we have given stepwise instruction for both the methods. But as witnessed, these methods are highly prone to failures as these methods need tech-expertise, and patience.
For better outcomes and success, we have recommended the Kernel Migration for SharePoint tool that makes your SharePoint list migration tasks easier. With automated functionalities and easy-to-use features, this utility is a boon for SharePoint users. Get on with the trial today and feel the difference.