SharePoint Document Issues

How to Export SharePoint Site Owners and Email Addresses Using PowerShell

Algirdas Jasaitis Oct 13, 2026 869 views

Question details

The user needs to extract a list of site owner names, email addresses, and URLs across multiple SharePoint sites in bulk.

Export SharePoint Site Owners and Email Addresses Using PowerShell

Product: SharePoint Online
Device & OS: not provided
Scenario: Auditing or managing large-scale SharePoint environments where administrator details need to be documented.
Observed behavior: SharePoint Online lacks an out-of-the-box feature to export this administrator and site data across thousands of sites simultaneously.

Before you start

Ensure you have SharePoint Administrator or Global Administrator privileges and have the PnP PowerShell module installed on your system.

Solution 1Recommended

Use a Custom PnP PowerShell Script

Since there is no built-in UI option, running a custom PnP PowerShell script is the recommended and most effective way to extract site collection administrator details in bulk.

PowerShell allows administrators to automate the retrieval of site owner names, email addresses, and site URLs across thousands of SharePoint sites. The PnP (Patterns and Practices) PowerShell module simplifies interacting with SharePoint Online.

Install the PnP PowerShell Module

Open your PowerShell console as an Administrator and run the command: Install-Module -Name PnP.PowerShell to ensure you have the required tools.

Connect to your SharePoint Admin Center

Use the Connect-PnPOnline cmdlet and provide your SharePoint Admin Center URL and credentials to authenticate your session.

Execute the extraction script

Run a customized script that utilizes Get-PnPTenantSite to loop through all site collections, then uses Get-PnPUser to filter and retrieve users with owner permissions.

Export the results to CSV

Pipe the output of your script to the Export-Csv cmdlet to save the compiled list of site URLs, owner names, and email addresses to a local file for reporting.

Scripting Assistance: If you need help writing the specific script, you can post your requirements in the Microsoft Q&A forums or the PowerShell community, where many pre-written templates for this task exist.

Free Microsoft Office alternative

Analyze Your Exported SharePoint Data with WPS Office

After exporting your SharePoint site owners to a CSV file using PowerShell, you need a reliable spreadsheet tool to view and manage the data. WPS Office is a powerful, free alternative to Microsoft Office that easily handles large CSV files and provides advanced filtering options.

1. Open WPS Spreadsheet: Launch WPS Office and select Spreadsheet from the main workspace.
2. Import your CSV report: Go to Menu > Open and select the CSV file generated by your PowerShell script.
3. Format and filter data: Select your header row and use the Data tab to apply filters to your site owner names, emails, and URLs for easy auditing.

Fully compatible with Microsoft Excel (.xlsx, .csv) formatsLightweight and fast for opening large SharePoint admin reportsFree to use with a familiar, easy-to-navigate interfaceCross-platform support for Windows, Mac, and Linux

microsoft office alternative - wps office

Frequently Asked Questions

Can I export SharePoint site owners in bulk without PowerShell?

No, SharePoint Online does not offer a native out-of-the-box UI feature to bulk export site owners across multiple sites. You must use PowerShell or third-party administration tools.

What permissions are needed to run the PnP PowerShell script?

You need to have SharePoint Administrator or Global Administrator rights within your Microsoft 365 tenant to query site collections and their respective owners globally.

Where can I find pre-written PowerShell scripts for SharePoint?

You can find script templates and ask for detailed scripting assistance in the Microsoft Q&A portal, Microsoft Tech Community, or dedicated PowerShell GitHub repositories.

How do I format the PowerShell output for easy reading?

By using the Export-Csv cmdlet at the end of your PowerShell script, you can generate a CSV file. This file can then be opened and formatted in spreadsheet software like Microsoft Excel or WPS Spreadsheet.

Document & File Issues