Home › Excel tools › Combine Excel sheets
Runs in your browserCombine every tab into one sheet
A workbook with a tab per month is easy to read and impossible to analyse. You can't sort, filter or pivot across tabs. This stacks every tab into one table with a single header row, and adds a column recording which tab each row came from.
Your file stays on this computer. There’s no upload button here, because there’s nowhere to send it. This tool runs inside the page you opened — like a calculator on a web page, it keeps working once it has loaded. How this works, and how to check it →
How to use it
- Choose your .xlsx file.
- Leave the tab-name column on if you'll need to tell the rows apart afterwards.
- Click Combine and download the single-sheet workbook.
Questions
Is my file uploaded anywhere?
No. The whole tool is inside this page, so the work happens on your computer. There is no server to send it to. If you'd rather check than take our word for it: use the tool once, on a sample file, with the settings you want. Then turn off your wi-fi and do exactly the same thing again in that tab, without reloading. It still works, because everything it needs is already here.
How is this different from merging Excel files?
This works inside one workbook, flattening its tabs into a single table. Merging works across several separate files. If you have 12 files each with one tab, merge them and choose stacking. If you have one file with 12 tabs, use this.
What if the tabs have different columns?
The first tab's header row is used for all of them. If a tab has a different number of columns you'll get a warning naming it. It doesn't check that the headings themselves match, so if the tabs weren't built from the same template, check the result before you use it.
My tabs have no header row.
Turn off "Every tab has a header row" and every line is treated as data, so the first row of each tab isn't quietly discarded.
How do I combine tabs in Excel without a tool?
Two ways. Copy each tab's rows and paste them under the last row of the first — fine for three tabs, miserable for thirty. Or Data → Get Data → From Workbook, then Append Queries in Power Query, which handles many tabs but takes a dozen clicks and a refresh every time the data changes. This page does the same append in one step and adds a column recording which tab each row came from, which the paste method loses.