Forum Discussion
Copy SharePoint List to the another new site
Hello everyone!
I am trying to copy the existing SharePoint online list to another site. Can someone help me with this?
My company is only using SP2019 with a lot of reduced and suppressed functionality due to security restrictions so none of the solutions I have discovered to date are available to me. But I found a way using File Explorer.
- Go to the List Settings of your source list and save the list as a template.
- Open the link provided at the end of this operation to the template list (something like https://yoursite.com/intranet/subsite/_catalogs/lt/Forms/AllItems.aspx)
- Copy that as far as /It and paste into an Explorer window and you'll see all the template files used on your site as .stp files
- Open the same template area on your target site and navigate to the same folder in another Explorer window
- Simply copy and paste the desired .stp file to the target site in Explorer and this will now be available when you add an App from Site Contents. If you included the contents at step 1, this will also be present in your new list.
I was amazed it worked as copying Pages this way is a dead end but it did and it saved me hours of recreating lists last month.
Hopefully this will help anyone else who is stuck in an old version of Sharepoint due to Enterprise licensing and years behind the drag curve because of a tens-of-thousand strong IT real estate.🙄
I have Teams and wanted to move a list from one team to another. To do this I opened the list in Teams and exported it using the Export to Excel option, saved to my desktop. Then I opened the destination team and wend to Site Contents and New List and followed the dialogues to load from the file saved on my desk top - this worked and was relatively painless.
sbhan4 you can add a new list via "Site Contents" referencing the list from the other site. This will being over the structure and any dependent lists. Then, export all of the data from the other list(s) out to Excel and then import it into the new list(s). You'll lose, history, etc. but at least you have your data. There may very well be cleaner/better ways but it's simple enough.
sbhan4 There appears to be no way to "move" a list from one Sharepoint site to another within the tenant. This is a major design flaw. Luckily I discovered this issue early on and only spent a few hours trying to find the answer. Back to using Excel. It's bizarre that you can move documents but not lists.You can move list templates! Aren't documents stored as lists? Is there a Powershell command to copy lists? no one seems to know.It does not seem to be in the PS documentation.
sbhan4 Which site templates are you using? Communication site or teams site?
You can create a list from an existing list in SharePoint Online. Check the documentation at:
Create a new list based on the columns in another listWhen you do this, the entire list structure is copied, including views, formatting, and columns. However, the actual content of the original list isn't be copied.
You can also try following the solution given in below link if you are not using the O365 group connected site (using site templates):
Copy list to another sitePlease click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
I just found a very easy way, at least if your in the same tenant.
- Create the new list on the receiving site, and create it based on an existing list - this way all columns and types are copied.
- Open to original list, enter grid view, mark all lines and copy using Ctrl-C
- Open the receiving list, enter grid view
- Click Add new item and mark the line with the check box in the beginning.
- Press Ctrl-V - and watch the magic 🙂
will this step brings all the attchment togather Björn Clemenson
