Migrate SharePoint sites libraries into one SharePoint site

Question

I have over 800 SharePoint sites. Every site has a document library. The name of the document library is “Project Folder”.

I created a SharePoint site. It is called “Projects site”. I also created 800 document libraries in the Project sites.

What I want to do is this:

I want to move/migrate all 800 SharePoint sites’ document libraries into the “Projects site” SharePoint site.

I have an excel file with all SharePoint sites links and document libraries name.

Does anyone know how to do it with PowerShell?

naligurtan · Answer

Hi&nbsp;LeonPavesic&nbsp;It does not work because I might have not explained in clearly and you may not have understood me.I will try explain it here again. I am also attaching a screenshot.&nbsp;There are over 1000 sites on the prem with ONLY one document library (Project%20Folder). I created ONLY one site on SharePoint online. I want to move all sites’ document libraries (Project%20Folder) into the new SharePoint site as a document library with the same name of the prem sites (GP56077, GP56121).All Site names from the old sites/on prem became a document library name in the new SharePoint site. All files from the Project%20Folder document libraries needs to be moved into the new document libraries such as GP56077, GP56121 etc.Please see the screenshot below.

rob_elliott · Answer

Naligurtan&nbsp;I recommend you look at ShareGate for large-scale migrations like this. It's expensive but saves a lot of hassle.&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User.Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

leonpavesic · Answer

Hi&nbsp;Naligurtan,To migrate all 800 SharePoint sites' document libraries into the "Projects site" SharePoint site using PowerShell, you can use the following steps:Install the SharePoint PnP PowerShell module:&nbsp;Install-Module SharePointPnPPowerShellOnline​&nbsp;&nbsp;Connect to your SharePoint tenant:&nbsp;Connect-PnPOnline -Url https://your-tenant-admin-url.sharepoint.com​&nbsp;&nbsp;Create a variable to store the list of SharePoint sites and document libraries:&nbsp;$sitesAndLibraries = Import-Csv -Path "C:\Path\To\Excel\File.csv"​&nbsp;&nbsp;Iterate through the list of SharePoint sites and document libraries, and copy the files from each document library to the corresponding document library in the "Projects site" SharePoint site:&nbsp;foreach ($siteAndLibrary in $sitesAndLibraries) {
    $sourceLibraryUrl = $siteAndLibrary["SiteUrl"] + "/" + $siteAndLibrary["LibraryName"]
    $targetLibraryUrl = "https://your-tenant-domain.sharepoint.com/sites/Projects/Library/" + $siteAndLibrary["LibraryName"]

Copy-PnPFile -SourceUrl $sourceLibraryUrl -TargetUrl $targetLibraryUrl
}​&nbsp;&nbsp;This script will copy all of the files from each document library in the list of SharePoint sites to the corresponding document library in the "Projects site" SharePoint site. The original files in the source document libraries will not be deleted.Please click Mark as Best Response &amp; Like 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.Kindest regards,Leon Pavesic(LinkedIn)

naligurtan · Answer

Hi&nbsp;LeonPavesic&nbsp;,&nbsp;Thanks for your reply.&nbsp;Can you please let me know the name/title of each column in this file File.csv?&nbsp;Thanks

leonpavesic · Answer

Hi&nbsp;Naligurtan,The Excel file File.csv should have two columns:SiteUrl&nbsp;- The URL of the SharePoint site containing the document library.LibraryName&nbsp;- The name of the document library.SiteUrl,LibraryName
https://contoso.sharepoint.com/sites/Site1,Project Folder
https://contoso.sharepoint.com/sites/Site2,Project Folder
// ...Please click Mark as Best Response &amp; Like 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.Kindest regards,Leon Pavesic (LinkedIn)

Forum Discussion

Migrate SharePoint sites libraries into one SharePoint site

8 Replies

Resources