SharePoint Online: Download Files from a CSV using PowerShell
Requirement: Download all files from a CSV file in SharePoint Online
PowerShell Script to Bulk Download All Files from a CSV in SharePoint Online
I have got a number of files in Excel file and wanted to download them all to my local machine. Here is my CSV file – Tab-separated text file (Because file names may have commas in it and CSV will break!)
This PowerShell script downloads all files from a given SharePoint Online site. Creates a log file of all possible failed ones, E.g. The file doesn’t exist on the site!
#Parameters
$SiteURL = "https://crescent.sharepoint.com/sites/KPMG"
$CSVFile = "C:\Temp\KPMG.txt" #Tab Separated file
$DownloadPath = "C:\Temp\KPMG"
$LogFile = "C:\Temp\Error.log"
Try {
#Get Data from CSV File
$CSVData = Import-CSV -path $CSVFile -Encoding UTF8 -Delimiter "`t"
#Connect to PnP Online
Connect-PnPOnline -Url $SiteUrl -UseWebLogin
#Iterate through each Row in the CSV
foreach ($Row in $CSVData)
{
#Prepare the Local Folder
$FileDownloadPath = $DownloadPath + $Row.ServerRelativeURL.Replace("/","\")
$FileName = Split-Path $FileDownloadPath -leaf
$ParentFolder = Split-Path $FileDownloadPath -Parent
#Create the Target Folder if it doesn't exists
If(!(test-path $ParentFolder))
{
New-Item -ItemType Directory -Force -Path $ParentFolder | Out-Null
}
Try {
Get-PnPFile -Url $Row.ServerRelativeURL -Path $ParentFolder -AsFile -ErrorAction Stop
Write-host "Downloaded File" $Row.ServerRelativeURL
}
Catch {
write-host -f Red "Error Downloading File $($Row.ServerRelativeURL) :" $_.Exception.Message
$Row.ServerRelativeURL | Out-File $LogFile -Append
}
}
}
Catch {
write-host -f Red "Error:" $_.Exception.Message
}
