Create SharePoint lists from other lists
Published May 05 2019 11:39 PM 71.2K Views
Microsoft

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 listsCreating 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.

57 Comments
Copper Contributor

I'm also getting the same issue on sub-sites with the lists. @Chris McNulty 

Brass Contributor

As mentioned earlier in this thread I have the solution for moving/synchronizing/updating/deleting items in Lists AND Libraries from Excel,CSV,Other SP list in any farm or tenant or from SQL.

Also creating lists based on the columns from any data source is there.

 

I can provide it free for anyone interested  :)  just shoot me an email at sj@nocodesolution.com  or in this forum.

 

//Steen

 

Copper Contributor

@Chris McNulty 

In my tenant I do not have the option to create a list from Excel as shown in your screenshot. How do I get this feature deployed to my tenant?

Brass Contributor

It is FINALLY here!!!

 

While we are all waiting the excel to SP feature, this freeware has turned up and does the job.

https://docs.nocodesolution.com/fusion/1/en/topic/freeware

 

// Steen

Brass Contributor

It's finally here :)

 

This free utility (Fusion) does the job of creating list from Excel or virtually any data source and SYNC the data.

Also you can define the columns in the list to be site columns and even apply a default content type

 

download: https://www.nocodesolution.com/

feature list: https://docs.nocodesolution.com/fusion/1/en/topic/fusion-feature-list

Bronze Contributor

@Chris McNulty , Is the lists from Excel spreadsheet feature you mention in your blog post still coming this year?  I don't see it in my tenant yet.  

Microsoft

@Eric Davis Yes it is still underway. If you have a specific issue, you can reach out to support to check on the status.

Version history
Last update:
‎Apr 08 2020 10:31 AM
Updated by: