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

Finally found the best work around I could as many of you are operating off the same setup that I am that lacks the ability to save a template. I did complete these steps from the app, not the web but don't see that it would be any different

Follow these steps:

1. Go to your "master" list and export to Excel
2. Save your query file and note the file location
3. Go to List > New List
4. From Excel
5. Upload File
6. Select the file that you saved from step 2 > Open
7. The Customize window will display > Next
8. Update the Name, Description, Color, Icon and Save To location
9. Create
10. And Done! The only thing that I am not seeing on my list that did not carry over is the color row coloring (which I can deal with and the hyperlinks. It lists the path but not the actual link. But at this point I will take what I can get.

Hope that this will help all the rest of you :)

Answer 3

Finally found the best work around I could as many of you are operating off the same setup that I am that lacks the ability to save a template. I did complete these steps from the app, not the web but don't see that it would be any different

Follow these steps:

1. Go to your "master" list and export to Excel
2. Save your query file and note the file location
3. Go to List > New List
4. From Excel
5. Upload File
6. Select the file that you saved from step 2 > Open
7. The Customize window will display > Next
8. Update the Name, Description, Color, Icon and Save To location
9. Create
10. And Done! The only thing that I am not seeing on my list that did not carry over is the color row coloring (which I can deal with and the hyperlinks. It lists the path but not the actual link. But at this point I will take what I can get.

Hope that this will help all the rest of you :)

Answer 4

My steps were a bit different.........

Finally found the best work around I could as many of you are operating off the same setup that I am that lacks the ability to save a template. I did complete these steps from the app, not the web but don't see that it would be any different

Follow these steps:

1. Go to your "master" list and export to Excel
2. Save your query file and note the file location
3. Go to List > New List
4. From Excel
5. Upload File
6. Select the file that you saved from step 2 > Open
7. The Customize window will display > Next
8. Update the Name, Description, Color, Icon and Save To location
9. Create
10. And Done! The only thing that I am not seeing on my list that did not carry over is the color row coloring (which I can deal with and the hyperlinks. It lists the path but not the actual link. But at this point I will take what I can get.

Hope that this will help all the rest of you :)

Answer 5

Finally found the best work around I could as many of you are operating off the same setup that I am that lacks the ability to save a template. I did complete these steps from the app, not the web but don't see that it would be any different

Follow these steps:

1. Go to your "master" list and export to Excel
2. Save your query file and note the file location
3. Go to List > New List
4. From Excel
5. Upload File
6. Select the file that you saved from step 2 > Open
7. The Customize window will display > Next
8. Update the Name, Description, Color, Icon and Save To location
9. Create
10. And Done! The only thing that I am not seeing on my list that did not carry over is the color row coloring (which I can deal with and the hyperlinks. It lists the path but not the actual link. But at this point I will take what I can get.

Hope that this will help all the rest of you :)