Export all site pages details from Site Pages library

Summary

This PowerShell script uses the PnP PowerShell module to connect to a SharePoint Online site and extract metadata from the Site Pages library. It collects key information for each page—such as titles, URLs, authorship, creation and modification dates, layout type, and banner image details—and exports the results to a timestamped CSV file for reporting and analysis purposes.

Why It Matters / Real-World Scenarios

Organizations often lack visibility into the volume, ownership, and status of modern SharePoint pages. This script enables administrators and site owners to:

• Perform content audits prior to migrations, restructures, or clean-up initiatives
• Identify outdated, unused, or orphaned pages
• Support governance and compliance reviews by providing page ownership and modification history
• Create an inventory of pages for site redesigns or information architecture planning

Benefits of the Reported Data

• Improved Governance: Clear visibility into who created and last modified each page
• Operational Insight: Understand page usage patterns and content lifecycle
• Risk Reduction: Identify pages with missing ownership or stale content
• Decision Support: Enables data-driven decisions for site cleanup, archiving, or redesign
• Audit Readiness: Produces a structured, exportable record of SharePoint page metadata

Implementation

• Open Windows PowerShell ISE
• Create a new file
• Write a script as below,
• First, we will connect to the site from which site we want to get Site Pages library details.
• Then we will get Site Pages details and export it to CSV.

• PnP PowerShell V2
• PnP PowerShell

# ============================
# Configuration
# ============================
$SiteUrl  = "https://domain.sharepoint.com/"
$BasePath = "E:\Contribution\PnP-Scripts\Logs"
$DateTime = Get-Date -Format "MM_dd_yy_HH_mm_ss"
$CsvPath  = Join-Path $BasePath "SitePages_$DateTime.csv"

# Ensure log directory exists
if (-not (Test-Path $BasePath)) {
    New-Item -ItemType Directory -Path $BasePath | Out-Null
}

# ============================
# Connect to SharePoint
# ============================
function Connect-ToSharePoint {
    param (
        [Parameter(Mandatory)]
        [string]$Url
    )

    try {
        Write-Host "Connecting to $Url..." -ForegroundColor Yellow
        Connect-PnPOnline -Url $Url -Interactive
        Write-Host "Connected successfully!" -ForegroundColor Green
    }
    catch {
        throw "Failed to connect to SharePoint: $($_.Exception.Message)"
    }
}

# ============================
# Get Site Pages Metadata
# ============================
function Get-SitePagesDetails {
    try {
        Write-Host "Retrieving Site Pages..." -ForegroundColor Yellow

        $pages = Get-PnPListItem `
            -List "Site Pages" `
            -PageSize 500 `
            -Fields ID,Title,Description,PageLayoutType,FileRef,FileLeafRef,
                    Created_x0020_Date,Last_x0020_Modified,
                    Modified_x0020_By,Created_x0020_By,
                    Author,Editor,BannerImageUrl,File_x0020_Type

        $results = foreach ($page in $pages) {
            [PSCustomObject]@{
                ID              = $page.Id
                Title           = $page["Title"]
                Description     = $page["Description"]
                PageLayoutType  = $page["PageLayoutType"]
                FileRef         = $page["FileRef"]
                FileName        = $page["FileLeafRef"]
                Created         = $page["Created_x0020_Date"]
                Modified        = $page["Last_x0020_Modified"]
                CreatedBy       = $page["Author"]?.Email
                ModifiedBy      = $page["Editor"]?.Email
                BannerImageUrl  = $page["BannerImageUrl"]?.Url
                FileType        = $page["File_x0020_Type"]
            }
        }

        return $results
    }
    catch {
        throw "Error retrieving Site Pages: $($_.Exception.Message)"
    }
}

# ============================
# Export to CSV
# ============================
function Export-ToCsv {
    param (
        [Parameter(Mandatory)]
        [object[]]$Data,

        [Parameter(Mandatory)]
        [string]$Path
    )

    try {
        Write-Host "Exporting data to CSV..." -ForegroundColor Yellow
        $Data | Export-Csv -Path $Path -NoTypeInformation
        Write-Host "Export completed: $Path" -ForegroundColor Green
    }
    catch {
        throw "CSV export failed: $($_.Exception.Message)"
    }
}

# ============================
# Main Execution
# ============================
try {
    Connect-ToSharePoint -Url $SiteUrl
    $SitePages = Get-SitePagesDetails
    Export-ToCsv -Data $SitePages -Path $CsvPath
}
catch {
    Write-Host $_ -ForegroundColor Red
}

Check out the PnP PowerShell to learn more at: https://aka.ms/pnp/powershell

The way you login into PnP PowerShell has changed please read PnP Management Shell EntraID app is deleted : what should I do ?

Output

• Format: CSV
• Location: Configurable output directory
• File Naming: Timestamped (prevents overwriting previous reports)

Notes

• Requires appropriate permissions to read the Site Pages library
• Supports modern authentication (MFA-compatible)
• Designed for single-site execution but easily extendable to multiple sites

Contributors

Author(s)
Chandani Prajapati
Josiah Opiyo

Built with a focus on automation, governance, least privilege, and clean Microsoft 365 tenants—helping M365 admins gain visibility and reduce operational risk.

Disclaimer

THESE SAMPLES ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.