How to create a SharePoint list from an existing list with same columns, views, formatting, data


Ever came across a need to create a similar list in SharePoint based on an already existing list, with same structure, columns. Legacy SharePoint versions have provided a way to save list as a template and reuse it for new list creation.
With SharePoint Online, you can duplicate a list more easily and quickly!

For creating similar lists, SharePoint Online Modern interface gives you a way to create it from an existing list. The entire list structure is copied, including views, formatting, and columns in this approach. However, the actual content is not copied from the original list.

Select a list to use as a template for a new empty list on this site.
Columns, views and formatting will copy over to the new list.

Steps to create new SharePoint list based on an existing list

  1. Navigate to your SharePoint site.
  2. Go to Settings --> Site Contents.
  3. Click New --> List.
  4. Enter a name for your list.
  5. Check/Uncheck 'show in site navigation'.
  6. Click 'From an existing list'.
  7. Select a Team or Site - select this site or any other site collection. All sites where you have access are listed here.
  8. Choose a list from your selected site.
  9. Click Create.

The great part is, you can even refer to lists from different SharePoint Site Collection. The same approach can be used from within Microsoft Teams by opening corresponding SharePoint Site by clicking Files --> 3 dots (...) --> Open in SharePoint.


Comments:

  • This works great, but I observed the permissions do not copy over. Setting up the permissions again is a pain. I prefer saving list as a template, import-export and then create new one using template.
    anon 29 Aug 2020 17:01:32 GMT
  • How can I copy all list items to new list ?
    anon 20 Aug 2020 07:54:11 GMT
  • Further comments disabled!