How to Get a Central SharePoint Online Sharing Report
Question details
The user wants to know how to generate a central report of file sharing activities in SharePoint Online to monitor external access and audit sharing links.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Administrators need to track and audit external sharing links and access governance across various SharePoint sites.
- Observed behavior
- Admins need a reliable method to view all sharing links created recently or export a comprehensive audit log for security and compliance.
Ensure you have SharePoint Administrator privileges or Global Admin rights in Microsoft 365 before attempting to access Data Access Governance reports or run external sharing PowerShell scripts.
Generate a Sharing Links Report via SharePoint Admin Center
The easiest way to review recent sharing activity without writing code is through the built-in Admin Center reports.
This built-in method provides a visual dashboard for administrators to monitor sharing activities across the tenant. It focuses on the highest number of sharing links created over a 30-day window.
Log in to the Microsoft 365 Admin Center with your administrator credentials and navigate to the SharePoint Admin Center.
In the left-hand navigation pane, click on 'Reports' and select 'Data access governance'.
Locate the 'Sharing Links' section on the dashboard and click on 'View Reports'.
Click 'Run all' to generate data for all tracked sites, or select specific reports to run individually.
Review the generated reports, which will display up to 100 sites with the highest volume of sharing links created in the past 30 days.

Export Custom External Sharing Report using PowerShell
For a broader and more granular audit, run a PowerShell script to export comprehensive sharing activity logs to a CSV file.
Manage and Share Files Easily with WPS Office
While SharePoint offers enterprise-level governance, WPS Office provides a free, lightweight, and highly compatible alternative for individuals and teams to create, manage, and securely share documents via built-in cloud services.
- 1. Install WPS Office: Download and install the free WPS Office suite from the official website.
- 2. Save to WPS Cloud: Open or create your document and save it directly to WPS Cloud for automatic syncing.
- 3. Share Securely: Click the 'Share' button in the top right corner to generate a secure link with customized viewing or editing permissions for your collaborators.

Frequently Asked Questions
Can I see sharing links created more than 30 days ago in the SharePoint Admin Center?
The built-in Data Access Governance report in the SharePoint Admin Center specifically displays data for sharing links created within the last 30 days. For older data, you must rely on Microsoft Purview Audit logs or previously scheduled PowerShell exports.
Do I need special permissions to run the PowerShell sharing report?
Yes, running external sharing reports via PowerShell requires you to have SharePoint Administrator or Global Administrator privileges in your Microsoft 365 tenant.
What information is included in the PowerShell external sharing report?
The PowerShell export typically includes the time the file was shared, who shared it, the recipient, the resource type, the specific site URL, the sharing type, and comprehensive audit information.
How do I export the SharePoint Admin Center report to CSV?
Once you generate and view the Data Access Governance report in the SharePoint Admin Center, you can click the 'Export' button located at the top of the report list to download the current view as a CSV file for offline analysis.




