Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue Function Get-DocumentsSizeAndType([string] $SiteCollURL) { Get-SPSite $SiteCollURL | Get-SPWeb -Limit All | ForEach-Object { #Iterate through each document library Foreach ($SPList in $_.Lists) { #Get Document Libraries If($SPList.BaseType -eq "DocumentLibrary") { foreach ($item in $SPList.Items) { $Data = @{ "Web" = $_.Url "Library name" = $SPList.Title "File URL" = $item.Url "File Name" = $item.Name "File Created" = $item["Created"] "File Modified" = $item["Modified"] "File Size (MB)" = $item.File.Length/1MB "File type" = $item["File Type"] } } Write-Host($_.Url +"/"+ $Item.Url) New-Object PSObject -Property $data } } } } #call the function Get-DocumentsSizeAndType "Your site collection URL" | Export-Csv -NoTypeInformation -Path "C:\Temp\TypeAndSizeDocuments.csv"