Share via

Transfer a list from one site to another

Anonymous
2022-10-27T19:25:14+00:00

I am working on transferring lists from an old sharepoint site to a new one. From what I've researched, there is no way to do this without spending at least a week manually working on the data. to explain the available options:

  1. I transfer the list via (New>List>from existing list>*choose your list*) this results in the template with no data so you must now manually enter each line of data.
  2. export the existing list to excel which results in none of the attached documents transferring to excel.. so now you must identify and reattach all of your documents to their relative line.
  3. manually change version of SharePoint to the 2016 version and 'Open with Microsoft Access'

is there any way to move a list from one SharePoint site to another without having to manually change the properties of the program or 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. matt howell 3,511 Reputation points
    2022-10-27T22:27:15+00:00

    If you don't have access to a migration tool like Sharegate, because the underlying functionality of SP hasn't changed, the easiest option is to save lists as templates and then upload the template to the target site's gallery. Not useful if you have large lists above 50mB due to Msft's rather pathetic limitations. In that scenario, I'd save the list as a template without content, recreate it in the target site, connect the source list to an Access database, and then sync the new list with that database. I'm not sure if the links to attached documents will get updated though.

    It's so typical of Msft that they dumped a new version of Sharepoint on us but offered absolutely no useful migration options. Other companies like Sharegate were able to come up with a really good option, so it's pretty telling that Msft didn't bother.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments