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

@Arck - Your solution just imports a list of data without formatting the new list the same as the old list including drop downs, conditional formatting, etc.  How can we duplicate an entire list with all of it's bells and whistles AND it's data?

Answer 3

I'm having the same problem. I want to duplicate the exact Microsoft List with data AND formatting.

It seems that it's impossible?

Answer 4

Apparently it is not. Many of us do not have that option.

Answer 5

Ah yes, I mentioned that in an earlier response: "you probably have to fiddle around with 2 or 3 layers of nonsense they don't mention anywhere before you see it like enabling custom scripting etc."

Msft obtusely refers to the add and customize pages option as "enabling custom scripting". Why the ability to save a list or site template is blocked by a feature that only mentions "pages" is anyone's guess.