How to use this office tool
- Choose a spreadsheet and select the worksheet.
- Set the header row, repeat count, and output format.
- Expand the rows, check the preview, and download the new file.
#247 · Rows Columns & Cells Tool
Repeat Rows N Times
Duplicate every data row a chosen number of times while keeping the selected header row once, then export the expanded table.
Office File Tool
One spreadsheetrow
times
rows
Ad space
What this tool does
This utility repeats rows in their original order and creates a new XLSX, CSV, TSV, or JSON file without changing the source.
Each data row × repeat count → expanded output table
Large repeat counts can create very large downloads, so the browser limits the result to 500,000 cells.
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
Is the header row repeated too?
No. The chosen header row appears once, while each following data row is repeated the selected number of times.
What is the maximum repeat count?
The page allows up to 100 repeats and also stops outputs that would exceed 500,000 cells.
Are empty rows repeated?
Only when Keep empty rows is enabled.
Can formulas be preserved?
Formula text is preserved where available when Preserve formulas is enabled, but Excel recalculation is not reproduced.
Which output formats are available?
You can download the expanded table as XLSX, CSV, TSV, or JSON.
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