Combine Excel Sheets

Many workbooks grow one tab at a time: January, February, March; one sheet per salesperson; one per class or project. That structure is easy to fill in but hard to analyse, because sorting, filtering and pivot tables work on one table. This tool stacks the sheets into a single master sheet, with a column telling you where each row came from.

Opening workbooks

Drop one workbook with many sheets, or several workbooks at once, for example one file per store. Every sheet appears as a chip. Click a chip to leave that sheet out, such as a summary or instructions tab that is not data. Sheets without any content are skipped automatically.

Header rows

Most sheets start with a header row such as Date, Item, Amount. Keep “Sheets have a header row” on, and the header appears once at the top of the master sheet rather than repeated before every block of rows. If your sheets are pure data without headers, switch it off.

Matching columns

“By header name” lines up columns by name and ignores upper/lower case and extra spaces, so “Sales”, “sales ” and “SALES” land in the same column even if colleagues typed them differently. Columns that exist only on some sheets are added at the end and left empty for the others. “By position” stacks column 1 under column 1, which suits sheets that share a layout but not header wording.

Where each row came from

“Add a column with the sheet name” puts the tab name in the first column, for example January. When several workbooks are combined, the column shows workbook and sheet, such as “Store 12 / March”. That column is what makes the master sheet useful: filter it, pivot by it, or chart one month against another.

Formulas and values

Cells with formulas contribute the value they last showed in Excel. Formulas would not make sense once rows from different sheets are stacked, and their results are what you want to analyse. Dates that include a time keep it, and leading zeros in codes are preserved.

Saving

The master sheet downloads as an Excel workbook by default, with a bold, frozen header row and filters, ready for a pivot table. CSV and TSV are available for databases and other tools.

Before you analyse

Look at the row count per sheet and at the empty cells in the preview. A sheet that adds an unexpected column usually has a renamed header or a stray note in a cell; fix it in the source workbook and combine again.

Typical workbooks

A household budget with one tab per month, a sales tracker with one tab per representative, a teacher’s grade book with one tab per class, a stock list per warehouse, or survey results exported as one sheet per question. In each case the combined table answers questions the separate tabs cannot, such as totals across the year or a ranking across all classes.

Large workbooks

Workbooks with dozens of sheets and tens of thousands of rows combine in seconds on a computer. Everything happens in your browser, so even confidential files stay on your device.

Related tools

To do the reverse, Split Excel Sheets saves each tab as its own file. For CSV exports instead of tabs, Merge CSV Files works the same way. Summarize the master sheet with the CSV Pivot Table.