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. Creating a list from an existing list in Sharepoint Online can be a great way to quickly create a new list without having to manually create all of the items in the list. It also allows you to easily make changes to an existing list without having to recreate the entire list.

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 article provides step-by-step instructions on how to create a new list based on the columns of an existing list.

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

  1. 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
  2. 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!
  3. 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

The new list will now appear in the list of existing lists on your Sharepoint site. You can now edit the new list as you would any other list. For example, you can add new items to the list, change the list settings, and even delete items from the 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 into the new list you create. It also maintains the lookup column relationships by creating parent lists.

Please note, We don’t have the 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!

2 thoughts on “SharePoint Online: How to Create a New List from Existing List?

  • When selecting a site, I am getting a very short list to choose from even though I am an owner of several other sites. Is there a way to get certain sites that you have permission to see, show up in the list of available sites?

    Reply
  • 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?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *