How to Export Data from Private Microsoft Teams Channels
Question details
Administrators need to understand how to locate, manage storage, and export data from private Microsoft Teams channels.

- Product
- Microsoft Teams and SharePoint
- Device & OS
- not provided
- Scenario
- An IT administrator is trying to export active or archived site data for a Microsoft Team but notices that content from private channels is missing from the parent site export.
- Observed behavior
- Private Teams channels use entirely separate SharePoint site collections, meaning their storage and files do not appear in the parent team site and cannot be exported using standard parent-site methods.
Ensure you have SharePoint Administrator or Global Administrator privileges in your Microsoft 365 tenant and have the SharePoint Online Management Shell installed to run the necessary PowerShell scripts.
Use PowerShell to Identify and Export Private Channel Site Collections
Because private channels generate isolated SharePoint site collections, you must use PowerShell to locate these specific sites, retrieve their storage metrics, and run export commands.
Private Teams channels do not share the parent team's SharePoint site to ensure strict access control. Consequently, standard export methods for the main team will not capture private channel data. Furthermore, allocating additional storage to a private channel does not increase or utilize the parent site's storage limit.
Launch the SharePoint Online Management Shell as an administrator on your computer.
Run the command Connect-SPOService -Url https://[yourdomain]-admin.sharepoint.com and sign in with your global or SharePoint administrator credentials.
Use PowerShell cmdlets such as Get-SPOSite -Template "TEAMCHANNEL#0" to list all SharePoint site collections that are exclusively associated with private Microsoft Teams channels.
For detailed, customized PowerShell scripts to export the actual document libraries within these isolated sites, visit the SharePoint Development section of Microsoft Q&A, as custom scripting is required to loop through private channel memberships safely.

Analyze Your Exported Teams Data with WPS Office
After successfully using PowerShell to export Microsoft Teams and SharePoint administrative data into CSV or Excel formats, you will need a reliable tool to analyze those reports. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office for viewing and managing your IT reports.
- 1. Download and Install WPS Office: Go to the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open WPS Spreadsheet: Launch WPS Office from your desktop and select the Spreadsheet module from the home screen.
- 3. Import Your Exported Data: Click "File" then "Open", and select the CSV or Excel file you exported from your SharePoint PowerShell script to begin analyzing your channel data.

Frequently Asked Questions
Why can't I see private channel files in my main Teams SharePoint site?
To ensure strict security and access control, Microsoft Teams creates a separate, dedicated SharePoint site collection for every private channel. These files are intentionally kept out of the parent team's default document library.
Does increasing a private channel's storage affect the main team site?
No. Because private channels exist on separate site collections, allocating additional storage to a private channel does not increase or consume the storage quota of the parent Teams site.
Where can I find the exact PowerShell scripts for exporting SharePoint data?
Exporting specific document libraries requires custom scripts tailored to your tenant's configuration and security policies. Microsoft recommends asking in the SharePoint Development section of Microsoft Q&A to get secure, custom PowerShell solutions from experts.




