How to Import Excel Files from Private Teams Channels in Power Query
Question details
The user needs to connect Power Query to private Microsoft Teams channels to import and combine Excel data.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Consolidating Excel reports or datasets that are distributed across different private channels within Microsoft Teams.
- Observed behavior
- Private channels utilize separate SharePoint sites, meaning standard connections to the main team site will not retrieve the private files. Users must connect to distinct URLs and authenticate with specific permissions.
Ensure you have the exact SharePoint site URL for your private Teams channel and that your Microsoft 365 account has explicit member or owner permissions to access it.
Connect via the SharePoint Folder Connector
Connect Power Query directly to the unique SharePoint site generated by the private Teams channel to filter and combine your workbooks.
Because private channels in Microsoft Teams use separate SharePoint sites for enhanced security, you cannot access their files from the main team site. You must establish a direct Power Query connection to each private channel's specific SharePoint URL.
Open your private channel in Microsoft Teams, go to the 'Files' tab, click the three dots (...), and select 'Open in SharePoint'. Copy the root URL from your browser's address bar (excluding the specific folder paths).
Open Microsoft Excel, navigate to the 'Data' tab, click 'Get Data', choose 'From File', and then select 'From SharePoint Folder'.
Paste the copied URL into the dialog box and click 'OK'. When prompted, select 'Organizational account' and sign in using credentials that have explicit access to the private Teams channel.
Once the file list loads, click 'Transform Data'. Filter the 'Folder Path' or 'Extension' columns to isolate your target Excel files, then click the 'Combine Files' icon in the Content column header.

Try WPS Office for High-Performance Spreadsheet Tasks
While advanced SharePoint network querying requires Microsoft Excel, WPS Office is an excellent free alternative for handling large datasets, editing complex spreadsheets, and utilizing advanced formulas offline.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Software: Run the installer and follow the quick setup wizard to install WPS Office on your device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets to seamlessly view, edit, and analyze your Excel files with built-in advanced tools.

Frequently Asked Questions
Why can't I find my private Teams channel files in my main SharePoint site?
To maintain strict privacy and security boundaries, Microsoft Teams automatically provisions a completely separate, standalone SharePoint site collection for every private channel. These files are physically isolated and are not stored in the main team's default document library.
Does my global admin account automatically give me Power Query access to private channels?
No. Even if you are a Microsoft 365 global administrator, you must be explicitly added as an owner or a member of the specific private Teams channel to access its associated SharePoint files via Power Query.
Can I use the 'Web' connector instead of 'SharePoint Folder'?
While you can use the 'Web' connector to import a single Excel file by providing its exact direct file path, the 'SharePoint Folder' connector is highly recommended. The folder connector makes it much easier to dynamically combine multiple files or handle scenarios where file names change over time.




