Blog Post

Microsoft SharePoint Blog
2 MIN READ

Create SharePoint lists from other lists

Chris McNulty's avatar
Chris McNulty
Icon for Microsoft rankMicrosoft
May 06, 2019

Changing the way business gets done – digital transformation – begins with great data. Microsoft 365 offers powerful tools for building workflows, automation and reporting – Power Apps, Power Automate, and Power BI. But you need a great place to store all that data.

 

Every month, millions of users turn to SharePoint lists to store critical business data.  Lists are secure, easy to use, and high capacity, with up to 30 million items in a single list.  Today, across Microsoft 365, SharePoint lists store billions of rows of data to house information for scenarios like customers, audits or emergency room availability and more across Microsoft 365.

 

Now, we’re making it easier than ever to get started with a list – by leveraging other lists as a starting point.

Create a SharePoint list from an existing list

Lists are shareable, secure, mobile friendly, easy to use and easy to customize. And as we previewed at SharePoint Conference 2018, we’re releasing new abilities to let you create new lists from an existing list. To do this, you start from the Site Contents page.

 

You can create a list from all existing lists within any site where you’re an editor.  When the new list is created, the entire list structure is copied, including forms, formatting, and custom metadata columns.  Note: Content from the existing list will not be copied.

 

Creating a list from other lists

Next steps

Want to try this out now?  Head over to the Business Apps Resource Center for a demo.

 

We’ll start rolling out the new list creation experience to Targeted Release in mid May 2019.   You can share your feedback with us here on the TechCommunity, on UserVoice or at the SharePoint Conference.  As always, if you need more details you can find it on our Microsoft 365 Business Apps Resource Center

 

Thanks, Chris McNulty, senior product manager - Microsoft

 

[Update: April, 8th, 2020] "List from Excel" was previously shared in this blog post, but delayed from release. Thus, we removed mention of "List from Excel" as we prepare a unique announcement on "List from Excel" and pare this one down to solely highlight "List from existing list" - and minimize confusion to anyone reading this blog post going forward.

Updated Apr 08, 2020
Version 5.0