Skip to content
Lizely

Merge Excel Files

Combine the stored values from 2 to 10 local .xlsx workbooks into one bounded data-only Excel download without uploading any file.

Privacy: your files never leave your device. All processing happens locally in your browser.

How to use

  1. 1.Choose 2 to 10 local .xlsx workbooks whose total size is no more than 20 MB.
  2. 2.Confirm that each source worksheet should remain a separate data-only tab in the combined workbook.
  3. 3.Merge, download the new .xlsx file, and inspect the prefixed worksheet names in your destination spreadsheet app.

About Merge Excel Files

Merge Excel Files combines the stored worksheet values from two to ten local .xlsx workbooks into one new Excel download. Choose the workbooks in the order you want them considered, then select Merge workbooks. Each source worksheet becomes its own worksheet in the result, so the merged file remains easy to browse instead of guessing how unrelated tables should be stacked together. The browser derives every output tab name from the source workbook and worksheet name, adds a separator, and makes duplicates unique. Nothing is uploaded to Lizely, stored in an account, sent to an API, or used to create a cloud share link. The source files remain on your device and are never modified.

This tool uses a narrow meaning of merge. It collects independent worksheets into a single workbook; it does not append rows, align headers, deduplicate records, reconcile formulas, join tables, or infer a business schema. For example, a Data sheet in `Team.xlsx` and another Data sheet in `Quarter.xlsx` become distinct, clearly labeled tabs rather than silently overwriting one another. Worksheet order follows the selected workbook order and then the original order inside each workbook. Unsafe Excel sheet-name characters are removed, names are kept within Excel's sheet-name limit, and a numeric suffix is added when the resulting names would otherwise collide. The output is intended for an organized local handoff, not as a claim that several workbooks share one compatible table design.

The merged workbook is deliberately data-only. The page reads stored cell values and writes new worksheets from those values; it does not calculate formulas, run macros, open hyperlinks, refresh external connections, execute scripts, or inspect embedded content. It does not promise to retain formulas, charts, images, comments, formatting, widths, conditional rules, merged-cell layout, named ranges, filters, data validation, hidden-sheet state, print settings, protection, workbook metadata, or other presentation features. Keep the original workbooks whenever those features carry meaning. A formula's cached stored value may be included as ordinary data, but the formula itself is not a calculation contract in the downloaded workbook.

Limits make the operation predictable on a normal browser. Choose two to ten non-empty .xlsx files with a combined size no larger than 20 MB. Before workbook content is read, each file must pass the classic single-disk OOXML ZIP checks: at most 2,000 entries and no more than 50 MB of declared expanded data. The combined result may contain up to 50 worksheets; each source sheet is bounded by the addressed-cell limit, and the generated .xlsx file is limited to 20 MB. Zip64, encrypted, multi-disk, malformed, legacy .xls, macro-enabled, oversized, or over-limit packages stop with an error instead of producing a partial merge.

For dependable use, start with a small representative set, download the merged file, and open it once in the destination spreadsheet program. Check the prefixed tab names and stored values before sharing it. Use a database, ETL workflow, or a purpose-built row-combining tool when columns must be matched or records must be joined. This utility does not repair damaged workbooks, preserve a visual report, convert old Excel formats, select a subset of sheets, remove duplicate tabs, or validate a business import. It provides one explicit, bounded local path from separate Excel workbooks to a single data-only workbook with traceable worksheet names.

Methodology & sources

Validate each bounded classic .xlsx ZIP, read stored worksheet values locally, assign unique provenance-based Excel sheet names in selection order, and write one bounded data-only workbook after explicit visitor action.

Frequently asked questions

Does this upload or modify my Excel files?
No. The browser reads the local files and creates a separate download without uploading or changing the originals.
Will it combine matching columns into one table?
No. Each source worksheet stays a separate tab. The tool does not guess how rows or headers should be joined.
Are formulas and formatting preserved?
No. The output is a data-only workbook based on stored cell values, not a full-fidelity workbook clone.

Related tools

Developer Tools guides

View all