About this tool
Excel merge can append workbook data into one sheet or retain sources as multiple sheets. Single-sheet mode suits records with the same columns, while multi-sheet mode preserves boundaries. Formulas, charts, macros, validation, and complex styling may not copy fully from the originals.
Compare headers, data types, dates, and decimal formats and confirm that the first row is truly a header. Sheet names have length and character limits, and duplicate source names require unique output names.
How to use it
Inspect every workbook
Confirm valid sheets, headers, dates, and critical columns have no hidden differences.
Choose a strategy
Append consistent schemas into one sheet or keep sources separated across sheets.
Preview and validate
Count rows and sheets and sample formula values, non-ASCII text, and dates before download.
Supported range and limits
- Input / output
- Several XLSX / XLS / CSV files in, one XLSX out
- Two modes
- Pool everything into one sheet, or give each source file its own sheet
- Precondition for pooling
- Every source must share the same column structure, or the data misaligns; silently
- Preserved
- Cell values and basic number formats
- May be lost
- Formulas (usually reduced to their computed values), charts, conditional formatting, pivot tables and cell styles
- Legacy format
- .xls can be read, but output is always .xlsx
When you would use it
Compiling branch data
Append monthly sheets based on one template into a unified analysis table.
Packaging related workbooks
Retain multiple sources in separate sheets for distribution as one file.
Consolidating monthly reports from several offices
Pool identically structured reports into one sheet for analysis, or give each its own sheet for separate review.
What to know before you start
- Single-sheet mode requires matching column meaning, not merely similar names.
- Macros, external connections, and advanced workbook features are generally not fully preserved by browser merging.
- Excel dates can be stored as serial values, so inspect display and time-zone interpretation.
Related concepts
- workbook
- An Excel file containing sheets and related styles, formulas, and resources.
- append
- Adding rows with the same column structure to the end of an existing table.