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 li...
I recommend following approach:
- create a new list in the target website based on the old list (via list creation dialog)
- open both lists in two browser windows in datasheet view
- select all data sets via CTRL+A in source list
- 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-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?
- 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!
