Share via

Duplicate a Microsoft List with content/data?

Anonymous
2021-02-28T17:28:55+00:00

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?

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2021-03-01T03:47:30+00:00

    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

    67 people found this answer helpful.
    0 comments

36 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-12-08T14:43:27+00:00

    This solution is great, but if we export the list and import it again then it doesn't contain the former formatting. For example embedded links won't work anymore or MS user names marked as mentors are displayed with hashtags and random numbers. Any advise?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-01-26T20:47:39+00:00

    While this solution may work, it's much too complicated/broken for my team to use.

    6 people found this answer helpful.
    0 comments
  3. Anonymous
    2021-03-04T09:18:23+00:00

    Hi Sammatz,

    I'm writing this reply to follow up this thread, may I know if you have checked my last reply? When you have time, you are welcome to come back and let us know if you still need help here.

    Hope you are all well during this period, stay safe and have a nice day : )

    Best Regards,

    Arck

    0 comments
  4. Anonymous
    2021-05-28T22:43:33+00:00

    Hi Arc,

    This is not the most assertive solution. What about with those lists with a complex functionality? Even with simple functionality but with validations and multiple options.

    Hopefully Microsoft includes this option in the future.

    Thanks,

    25 people found this answer helpful.
    0 comments