How to Load Excel Files from Subfolders with Power Query on Mac
Question details
The user needs to combine Excel files located in a parent folder and nested subfolders with Power Query on Excel for Mac, but the query does not preserve the full subfolder file path.

- Product
- Microsoft Excel for Mac - Power Query
- Device & OS
- macOS
- Scenario
- Combining multiple Excel files from a main folder and its subfolders into one query.
- Observed behavior
- Power Query loads files from the main folder but mishandles files in subfolders by returning the parent folder path, causing the combined data load to fail.
Before editing the query, make sure all source Excel files use the same worksheet structure and that the folder tree has a consistent naming pattern. In Excel for Mac, open the Power Query Editor and note whether the Folder Path column contains the full path or only the parent folder path.
Preserve the Full File Path and Correct Source Column in Power Query
Use this first to verify that the query uses the full path and file name before combining files.
On Excel for Mac, Power Query folder-combination features can be more limited than on Windows, so an incorrect source column often causes the parent folder path to be returned instead of the full file path.
In Excel for Mac, go to Data > Get Data (Power Query) and open the query that connects to the parent folder.
In the Power Query Editor, locate the source column that contains folder/file path values and confirm it shows the full file path including subfolders, not just the parent folder.
Select the column that contains the full file path and file name, then use Combine Files so the transformation reads the correct source column.

Move All Excel Files into a Single Folder Before Combining
Use this workaround when the folder/subfolder query remains unreliable on Mac and you need a quick reliable refresh.
Use a Synchronized OneDrive Folder or Run the Query on Windows
Use this if you must keep subfolders and need full Power Query folder-combination behavior.
Use WPS Office as a Free Alternative for Excel File Management on Mac
When Power Query folder limitations on Excel for Mac block your workflow, WPS Office gives you a free, lightweight alternative with familiar spreadsheets, strong Excel format compatibility, and a straightforward file management experience.
- 1. Download WPS Office: Go to the official WPS website and download WPS Office for Mac.
- 2. Open your existing Excel files: Launch WPS Office, click Spreadsheets, and open the .xlsx files you were trying to combine.
- 3. Continue working with familiar tools: Use the ribbon-style tools to view, edit, and manage workbook data without the Power Query folder obstacle.

Frequently Asked Questions
Why does Power Query on Excel for Mac return the parent folder path for subfolder files?
On Mac, Power Query folder-combination features are more limited than on Windows. The query may expose only the parent folder path if the source column is not set to the full folder path, so check the column used by the Combine Files transformation before combining.
Can I combine files from subfolders with Power Query on Excel for Mac like in Windows?
Full folder-and-subfolder importing is not as complete on Excel for Mac. You can try preserving the full file path in the query, but the most reliable workarounds are to move files to one folder or run the query in Excel for Windows.
What is the fastest workaround when subfolder loading fails?
Move all source Excel files into one flat folder and point Power Query to that folder. If you need to keep subfolders, use a synchronized OneDrive folder or run the folder/subfolder query on a Windows computer.
Does WPS Office include Power Query for folder-based Excel imports?
WPS Office does not replicate Power Query's folder combine feature, but it opens and edits Excel workbooks directly, so you can manage spreadsheet data without the same query limitation.




