How to use this office tool
- Choose a spreadsheet and select the worksheet to separate.
- Set the header row and number of repeating groups.
- Deinterleave the rows and download the new multi-sheet workbook.
#235 · Rows Columns & Cells Tool
Deinterleave Excel Rows
Separate alternating or repeating row groups into individual worksheets, keeping the selected header row at the top of every output sheet.
Office File Tool
One spreadsheetrow
groups
rows
Ad space
What this tool does
The tool distributes data rows by their position in a repeating sequence. A group count of two separates odd and even records; larger counts handle repeated multi-row exports.
Data row index modulo group count → separate output sheets
Merged cells and advanced formatting may not survive SheetJS Community Edition exports.
Supported formats
Files are processed locally. XLSX and XLS workbooks are read with SheetJS; CSV and TSV files are parsed with delimiter-aware handling. Advanced Excel features may not be preserved in generated files.
| Format | Support |
|---|---|
| XLSX / XLS | Read workbook values and formulas |
| CSV / TSV | Read delimited rows |
| Output | New downloadable file or report |
Tips for better results
- Work from a backup when the source workbook is important.
- Keep identifiers such as ZIP codes and account codes stored as text.
- Review the bounded preview and downloaded result before replacing any business workflow.
FAQ
How do I separate odd and even spreadsheet rows?
Choose a group count of 2. The first data row goes to Group 1, the next to Group 2, and the sequence repeats.
Is the header copied to every output sheet?
Yes. The selected header row is repeated at the top of each generated group sheet.
Can I split a three-row repeating export?
Yes. Set the group count to 3 to distribute each position in the sequence to its own worksheet.
Are completely empty rows included?
They are included only when Keep empty rows is enabled.
Does deinterleaving preserve complex Excel formatting?
Basic values and formulas are exported, but advanced workbook features may not be fully preserved.
Related office tools
Processing details
| Stage | Action |
|---|---|
| Input | One spreadsheet |
| Privacy | Local browser processing |
| Result | New downloadable output |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all