SharePoint Online: How to Create a New List from Existing List?

Requirement: Create a list from an existing list in SharePoint Online.

SharePoint Online: Create a List from an Existing List

Creating a list similar to the existing list structure is a common requirement in SharePoint. We used the “Site list as Template” approach in previous versions of SharePoint and in the Classic experience of the SharePoint Online site. Now, in modern sites, this approach is not supported.

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

  • Go to Site Contents Page (Click on “Settings” gear >> Choose “Site Contents”), click on the “New” menu and choose List.
    sharepoint online copy list structure
  • This opens a new list creation page which provides an option to create a new list from the existing list. Not just a list from the same site, but you can select different site collections even!
  • Provide a name to your new list, select the source list to clone, and click on the “Create” button on the bottom to copy the existing list structure in SharePoint Online.
    sharepoint online create list from existing list

Unlike the “Save List as Template” approach, this method uses the “Site Script” method to get the list schema and create a new list. With this approach, All fields, Views, formatting, and content types will be copied from the source list is copied into the new list you create. It also maintains the lookup column relationships by creating parent lists.

Please note, We don’t have an option to copy a list with its content in this approach. Also, Document Library and Discussion Board list types are not supported as of today. Also, creating a new list with this approach discards most of the list settings and permissions on the source list.

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!

One thought on “SharePoint Online: How to Create a New List from Existing List?

  • Hi, thank you for sharing your knowledge on Lists. I understand that Lists does not have the full copy option. Do you know why this is? I’m fulling my hair out trying to find a way to do this. Seems simple enough. Is there at least an import function that will upload the list into a template table/list that has all the column settings and json formatting configured?


Leave a Reply

Your email address will not be published.