Merge & Split Spreadsheets
Reshape spreadsheet collections by preserving tabs, combining tabular rows or dividing one source into practical output files.
Add spreadsheets to merge
XLSX, XLS, XLSM, XLSB, ODS, CSV, or TSV · up to 10 files
All spreadsheet parsing and generation runs locally. Macros and external workbook links are never executed or fetched.
How to use Merge & Split Spreadsheets
- 1
Select Merge Spreadsheets to add as many as ten files, or Split Spreadsheet to open one XLSX, XLS, XLSM, XLSB, ODS, CSV or TSV source.
- 2
For a merge, choose Separate worksheets or One combined worksheet, select the tabs and arrange their file and worksheet order.
- 3
For a split, choose By worksheet, By rows or By column value and select the source tab plus its row, header or grouping controls.
- 4
Set output worksheet names where applicable, choose XLSX, XLS, XLSB or ODS and review the summary and contextual warnings.
- 5
Press Merge or Split, then download the single workbook or save multiple generated files individually or in a ZIP.
Frequently asked questions
About Merge & Split Spreadsheets
This tool separates structural workbook organization from tabular data organization. A structural merge keeps chosen worksheets as independent tabs, useful for consolidating monthly or departmental books. A data merge flattens selected tables into one sheet, with column matching based on physical position or header names.
Splitting offers the reverse set of decisions. Selected tabs can become independent workbooks, long tables can be divided after a fixed number of data rows, and one field can define separate files for categories, regions or customers. Worksheet naming rules, duplicate checks, safe filenames and a 100-output ceiling make the generated set predictable.
Structural paths preserve common workbook features where the local writer and output format allow. Data-oriented paths favor dependable saved values because relocated formulas may no longer reference the intended cells. Contextual warnings identify formulas, merges, macros or formatting that may not survive the chosen transformation.