Duplicate a Microsoft List with content/data?

Question

Hello,

With the new Mircosoft Lists, I see that we can create a template based on an existing List. When we create a new List based off of the template, we get the same formatting and column headings. That is great.

However, we would like to be able to duplicate an entire List, including the content/data.

How can one duplicate a Microsoft List including the data?

Answer 1

Hi Sammatz,

Thanks for using Microsoft products and posting in the community, I'm glad to offer help.

To copy a list including the list contents, you can follow the following steps:

1. Open the source list > Export to Excel.  
2. Open the exported *.iqy file > import it as a table > save the workbook as *.xlsx file.  
3. Go to Microsoft Lists > New list > From Excel > upload the saved workbook (*.xlsx).  
4. Edit the data and create the duplicate list. (You can delete the last two columns ("Item Type" & "Path") after creating the list)  

Hope the above suggestion can be helpful, and please feel free to let me know if you have any concerns, I'll continue to help you.

Best Regards,

Arck

Answer 2

Noted in my other post: You can also just use the direct url:

Open list settings and replace listedit.aspx with savetmpl.aspx in the url

Doesn’t work. Tried that when you suggested it weeks ago.

Answer 3

It's worked since SP Online was launched and still does - so it could be an issue in your tenant and your best option is to submit a support ticket.

Answer 4

Yes - I posted how we do it above:

Simplest option:

List settings > save list as template (include content) > add an app > select template.

Downside is the pathetic size limitation.

I have managed to save list as template (including content. But I can't find the last 2 steps of your solution. When I chose "New list" > "From template", my custom template is not included.

From the "Galary with list templates" I cannot seem to create a new list from the template I made

Answer 5

Just to confuse everyone even more, Msft has introduced a modern apps page so you have to go back to the "classic" apps page to create a list from a template. Don't go from the template gallery - click add an app. If it opens on the modern apps page, your template won't be visible. To make things worse, there's no link provided to see classic apps. You have to search and then click the link to open the classic page:

No matching results found. Built-in apps can be found in the classic experience

So go from here: /_layouts/15/appstore.aspx/myApps - go to classic apps page and click your template. Leave it to Msft to make what was already a poor user experience even more arcane.