How to create a list from existing list in SharePoint Online

In this SharePoint Online tutorial we will discuss how to create a list from an existing list in SharePoint Online.

In classic SharePoint sites, we use the Save list as template option.

Create list from existing list in SharePoint Online

In the SharePoint Online modern sites, there is no Save list as template option.

This will be helpful when you try to replicate a SharePoint Online list from another list.

Open the SharePoint Online site and go to the Site Contents page. Make sure to use the modern site contents page.

Then click on New -> List like below:

Then you have the option to either create a new list or you can choose From an existing list.

Give a name for the list.

In the Select a site, it will populate all the site the user having access to from there select the site from where your existing list is presented.

Once you will select the site, it will display all the lists from the SharePoint site.

Then it will create the list like below, which will have all the columns from the existing SharePoint list.

This is how we can create list from existing list in SharePoint Online.

Few Points to Remember

But you have to remember few points.

• The site contents page from where you will create a list, should be a modern site contents page.
• When you will create the new list, it will create the entire structure of the list, like forms, formatting, and custom metadata columns that will be copied also.
• But the SharePoint list contents will not be copied.
• Discussion board and document libraries are not supported to create a list from an existing list.

In the future, Microsoft will release another new feature to Create a list From Excel in SharePoint Online very soon.

You may like Microsoft Lists – Create a List from Excel.

In this tutorial we learned how to create a list in SharePoint Online.