To merge two Excel files into one workbook, select the two local .xlsx files and create one combined file in which every source worksheet stays a separate, clearly named tab.
There are several meanings of “merge” in Excel. This guide covers workbook consolidation: the goal is to put worksheets from separate files into one .xlsx without losing their visible provenance. The Merge Excel Files tool performs that specific browser-based workflow. It does not copy records into a shared table or guess how unrelated datasets should be aligned.
Choose the right kind of merge
Decide what the finished workbook must contain before opening either file. A workbook-level merge and a row-level consolidation solve different problems and can produce very different results.
| Your goal | Required result | Best workflow |
|---|---|---|
| Collect separate workbooks | One .xlsx with every source worksheet on its own tab | Merge Excel Files |
| Append records with matching columns | One table containing rows from multiple files | A purpose-built row-combining tool or ETL workflow |
| Join records using matching fields | One table with data combined across related columns | A database or ETL workflow |
| Keep a report’s formulas and visual design | A full-fidelity workbook | Retain the originals; this merge produces data-only tabs |
For tables with matching columns that must be appended row by row, use the separate guide on how to merge Excel files with same columns locally. The workflow described here is better suited to collecting independent worksheets in one browsable workbook.
Merge two Excel files in your browser
- Open Merge Excel Files and select the source workbooks. Choose between 2 and 10 non-empty local .xlsx files. Their combined physical size must be no more than 20 MB. Only .xlsx workbooks are accepted; legacy .xls files and macro-enabled workbooks are not valid inputs for this tool.
- Put the workbooks in the order you want them considered. The selection order controls the order of the resulting tabs. The worksheets inside each workbook retain their original order.
- Confirm that every source worksheet should remain a separate data-only tab. The result will not turn all worksheets into one table. There is no option to select only certain source sheets or remove a duplicate tab afterward.
- Select Merge workbooks. Before reading workbook content, the browser validates each selected file as a classic, single-disk OOXML ZIP package. The stored worksheet values are then read locally in your browser.
- Download the new .xlsx file. The browser creates a separate workbook for download. It does not upload your files to Lizely, store them in an account, send them to an API, or create a cloud share link. Your source workbooks are not modified.
- Open the download in your destination spreadsheet application. Inspect the prefixed worksheet names and confirm that the tab order and representative stored values match your expectations before sharing or processing the combined file.
The source files can remain in their current folders throughout the process. Because the output is a new download, keeping the originals is also the safest way to retain formulas, formatting, charts, and other features that the combined workbook does not preserve.
Know how the combined workbook is organized
Each source worksheet becomes a separate tab in the result. The output name for each tab is derived automatically from its source workbook and worksheet names, with a separator between the two. For example, a Data worksheet in Team.xlsx and a Data worksheet in Quarter.xlsx remain distinct instead of overwriting one another.
If two generated names would otherwise collide, the browser adds a numeric suffix to make them unique. Unsafe characters are removed from names, and each name is kept within Excel’s worksheet-name limit. These safeguards make duplicate names traceable, but they do not let you omit a source worksheet after the merge.
Worksheet order follows the selected workbook order and then the original worksheet order inside each workbook. Keep that sequence in mind when choosing files, especially when several workbooks contain similarly named sheets.
| Stage | Supported boundary |
|---|---|
| Input workbooks | 2–10 non-empty local .xlsx files |
| Combined input size | No more than 20 MB |
| Per-file package check | Classic single-disk OOXML ZIP with at most 2,000 entries and no more than 50 MB of declared expanded data |
| Result worksheet count | Up to 50 worksheets |
| Cell coverage | Each source sheet is bounded by the Excel addressed-cell limit |
| Generated file size | No more than 20 MB |
The 20 MB input limit and the per-file package checks are separate requirements, so both must be satisfied. The browser validates the package structure before reading workbook content, which helps it reject unsupported or malformed files without producing a partial merge.
Understand what a data-only download contains
The merged workbook is built from stored worksheet values rather than copied as a complete Excel package. This makes it suitable for an organized local handoff, but it is not a full-fidelity clone of the source files.
- Formulas are not calculated, and the formula itself is not carried into the download as a calculation contract. A formula’s cached stored value may appear as ordinary data when one is available.
- Macros are not run, hyperlinks are not opened, external connections are not refreshed, scripts are not executed, and embedded content is not inspected.
- The output does not promise to retain charts, images, comments, cell formatting, column widths, conditional rules, merged-cell layouts, named ranges, filters, data validation, hidden-sheet state, print settings, protection, workbook metadata, or other presentation features.
If a formula’s current displayed value is important, inspect that tab in the downloaded file before using it. If formulas must remain live, or if the visual design carries meaning, keep the original workbook as the authoritative version.
Review errors and hard boundaries
Unsupported workbooks and over-limit packages stop with an error instead of producing a partially merged download. This includes Zip64 packages, encrypted workbooks, multi-disk packages, malformed files, legacy .xls files, macro-enabled workbooks, oversized inputs, and packages that exceed the stated entry or expanded-data limits.
The tool also does not repair damaged workbooks, convert older Excel formats, remove duplicate tabs, select a subset of sheets, or validate the result as a business import. The final download still needs a quick review by the person handling the data.
For a dependable handoff, begin with a small representative set of workbooks. Download the result and open it once in the spreadsheet program where it will be used. If the source set is accepted and the downloaded values look correct, repeat the same process with the remaining workbooks within the supported boundaries.
Verify the result before sharing it
A successful download does not mean every record has been combined into a single table. Verification should confirm the workbook structure and the values that matter to your handoff.
- Check the tab count: Count the output tabs against the source worksheets you expected to include.
- Check the names: Look for the source workbook and worksheet prefixes, plus any numeric suffix added to resolve a collision.
- Check the order: Confirm that the tabs follow your selected workbook order and each workbook’s original sheet order.
- Check representative values: Inspect cells containing ordinary data and any formula-derived value that must be transferred as stored data.
- Check downstream needs: Confirm that a data-only workbook is sufficient for the person or process receiving it.
Keep the source files until these checks are complete. They remain unchanged and provide the only full-fidelity versions if you later need formulas, formatting, images, comments, macros, or workbook features that the merged download omits.
Choose another workflow when records must be joined
Use a database, ETL workflow, or purpose-built row-combining tool when columns must be matched, records must be joined, duplicates must be reconciled, or a business schema must be inferred. This utility deliberately does not perform those operations because unrelated worksheets can have different headers, row structures, and meanings.
For the narrower goal of collecting two or more .xlsx workbooks into one local, traceable file, the browser workflow fits: keep each worksheet separate, retain the source provenance in its tab name, and download one data-only workbook without uploading the originals.