Upload File to SharePoint Library using PowerShell

We had a PowerShell script code to generate Large Lists reports in D:\Reports, and now want to periodically upload them to a document library "Reports" in my Admin site. So, scheduled a PowerShell script to do so. Here is my PowerShell code to upload the report to a document library.

Upload a File to SharePoint Library using PowerShell

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue 

#Function to Upload File
Function Upload-File($WebURL, $DocLibName, $FilePath)
{
    #Get the Web & Lists to upload the file
    $Web = Get-SPWeb $WebURL
    $List = $Web.GetFolder($DocLibName) 

    #Get the Files collection 
    $Files = $List.Files 

    #Get File Name from Path
    $FileName = $FilePath.Substring($FilePath.LastIndexOf("\")+1) 

    #Delete the File from library, if already exist!
    If($Files.Item($DocLibName +"/" + $FileName))
    {
        $Files.delete($DocLibName +"/" + $FileName)
    }
    #Get the File
    $File= Get-ChildItem $FilePath

    #Add File to the collection
    $Files.Add($DocLibName +"/" + $FileName,$File.OpenRead(),$false)

    #Dispose the objects
    $web.Dispose()
}
 
#call the upload function
Upload-File "http://sharepoint.company.com" "Monthly Reports" "D:\Reports\LargeLists.txt"

Upload File to SharePoint using PowerShell with Metadata:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
 
#Function to Upload File and set metadata of the file
Function Upload-FileWithMetadata($WebURL, $DocLibName, $FilePath)
{
    #Get the SharePoint Web & Lists to upload the file
    $Web = Get-SPWeb $WebURL
    $List = $Web.GetFolder($DocLibName)
 
    #Get the Files collection from SharePoint Document Library
    $Files = $List.Files
 
    #Get File Name from Path
    $FileName = $FilePath.Substring($FilePath.LastIndexOf("\")+1)
 
    #Get the File from Disk
    $File= Get-ChildItem $FilePath

    #Set the Metadata
    $Metadata = @{}
    $Metadata.add("Department", "Sales")
    $Metadata.add("Location", "APAC");
 
    #Add File to Files collection of Document Library
    $Files.Add($DocLibName +"/" + $FileName,$File.OpenRead(), $Metadata,  $true) #true for overwrite file, if already exists!

    <# Alternatively, You can set the metadata as: 
       $UploadedFile=$Files.Add($DocLibName +"/" + $FileName,$File.OpenRead(), $true)
       $UploadedFile.Item["Department"]="Sales"
       $UploadedFile.Item.Update() 
    #>   
}
  
#call the upload function
Upload-FileWithMetadata "http://sharepoint.company.com" "Monthly Reports" "E:\Reports\UsageReport.csv"

If you are looking for a way to upload Files to SharePoint List or Library using C#, Have a look at my another post: How to Programmatically upload File to SharePoint document library?

If you wan to upload Multiple Files in Bulk, Refer: Bulk upload files to SharePoint using PowerShell