Split spreadsheets by values or rows
Split by column values or a fixed row count, then download a multi-sheet Excel file or ZIP.
Instructions and limits
- Import and preview a table. Group by 1–3 original column values or split every N rows, then check record counts.
- Choose naming and export options, generate a multi-sheet XLSX, CSV ZIP or XLSX ZIP, or continue processing a selected group.
Up to 20,000 records, 200 columns, 200,000 cells and 100 parts. Exports total 50 MB, each XLSX 10 MB. Retains headers and empty groups, grouping exact original values. Invalid or conflicting names are repaired and shown in the list. Excel formatting and formula recalculation are not preserved.
Use cases and example
Distribute a master table by department, customer or city, or split it into batches that fit another system’s import limit. Reconcile each group against the total.
Group a staff list by department, use a {group}-{index} naming template and generate one worksheet per department or a ZIP of separate files. Empty departments remain a separate group.
Composite groups use exact original values without trimming spaces. File and worksheet names are sanitized and deduplicated without changing cell data. IDs export as text. Processes data tables without copying formulas or formatting.