How to copy SharePoint Online list to a new SP Online site

Copper Contributor

**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!

4 Replies

@LopaAtl 

I recommend following approach:

  1. create a new list in the target website based on the old list (via list creation dialog)
  2. open both lists in two browser windows in datasheet view
  3. select all data sets via CTRL+A in source list
  4. copy the data sets via clip board to new list
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-ae4404...
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?

I'm trying to avoid that if possible as it's around 3000 cells to fill in. If there are no other options, that's what I'll have to do because I need to get the content moved over. Thanks!