Merge / Split ExcelFree Online

Merge Excel Workbooks Without Combining Rows

Use Merge / Split Excel when several XLSX workbooks belong in the same document but their worksheets should stay separate. For example, you can collect a sales workbook, an inventory workbook and a monthly summary into one file, with a separate tab for every source sheet.

This is a worksheet-level merge. It does not append rows, match column headers, remove duplicates or consolidate totals into a single table. If you need one continuous dataset, prepare that table in your spreadsheet application first.

How to merge multiple XLSX files

1. Select Merge workbooks and add at least two XLSX files. You can upload up to 10 files with a combined size of 20 MB.
2. Use the up and down arrows next to the filenames to set the workbook order. Sheets retain their order within each workbook.
3. Choose Use last saved values or Keep formulas, then select Merge workbooks.
4. Download the merged XLSX and check the sheet tabs, calculations and formatting before sharing it.

When two source sheets have the same name, the result receives a numbered suffix such as Summary (2). Supported explicit sheet references are adjusted in Keep formulas mode so they point to the renamed sheet from the same source workbook.

Split an Excel Workbook into Separate Files

Choose Split sheets when you want to distribute individual worksheets, archive each tab separately or work with smaller files. The tool creates a ZIP containing one XLSX file per sheet. Filenames include a sequence number and the sheet name to keep the results easy to identify.

1. Select Split sheets and upload one XLSX workbook.
2. Choose saved values for sheets that need to stand alone. If you keep formulas, they must not depend on another sheet that will be absent from the output.
3. Select Split sheets to ZIP, download the archive and extract it on your device.
4. Open the required XLSX files and review their contents before sending them to someone else.

Hidden sheets are included. Each exported file contains one visible worksheet, even when its source sheet was hidden. Review the ZIP before distributing it, and remove sheets you do not intend to share from a copy of the source workbook first.

Choose the Right Formula Option

Recalculate and save before using saved values

The tool does not calculate formulas itself. If the source contains old saved results, those results may be outdated. Open the workbook in Excel, recalculate and save it before uploading. If a formula has no saved result, the tool reports an error instead of inventing a value.

Formula and formatting limits

Keep formulas does not support named ranges, structured table references, INDIRECT, OFFSET or external workbook references. Cross-sheet formulas cannot be retained when splitting into independent files. Validation and conditional formatting rules that refer to unavailable sheets also need to be simplified in the source.

Cell styles, basic tables, merged cells, number formats, column widths and row heights are supported. Charts, pictures, shapes, pivot tables and other advanced objects are not supported; affected files are refused. Workbook-level settings and named ranges are not transferred. When merging different themes, the first workbook provides the output theme.

Each job is limited to 100 worksheets and 250,000 stored cells. If your source is an older XLS file, use Office Format Converter to create an XLSX file first. For a fixed-layout copy after editing, use Office to PDF.