How to Migrate SharePoint List to Another Site – A Complete Walkthrough

Migrating SharePoint list to another site is a critical task and poses a huge risk of data loss. Therefore, we need a proper plan and appropriate solutions to migrate SharePoint list to another site. In this guide, we will explore four tried and tested solutions to move SharePoint list to another site simultaneously. 

Why Migrate a SharePoint List to Another Site?

There are various reasons why user want to migrate their SharePoint list to another site, i.e.,

• Organizations frequently restructure their SharePoint environment, and moving to newly created sites is essential.
• Changes in departments in an organization, migrating current data to another site, will be necessary. 
• In the case of mergers or acquisitions, moving SharePoint lists between tenants becomes necessary.

Next, we are going to learn how to move SharePoint list to another site using both manual and automated solutions. 

Also read: How to Change Site Owner in SharePoint Online

Methods to Migrate SharePoint List to Another

The following sections explain three manual and one automated solutions step by step. Go through all of them and proceed with the transition hassle-free: 

Method 1. Manual Export/Import (Excel Method)

1. Go to the Source List > Click on Export to Excel.
2. Download the .iqy file and open it in Excel.
3. Save the file as .xlsx.
4. Navigate to the Destination Site > Add a new custom list.
5. Choose Import Spreadsheet (requires classic experience).
6. Upload the Excel file to create a new list with the same data.

Method 2. Save as Template

1. Go to List Settings > Click Save list as template.
2. Check “Include Content” if needed.
3. Download the .stp file.
4. Go to the destination site, upload it to the List Template Gallery.
5. Create a new list using this template.

Method 3. Use PowerShell + PnP PowerShell Module

• # Connect to the source site
• Connect-PnPOnline -Url https://john.sharepoint.com/sites/example -Interactive
• # Export list
• Get-PnPListItem -List “ProjectTasks” | Export-Csv “C:\Backup\ProjectTasks.csv” -NoTypeInformation
• # Connect to the target site
• Connect-PnPOnline -Url https://target.sharepoint.com/sites/example -Interactive
• # Import data (assumes a list with the same structure exists)
• $items = Import-Csv “C:\Backup\ProjectTasks.csv”
• foreach ($item in $items) {
•     Add-PnPListItem -List “ProjectTasks” -Values @{
•         Title = $item.Title
•         Status = $item.Status
•         AssignedTo = $item.AssignedTo
•     }
• }

Method 4. Cutting-edge Automated Tool

Want to migrate SharePoint list to another site seamlessly? Look no further! Just opt for the Automated SharePoint Migration Solution, and gain the benefits of several salient features, i.e., date filter, delta migration, re-run migration, category-based migration, and more. 

It comes with a self-explanatory interface, so any skill level user can easily use this and migrate SharePoint data to another site in one go. Additionally, you can see its UI for free by downloading this from its official website. However, to see the full potential of this software, you have to take its entire version. 

After getting its full version, follow the step-by-step instructions for the transition:

• Step 1. Run the solution, and select Microsoft 365 as a source & destination platform. 
• Step 2. In the workload selection, select the Lists option to migrate.
• Step 3. Provide the Admin credentials for both source & target tenant. 
• Step 4. Map the source user and sites using the Fetch button.
• Step 5. Hit, Start Migrate button to proceed with the transition. 

Best Practices for SharePoint List Migration

Here are some points to consider to make the migration seamless, i.e.

• Back up data before migration.
• Ensure the target list has matching columns.
• Test with sample data before full migration.

Related article: Sync SharePoint Document Library to Local Folder

Final Words

Migrating SharePoint lists to another site can be straightforward or complex, depending on your solution you choose. In this write-up, we discussed many solutions with step-by-step instructions, so that the user can opt for any of them without any doubt. We explored an automated solution also which is best among all of them because of its reliability and cost-effectiveness.