SaltfishTry for free

How to Duplicate a SharePoint List

·2 min read
In this article

Duplicating SharePoint lists is a valuable skill that saves time when you need to create similar data structures across different projects or sites. Whether you're setting up new workflows or backing up existing data, the duplication process helps maintain consistency.

This tutorial walks you through the complete process of duplicating any SharePoint list using the export and import method. You'll learn how to preserve your data structure while creating an independent copy that you can customize as needed.

Here's how to duplicate a sharepoint list in Sharepoint

  1. Open the SharePoint list you want to duplicate and click 'Export' from the top menu bar.
  2. Select 'Export to CSV' from the dropdown menu options.
  3. Wait for the CSV file to download, then click 'Home' to navigate back to the main SharePoint dashboard.
  4. Click on 'New' in the top navigation menu to start creating a new list.
  5. Select 'List' from the available creation options.
  6. Choose 'From CSV' to create your list from the exported file.
  7. Click 'Upload File' and browse to select the CSV file you exported earlier.
  8. Review the column data and formatting, then click 'Next' to proceed.
  9. Provide a distinct name and description for your duplicated list in the input fields.
  10. Click 'Create' to finalize the duplication process and generate your new list.

Your turn to show how it works.

Build a walkthrough of your product with Saltfish, then share it with your customers.

Create a guide with Saltfish

Frequently Asked Questions

Yes, when you duplicate a SharePoint list using the CSV export method, all data entries and basic column structures are preserved. However, some advanced formatting, custom views, and workflow automations may not transfer and will need to be recreated in the new list.