How To Move A SharePoint List To Another Site

Are you looking to move a SharePoint list to another site? Follow these step-by-step instructions to streamline your workflow and transfer your list seamlessly.

To move a SharePoint list to another site, you can follow these steps:

  1. Export the list: Go to List Settings, click on “Save list as template” under Permissions and Management.
  2. Export the list to another site collection: On the top-level site of the site collection, click on “Site Settings”, then go to “List templates” in the Galleries section. Select the list template you want to export and click on “Download a Copy” in the ribbon.
  3. Upload the list to a new site collection: Go to the site collection where you want to copy the list. Click on “Site Settings” and then “List templates” in the Galleries section. Navigate to the Documents tab, click on “Upload Document”, choose the .stp file you downloaded, and click “Ok”.

Note: There may also be other methods or workarounds to move lists, such as using Excel to export and import data or using Power Automate to automate the process. However, these methods may have limitations and may not preserve all the settings and customizations of the original list.

Exporting the SharePoint List

To begin the process of moving your SharePoint list, you must first export it from the current site. Follow these steps to successfully export your list:

  1. Go to List Settings: Navigate to the list you want to move and click on the “List” or “Library” tab in the ribbon. Then click on “List Settings” or “Library Settings” in the Settings group.
  2. Click on “Save list as template”: Under the Permissions and Management section, you will find the “Save list as template” option. Click on it to proceed to the next step.

Once you have clicked on “Save list as template,” SharePoint will start the process of generating a template file for your list. This template file contains all the necessary information and settings of your list, allowing you to import it to another site. Once the process is complete, SharePoint will provide you with a download link. Click on the link to download the template file (.stp).

It is important to note that the export process does not preserve any customizations made to the list form or views. Only the list data, columns, and settings will be included in the exported template.

Example Export Process:

“I have successfully exported my SharePoint list by following the steps mentioned above. The template file was generated quickly, and I was able to download it without any issues. I appreciate how straightforward the process was!”

Exported SharePoint List Template

Column Name Type Required
Title Single line of text Yes
Due Date Date and Time No
Status Choice Yes
Assigned To User or Group No

The above table shows an example of the column structure of an exported SharePoint list template. This information can be useful when importing the list to a new site collection, allowing you to confirm the column types and requirements before proceeding.

Importing the List to a New Site Collection

Once you have successfully exported your SharePoint list, you can proceed to import it into a new site collection. Follow the steps below to complete the import process:

  1. Go to the site collection where you want to copy the list. Click on “Site Settings” in the top-level site.
  2. In the Site Settings page, navigate to the “List templates” section under the Galleries category.
  3. Click on the “Upload Document” button in the Documents tab.
  4. Choose the .stp file you downloaded while exporting the list and click “Ok”. This will initiate the upload process.

Wait for the upload to finish, and once completed, you will see the imported list template listed in the “List templates” section. You can now create a new list using this template in the desired site collection. The imported list will retain all its settings and customizations from the original list, making it ready for immediate use.

Please note that it’s important to choose the correct site collection for the import process, as the list will be created within the selected site collection. Take into account any permissions and access restrictions of the destination site collection to ensure smooth integration.

Example: Importing a SharePoint List using the Upload Document feature

“The Upload Document feature in SharePoint makes it incredibly easy to import lists to new site collections. With just a few clicks, you can transfer your valuable data and settings seamlessly. This ensures that you can maintain consistency and continuity across different sites within your SharePoint environment.”

– SharePoint Expert
Step Description
1 Access the destination site collection’s Site Settings.
2 Navigate to the List templates section under the Galleries category.
3 Click on the “Upload Document” button in the Documents tab.
4 Select the .stp file you downloaded and click “Ok” to initiate the import.

By following this process, you can effortlessly import your SharePoint list to a new site collection, allowing you to benefit from the list’s data and settings within a different context. Enjoy the flexibility and convenience that SharePoint offers in managing your information across various sites!

Alternative Methods for Moving SharePoint Lists

While the previous steps cover the standard process of moving a SharePoint list, there are alternative methods available, such as using Excel or Power Automate. However, these methods may not offer the same level of customization and preservation as the previous steps.

To move a SharePoint list using Excel, you can export the list to an Excel file and then import the data into a new list. This method can be useful for simple lists without complex settings or customization. However, it may not preserve all the metadata and formatting of the original list.

Power Automate, formerly known as Microsoft Flow, provides automation capabilities for various tasks, including moving SharePoint lists. With Power Automate, you can create workflows to automate the export and import process. However, this method requires some technical knowledge and may not be suitable for users without experience in workflow creation.

It’s important to note that while these alternative methods can be helpful in certain scenarios, they may not be as comprehensive or reliable as the standard steps outlined earlier. If you require a seamless transfer of a SharePoint list with all its settings and customizations intact, it’s recommended to follow the export and import process described in the previous sections.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.