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.


  • 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!
Try Out Code2care Dev Tools:


Android Java Linux Microsoft Google Python macOS Notepad++ Microsoft Teams CSS PHP SharePoint Html Linux C Programs Bootstrap jQuery Sublime Android Studio Facebook Eclipse WhatsApp News MySQL Json HowTos JavaScript FTP S3


Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and Software Developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include Learnings, Tutorials, Trouble-Shooting steps, Video Tutorials, Code Snippets, How Tos, Blogs, Articles, etc.
🎉 We are celebrating the 10th years of Code2care! Thank you for all your support! We hope we made a difference.
We strong support Gender Equality & Diversity.

We stand in solidarity with Ukraine - Make a donation to UNHCR -