Forum Discussion
How to copy SharePoint Online list to a new SP Online site
**UPDATE: I asked our company SP admin, if they have the ability to move content and they were able to do it. I don't have the same rights they do so I don't know what/how they did it.**
I have a list in a SP Online Communication site that has about 20-25 columns and 150 entries. I need to copy or move to a new SP Online Communication site. I need to be able to copy the actual list as well as the content due to the amount of content. It would be difficult to recreate it. A SharePoint developer created the previous site and it's very developed - not "out of the box" site so I don't know much about it. Is this possible to copy list and content?
The list is viewed via PowerApp canvas form.
TIA for your help!
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.🙄
- Hello AndreS - I cannot find the Datasheet view. I see grid view. I looked this up in MS Support and it says that the Datasheet component isn't available in 64-bit versions of office?
https://support.microsoft.com/en-us/office/you-can-t-view-a-sharepoint-list-in-datasheet-view-ae44040f-9e4a-4a00-ab5c-a9fecfa96ad2
If I'm looking at the wrong info, can you tell me how I can open list in datasheet view?What about exporting the list a Excel file and recreate the list from that Excel?
