Home / Document Tools / Merge / Split Excel
FREE DOCUMENT TOOL

Merge / Split Excel

Merge Excel workbooks into one file, or split every worksheet into a separate XLSX file in a ZIP.

Choose files or drag them hereXLSX workbooks · 20 MB total

    Saved values do not recalculate formulas. Keep formulas supports ordinary cell references; cross-sheet references cannot be kept when splitting.

    XLSX only · Up to 10 files · 20 MB total · 100 sheets / 250,000 stored cells per job. Charts, images, shapes, pivots and external links are not supported. Hidden sheets are included.
    STEP 1

    Choose workbooks

    Add at least two XLSX files to merge, or one workbook to split.

    STEP 2

    Choose formula handling

    Use saved values for independent sheets, or keep supported formulas. Reorder files before merging.

    STEP 3

    Download the result

    Get one merged XLSX file, or a ZIP containing one XLSX file per sheet.

    Frequently asked questions

    Does merging combine rows into one sheet?

    No. Every source worksheet becomes a separate sheet in the merged workbook, in file and sheet order. Duplicate sheet names receive a numeric suffix.

    What happens to formulas?

    Use last saved values replaces formulas with the results stored by Excel. Recalculate and save your source files first. Missing saved results produce an error. Keep formulas rewrites supported sheet references when merging. Named ranges, structured table references, INDIRECT and OFFSET are not supported in this mode.

    Can I split sheets that reference each other?

    Yes, with last saved values. Keep formulas refuses cross-sheet references because the referenced sheet would be missing. Validation rules and conditional formatting that depend on missing sheets also need to be simplified in the original file.

    What formatting is preserved?

    Cell styles, number formats, row heights, column widths, merged cells, basic tables, comments and supported validation/formatting rules are copied. Named ranges and workbook-level settings are not transferred. The first workbook supplies the theme when merging. Advanced objects such as charts, images and pivots are refused rather than silently discarded.

    Can I use XLS files?

    First convert XLS to XLSX with Office Format Converter, then use this tool. Macro-enabled XLSM files are not supported.

    How are uploaded files handled?

    Files are uploaded to the ToolTiny server for processing. Temporary job files are removed after the download response or a processing failure. Processing is limited to five minutes per job.

    More document tools