Power Query Problems

Fix Get Data From Folder Missing in Excel for Mac

Maira Mehtab Sep 22, 2026 868 views

Question details

The user is attempting to import or combine data from an entire folder using Power Query, but the 'From Folder' connector is unavailable.

Product: Microsoft Excel for Mac
Device & OS: Mac
Scenario: Using Power Query to import and combine multiple files stored in a specific folder on a macOS device.
Observed behavior: The 'From Folder' data source option is completely missing in the Power Query menu on Excel for Mac version 16.93.1.

Before you start

Ensure you have updated to the latest version of Excel for Mac, though note that certain Power Query connectors are inherently restricted on macOS compared to Windows.

Solution 1Recommended

Import Files Individually and Append Queries

Since the 'From Folder' connector is unsupported on Mac, you must import files one by one and append them manually.

Currently, Microsoft Excel for Mac does not support the 'From Folder' connector in Power Query. To combine multiple files, you must use a manual workaround by connecting to each file individually and then appending their queries together in the Power Query Editor.

Get data from a single file

Open Excel for Mac, navigate to the Data tab on the ribbon, select 'Get Data (Power Query)', and choose 'Excel workbook' or 'Text/CSV' to import your first file.

Import additional files

Repeat the previous step for each individual file you need to combine from your target folder.

Append queries manually

Open the Power Query Editor, select your primary query, and click on 'Append Queries' in the Home tab to combine the data from the additional imported files.

Submit a Feature Request: You can request Microsoft to add the 'From Folder' feature to Mac by navigating to Help > Feedback in the Excel menu.

Free Microsoft Office alternative

Try WPS Office for a Seamless Spreadsheet Experience

Tired of missing features across different platforms? WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office. Enjoy full compatibility with Excel formats and a user-friendly interface that works seamlessly on both Windows and Mac without heavy subscription fees.

1. Download and Install: Download WPS Office for Mac from the official website and install the application.
2. Open Existing Files: Launch WPS Spreadsheet and click 'Open' to seamlessly load your existing Excel workbooks and CSV files.
3. Consolidate Data Easily: Use built-in data tools like Data Consolidation to combine data across multiple sheets or files without complex query setups.

Fully compatible with Microsoft Excel (.xlsx, .csv) formats.Lightweight application that runs smoothly and quickly on Mac devices.Free to use with a familiar, easy-to-navigate tabbed interface.Built-in robust data consolidation and analysis tools for managing multiple sheets.

microsoft office alternative - wps office

Frequently Asked Questions

Will Microsoft add 'From Folder' to Excel for Mac?

Microsoft has not announced a specific release date for the 'From Folder' connector on Mac. Users are encouraged to submit feedback via Help > Feedback to increase its development priority.

Can I use Power Query on Mac at all?

Yes, Power Query is available in Excel for Mac, but it has a limited set of data connectors compared to the Windows version. You can connect to local Excel files, Text/CSV, and select databases.

Is there a fast way to combine multiple CSVs on Mac without Power Query?

You can use Mac Terminal commands (such as 'cat *.csv > combined.csv' in your target directory) to merge multiple CSV files into one single file before importing it into Excel.

Why does my Microsoft 365 Family subscription not include this feature?

The limitation is based on the macOS operating system environment and the current software build of Excel for Mac, not your specific Microsoft 365 subscription tier.

Excel & Data Problems