How to combine Excel files on a Mac
By the Analistable team · Updated · 5 min read
In Microsoft 365 for Mac, use Data → Get Data (Power Query) → From Folder, choose the folder and combine the files, just as on Windows. If your version doesn't show From Folder, update Excel, or copy sheets into one workbook with Move or Copy. To skip Excel entirely, drop the files into a browser combiner — it works the same on a Mac.
Part of our guide: How to merge Excel files: every method compared
Combine your sheets now
Files stay in your browser. Google access is read-only.
What Excel for Mac supports
| Feature | Mac (Microsoft 365) | Windows |
|---|---|---|
| Power Query: From Folder | Yes, in current versions | Yes |
| Power Query: Append and Merge Queries | Yes | Yes |
| Data Model / Power Pivot | No | Yes |
| VSTACK and dynamic arrays | Yes | Yes |
| Move or Copy sheet | Yes | Yes |
| VBA folder loops | Yes, with Mac-specific file paths and permissions | Yes |
Microsoft added the From Folder connector to Excel for Mac in 2024. If you don't see it, check for updates in Help → Check for Updates.
Method 1: Power Query From Folder
- Put the files in one folder in Finder.
- In a new workbook, choose Data → Get Data (Power Query).
- Choose From Folder, select the folder, and grant Excel access if macOS asks.
- Click Combine & Transform (or Combine), pick the sheet to use, and confirm.
- Click Close & Load. To update later, add files to the folder and choose Data → Refresh All.
The details match Windows. See combining Excel files into one spreadsheet for handling different sheet names.
Method 2: Move or Copy into one workbook
Open all the workbooks. Control-click a sheet tab, choose Move or Copy, pick the destination workbook under To book, tick Create a copy and click OK. You get one workbook with many tabs; stack them into one sheet with =VSTACK(Sheet1:Sheet4!A2:F500).
That 3D reference stacks every sheet positioned between Sheet1 and Sheet4 in the tab order, so drag the tabs into a block first and keep the summary sheet outside it. The fixed range leaves empty rows wherever a sheet has fewer than 499 data rows; remove them with FILTER:
=LET(
all, VSTACK(Sheet1:Sheet4!A2:F500),
FILTER(all, CHOOSECOLS(all, 1) <> "")
)Put the headers in row 1 of the summary sheet by hand (or with =Sheet1!A1:F1) and the formula in A2. To pick up a fifth file, copy its sheet into the block between the first and last tabs; the formula includes it automatically.
Mac keys and menus that differ from Windows guides
| Windows guide says | On a Mac |
|---|---|
| Right-click | Control-click, or two-finger click on a trackpad |
| Ctrl key in most shortcuts | Often Cmd, but not always; check the menu, which shows the Mac shortcut |
| File → Options | The Excel menu → Preferences |
| Data → Get Data | Data → Get Data (Power Query) |
| Alt+F11 (VBA editor) | Tools → Macro → Visual Basic Editor |
| C:\Reports\ paths | /Users/name/Documents/Reports/ paths |
Keyboard shortcuts vary with keyboard layout and macOS settings; if a shortcut does nothing, the menu route always works.
Method 3: Terminal, for CSV files
If the files are CSVs, one Terminal command merges them while keeping only the first header. See combining CSV files on a Mac.
Method 4: in the browser
The Analistable Excel combiner runs in Safari or Chrome on a Mac. Drop .xlsx, .xls or .csv files, and it stacks every sheet, matches columns by header and lets you download the result. The files aren't uploaded.
What about Apple Numbers?
Numbers can open Excel files, but has no feature for merging several files into one table. You can copy tables between documents by hand, or export to CSV and use one of the methods above.
To bring a Numbers file into a Power Query merge, open it in Numbers and choose File → Export To → Excel, then save the .xlsx into the merge folder. Power Query can't read .numbers files directly.
Troubleshooting on a Mac
| Symptom | Cause | Fix |
|---|---|---|
| No From Folder option | Older Excel version, or a one-time purchase version without the update | Update via Help → Check for Updates; otherwise use Move or Copy or a browser tool |
| Excel asks for access to the folder every time | macOS sandbox permissions | Grant access when prompted; keep source folders in one location such as Documents |
| Some files missing from the combine | Files in iCloud Drive not downloaded to the Mac | In Finder, Control-click the folder and choose Download Now |
| Refresh fails after moving the folder | The query stores the old path | Edit the Source step in the Power Query editor with the new path |
| VSTACK returns #NAME? | Excel 2019 or 2021 for Mac without the newer functions | Update to Microsoft 365, or use Power Query |
Example: twelve monthly files from your accountant
Suppose an accountant emails twelve files, 2026-01.xlsx to 2026-12.xlsx, each with one sheet called Transactions and the same columns.
- Create a folder such as
Documents/Transactions 2026and save the twelve attachments into it (not in iCloud placeholders). - Open a new workbook and run From Folder on that folder, choosing Transactions as the sheet to combine.
- In the editor, keep Source.Name and use Transform → Extract → First Characters (7) to turn it into a Month column such as 2026-01.
- Close & Load, then insert a pivot table with Month in rows and Amount as Sum.
- Check the pivot's grand total against the sum of the twelve files' totals.
Next year, point the query at a new folder by editing the Source step. For the same job on Windows the steps are identical; see combining files from a folder.
Frequently asked questions
- Does Excel for Mac have Power Query?
- Yes. Microsoft 365 for Mac includes Power Query with connectors for local files, including From Folder in current versions.
- Can I use VBA to merge files on a Mac?
- Yes, but file paths use the macOS format and sandbox permissions may prompt for folder access. Power Query is usually simpler.
- Can Numbers combine multiple spreadsheets?
- Not automatically. Copy tables by hand or use Excel or a browser tool.
- Why are some files missing when I combine a folder on a Mac?
- If the folder is in iCloud Drive with storage optimisation on, some files may exist only in the cloud. Download them in Finder first, then refresh the query.
- Does VSTACK work in Excel for Mac?
- Yes, in Microsoft 365 for Mac. Older one-time purchase versions may not have it; use Power Query or Move or Copy instead.