Analistable

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

Merge features in Excel for Mac vs Windows
FeatureMac (Microsoft 365)Windows
Power Query: From FolderYes, in current versionsYes
Power Query: Append and Merge QueriesYesYes
Data Model / Power PivotNoYes
VSTACK and dynamic arraysYesYes
Move or Copy sheetYesYes
VBA folder loopsYes, with Mac-specific file paths and permissionsYes

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

  1. Put the files in one folder in Finder.
  2. In a new workbook, choose Data → Get Data (Power Query).
  3. Choose From Folder, select the folder, and grant Excel access if macOS asks.
  4. Click Combine & Transform (or Combine), pick the sheet to use, and confirm.
  5. 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

Translating Windows instructions to Excel for Mac
Windows guide saysOn a Mac
Right-clickControl-click, or two-finger click on a trackpad
Ctrl key in most shortcutsOften Cmd, but not always; check the menu, which shows the Mac shortcut
File → OptionsThe Excel menu → Preferences
Data → Get DataData → 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

Mac-specific problems when combining files
SymptomCauseFix
No From Folder optionOlder Excel version, or a one-time purchase version without the updateUpdate via Help → Check for Updates; otherwise use Move or Copy or a browser tool
Excel asks for access to the folder every timemacOS sandbox permissionsGrant access when prompted; keep source folders in one location such as Documents
Some files missing from the combineFiles in iCloud Drive not downloaded to the MacIn Finder, Control-click the folder and choose Download Now
Refresh fails after moving the folderThe query stores the old pathEdit the Source step in the Power Query editor with the new path
VSTACK returns #NAME?Excel 2019 or 2021 for Mac without the newer functionsUpdate 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.

  1. Create a folder such as Documents/Transactions 2026 and save the twelve attachments into it (not in iCloud placeholders).
  2. Open a new workbook and run From Folder on that folder, choosing Transactions as the sheet to combine.
  3. In the editor, keep Source.Name and use Transform → Extract → First Characters (7) to turn it into a Month column such as 2026-01.
  4. Close & Load, then insert a pivot table with Month in rows and Amount as Sum.
  5. 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.

Related guides