How to Migrate SharePoint List to Another Site

Migrating a SharePoint list to another site can be a useful way to consolidate or reorganize your SharePoint data. Here is a guide on how to migrate a SharePoint list to another site:

Step 1: Export the List The first step in migrating a SharePoint list to another site is to export the list to a template file. To do this, go to the list settings and select “Save list as template” under the “Permissions and Management” section. Give the template file a name and description and select whether to include the list content.

Step 2: Download the Template File Once the template file is created, download it to your local machine. The template file will be in .stp format.

Step 3: Upload the Template File Go to the site where you want to migrate the list and select “Site Settings” from the gear icon in the top right corner. Under the “Web Designer Galleries” section, select “List templates.” Upload the template file by selecting “Files” and then “Upload Document.”

Step 4: Create a New List After the template file is uploaded, go to the site where you want to create the new list and select “Add an app” from the gear icon in the top right corner. Select “Custom List” from the list of available apps.

Step 5: Select the Template File On the “Add a Custom List” page, give the list a name and description, and select the option to “Import from an Excel spreadsheet or a SharePoint template.” Choose the template file you uploaded in Step 3 and select “Create.”

Step 6: Verify the Migration Once the list is created, verify that the list data and settings have been migrated successfully. Check that the column names, data types, and views are the same as in the original list.

Step 7: Update Links and References If the migrated list is referenced in other parts of the SharePoint site, such as in workflows or custom code, make sure to update those links and references to point to the new list.

In conclusion, migrating a SharePoint list to another site can be a useful way to reorganize your SharePoint data. By following these steps, you can ensure a smooth and successful migration of your SharePoint list with minimal disruptions to your business operations.