How do I combine multiple Excel files into one without VBA?

Use Power Query's From Folder feature, or copy-paste for a couple of files. For a simpler path, Tellsheet's Combine Files lets you pick many .xlsx/CSV files at once and stacks them into one table aligned by header, with a source-file column — no VBA, no Power Query, and the files never leave your computer.

Will the columns line up if the files are in a different order?

That's the common trap with copy-paste. Tellsheet's Combine Files aligns columns by header name (case- and space-insensitive), so a Region column lands under Region regardless of column order, and any column only some files have is kept with blanks where it's missing.

Is my data uploaded when combining files?

No. Tellsheet parses each file in the browser and combines locally — nothing is uploaded. The result is written to a new sheet in your workbook.

Home › Excel Guides › Combine Multiple Excel Files into One

How to Combine Multiple Excel Files into One

Twelve regional files, one master table. Excel has no "combine these files" button — Power Query is the official answer and it's more than most people want. Here's the manual way, and a one-click one.

Last updated: August 2026

Files		One table
west.xlsx	→	west · Ann · 10
east.xlsx	→	east · Bob · 20
north.csv	→	north · Cy · 30

Method 1 — Power Query (From Folder)

Put every file in one folder. Data > Get Data > From File > From Folder.
Pick the folder, then Combine & Load.

Powerful and refreshable — but it's a lot of dialog for a one-off stack, and it stumbles when files have slightly different columns or headers.

Method 2 — manual copy-paste

Open each file and paste its rows beneath the last. Fine for two or three files; beyond that it's slow, and a column in a different position silently lands in the wrong place.

The 1-click way — Tellsheet

Combine Files lets you pick all your .xlsx and .csv files at once and stacks them into one table on a new sheet. Columns are aligned by header name (so Region lands under Region even if the files order columns differently), a column only some files have is kept with blanks where it's missing, and a Source File column makes every row traceable. The files are parsed on your computer and never uploaded. Works on Windows, Mac, and Excel on the web. The reverse is Split to Sheets.

Frequently asked questions

How do I combine files without VBA?

Power Query's From Folder, copy-paste for a couple of files, or Tellsheet's Combine Files — pick many files at once, no VBA, nothing uploaded.

Will columns line up if files differ in order?

Yes — Combine Files aligns by header name, so column order doesn't matter and mismatched columns are kept with blanks.

Is my data uploaded?

No — files are parsed locally and combined on your machine; the result goes to a new sheet.

Can I combine CSV and XLSX together?

Yes — pick a mix of .xlsx and .csv files and they're stacked into one table.

Related Excel guides

Combine files in one click

Combine Files merges many Excel/CSV files into one table, aligned by header — nothing uploaded, right inside Excel.

Get Tellsheet free See pricing