How to Copy a List in SharePoint Online?

Requirement: Copy a List in SharePoint Online

How to Copy a List in SharePoint Online?

If you’re working in SharePoint Online, there may be times when you need to duplicate a list. Maybe you want to make a copy of an existing list for testing purposes, or perhaps you need to create multiple lists with similar information. Whatever the reason, duplicating a list is a quick and easy process. This article will show you how to duplicate a list in SharePoint Online. Let’s get started!

The modern SharePoint Online sites provide a nifty way to create a list from existing lists. Here is how to make a copy of a list in SharePoint Online:

  1. Go to the SharePoint site where the source list is located.
  2. From the Home page, click on the “New” button and then choose “List” in the toolbar at the top of the page. You can also go to the “Site Contents” Page (Click on “Settings” gear >> Choose “Site Contents”), click on the “New” menu and choose “List”.how to copy sharepoint online list to another site
  3. This opens a new list creation page, which provides an option to create a new list from the existing list. “Create a list” page. Click on the “From existing list” button on the page.how to copy list sharepoint online
  4. Select the source list to clone and click on the “Next” button on the bottom to copy the existing list structure. You can pick a list from different site collections even! sharepoint online copy list to another site collection
  5. Provide a name to your new list, and click on “Create” to complete the process.copy list from one sharepoint online site to another

The new list will be created with all of the same fields as the original list.

The above method just copies the structure of the list without copying any data from it! How about copying lists between sites with data?

SharePoint Online: Copy List from one site to another using PowerShell

Copying a SharePoint list from one site to another manually can be time-consuming and error-prone. But with PowerShell, it’s easy to automate the process! Let me show you how to use PowerShell to copy a SharePoint list with content from one site to another.

#Parameters
$SourceSiteURL = "https://crescent.sharepoint.com/sites/Retail"
$TargetSiteURL = "https://crescent.sharepoint.com/sites/Sales"
$ListName= "Projects"
$TemplateFile ="$env:TEMP\Template.xml"

#Connect to the Source Site
Connect-PnPOnline -Url $SourceSiteURL -Interactive

#Create the Template
Get-PnPSiteTemplate -Out $TemplateFile -ListsToExtract $ListName -Handlers Lists

#Get Data from source List
Add-PnPDataRowsToSiteTemplate -Path $TemplateFile -List $ListName

#Connect to Target Site
Connect-PnPOnline -Url $TargetSiteURL -Interactive

#Apply the Template
Invoke-PnPSiteTemplate -Path $TemplateFile

If your list is using any lookup fields, make sure you copy the parent list first! Otherwise, you may run into “Invoke-PnPSiteTemplate : Value does not fall within the expected range.” error.

Here is another post on copying the items in the list, use: Copy items from one list to another in SharePoint Online using PowerShell

Salaudeen Rajack

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

Leave a Reply

Your email address will not be published.