Export All SharePoint Sites in Excel Using PowerShell

In today’s post, we will see how we can export a report to Excel containing all the SharePoint sites in our tenant.

This is a process that cannot be automated inside SharePoint itself.
The only place where we can see all sites is the SharePoint Admin Center, where we do have visibility of all tenant sites—but there is no option to export them to Excel.

To achieve this, we can only use the following PowerShell script:

# --- SETTINGS ---
$adminUrl = "https://mytenant-admin.sharepoint.com" # Your Admin URL
$clientId = "000000-0000-0000-0000-000000000000"
$exportPath = "$home\Desktop\All_SharePoint_Sites.csv"

try {
    Write-Host "Connecting to SharePoint Admin Center..." -ForegroundColor Cyan
    
    # 1. Connect using your ClientId
    Connect-PnPOnline -Url $adminUrl -Interactive -ClientId $clientId

    Write-Host "Retrieving all sites (this may take some time)..." -ForegroundColor Yellow

    # 2. Get all Site Collections
    # We use -Detailed to include more metadata (Storage, Owner, etc.)
    $allSites = Get-PnPTenantSite -Detailed

    # 3. Select the fields we want for the Excel export
    $siteData = $allSites | Select-Object `
        Title, `
        Url, `
        Template, `
        StorageQuota, `
        StorageUsageCurrent, `
        Owner, `
        LastContentModifiedDate, `
        Status

    # 4. Export to CSV (Excel friendly)
    $siteData | Export-Csv -Path $exportPath -NoTypeInformation -Encoding UTF8 -Delimiter ","

    Write-Host "----------------------------------------------------------" -ForegroundColor White
    Write-Host "✅ EXPORT COMPLETED SUCCESSFULLY!" -ForegroundColor Green
    Write-Host "File saved at: $exportPath"
    Write-Host "Total Sites: $($siteData.Count)"
    Write-Host "----------------------------------------------------------"

} catch {
    Write-Host "❌ ERROR: $($_.Exception.Message)" -ForegroundColor Red
} finally {
    Disconnect-PnPOnline
}