# XLSX Workbook Merger Merge multiple similarly structured workbooks as multiple sheets or append all rows into one sheet > Canonical page: https://elysiatools.com/en/tools/xlsx-workbook-merger - **Category:** Format Conversion - **Keywords:** xlsx, merge, workbook, sheet, append, etl ## Overview Merge many Excel files into one workbook. - **sheets** mode: each source file becomes a sheet - **append-rows** mode: union rows into one target sheet - Optional source-file column for traceability ## Inputs - **Source Excel Files** (file) - **Merge Mode** (select) - **Source Sheet Name** (text): Sheet1 - **Target Sheet Name** (text) - **Header Row** (number) - **Include Source File Column** (checkbox) - **Source Column Name** (text) ## When to use - When you need to combine monthly reports from different departments into a single master file. - When you want to aggregate data from multiple individual Excel files into one continuous table for analysis. - When you need to keep track of data origins by automatically adding a source filename column to your merged records. ## How it works - Upload your source Excel files and select your preferred merge mode: 'As Separate Sheets' or 'Append Rows'. - Specify the source sheet name and the target sheet name to ensure data is pulled from and placed into the correct locations. - Configure optional settings like the header row index and enable the source file column to maintain traceability. - Process the files to generate a single, unified XLSX workbook ready for download. ## Use cases - Consolidating regional sales spreadsheets into a single national performance report. - Merging individual survey response files into one master dataset for statistical analysis. - Archiving multiple project tracking sheets into one organized workbook for long-term storage. ## Frequently asked questions ### Can I merge files with different structures? The tool works best with similarly structured workbooks. When using 'Append Rows' mode, ensure your columns align across files for the best results. ### What is the difference between the two merge modes? 'As Separate Sheets' creates a new tab for each file, while 'Append Rows' stacks all data into one single sheet. ### How do I keep track of which file the data came from? Enable the 'Include Source File Column' option, and the tool will add a column containing the original filename to every row. ### Is there a limit to the number of files I can merge? You can upload up to 50 files at once, provided the total size does not exceed 200MB. ### Can I specify which row contains my headers? Yes, use the 'Header Row' input to define the row number where your column titles are located. ## Related tools - [XLSX Chart Embedder](https://elysiatools.com/en/tools/xlsx-chart-embedder): Embed generated chart images into Excel workbooks using workbook data ranges for bar or pie chart reports - [XLSX Markdown Table Exporter](https://elysiatools.com/en/tools/xlsx-markdown-table-exporter): Convert a selected Excel range or whole sheet into Markdown table format - [XLSX Multi Sheet Splitter](https://elysiatools.com/en/tools/xlsx-multi-sheet-splitter): Split a multi-sheet workbook into independent files by sheet name, with ZIP output - [XLSX Print Setup Pack](https://elysiatools.com/en/tools/xlsx-print-setup-pack): Apply paper, margins, scaling, repeating titles, and header/footer print settings to Excel workbooks in one pass - [XLSX Range Extractor](https://elysiatools.com/en/tools/xlsx-range-extractor): Extract a specific sheet/range/named-range from Excel into JSON with coordinates or record objects - [XLSX Dedicated Index Sheet](https://elysiatools.com/en/tools/xlsx-dedicated-index-sheet): Generate an index sheet for workbook with links to each sheet and core statistics - [XLSX Parquet Exporter](https://elysiatools.com/en/tools/xlsx-parquet-exporter): Export worksheet data to Parquet and/or NDJSON for data lake and data warehouse pipelines - [XLSX Sheet Theme Pack](https://elysiatools.com/en/tools/xlsx-sheet-theme-pack): Apply consistent colors, fonts, borders, and header styling to Excel sheets and export branded multi-theme reports ## Samples - [XLSX Samples](https://elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing - [XLS Samples](https://elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests - [Nginx Log Parser Samples](https://elysiatools.com/en/samples/nginx-log-samples): Comprehensive Nginx log samples for testing log-parser tool, including access logs and error logs with various formats and scenarios - [Android Serialization Java Samples](https://elysiatools.com/en/samples/android-serialization-java): Android Java serialization examples including JSON serialization, deserialization, and XML parsing ## Related content - [XLSX ETL Ingestion and Warehouse Handoff](https://elysiatools.com/en/hubs/xlsx-etl-ingestion-workflows): Turn mixed workbook and CSV sources into traceable, schema-aware outputs for SQL loading, Parquet pipelines, and object-storage batch handoff.