Does the header row ever move?

No, row 0 is always treated as the header and stays fixed in place; only the data rows after it participate in the rotation.

What does "cyclic" mean for rows?

Data rows that shift past one end of the data section wrap around to the other end, so every row is still present after the shift, just reordered.

What's the difference between shifting up and down?

Shifting up moves each data row toward the header (lower indices), with rows from the top wrapping around to the bottom; shifting down does the mirror image.

What happens if the shift amount is larger than the number of data rows?

It wraps around correctly via modular arithmetic, so a large shift behaves the same as its remainder after dividing by the data row count.

How is this different from CSV Row Sorter?

Row Sorter reorders rows based on a column's values (ascending or descending); this tool cyclically shifts the existing row order by a fixed offset, without looking at any column's content.

How is this different from CSV Column Rotator?

Column Rotator shifts the column order (a horizontal shift); this tool shifts the data row order instead (a vertical shift), keeping every column in place.

CSV Row Rotator - Cyclically Shift Row Order

Overview

Introduction

Occasionally the data rows in a CSV need to be cycled, moving the last few records to the top, for example, without touching the header or any column's content.

This tool does exactly that: a cyclic shift of data rows, wrapping around instead of losing anything, with the header row always staying put.

What Is CSV Row Rotator?

A structural CSV tool that cyclically rotates only the data rows (everything after row 0) up or down by a chosen number of positions.

The header row is explicitly excluded from the rotation and always remains at row 0, unlike a full transpose or a plain array rotation that would treat it like any other row.

How CSV Row Rotator Works

The input is parsed and padded to a uniform grid, then split into the header row and the remaining data rows.

A signed shift amount (positive for up, negative for down) is applied to the data rows only, using modular (wraparound) index arithmetic, and the header is reattached to the front before re-serializing the result.

When To Use CSV Row Rotator

Use it when data rows need to be cycled as a group, moving recent entries to the top of a log-style export, for instance, without resorting by any specific column.

It's also useful for quickly exploring different row starting points in cyclic or periodic data.

Often used alongside CSV Column Rotator, CSV Row Sorter and CSV Transposer.

Features

Advantages

Keeps the header row fixed automatically, no separate step needed to protect it from the rotation.
Wraps cyclically, so no data row is ever dropped, only reordered.
Doesn't require identifying or sorting by any particular column, it just shifts existing row order.

Limitations

This is a positional shift, not a content-aware sort; use CSV Row Sorter if you need rows ordered by a column's values.
Only a uniform shift of every data row is supported; there's no way to rotate just a subset of rows.

Examples

Shifting three data rows down by one

Input

id,name
1,Ada
2,Alan
3,Grace

Output

id,name
3,Grace
1,Ada
2,Alan

Shifting down by 1 moves the last data row ("3,Grace") to the top of the data section; the header stays at row 0.

Best Practices & Notes

Best Practices

Confirm the shift direction on a small sample first, up and down are easy to mix up before you see the actual result.
Use CSV Row Sorter instead when rows need to be ordered by a column's actual values rather than cyclically shifted.
Combine with CSV Transposer if you need to rotate rows into columns entirely, rather than just reordering rows among themselves.

Developer Notes

Splits the padded grid into `[header, ...dataRows]`, applies the shared `wrap(value, modulus)` modular-arithmetic helper to the data rows' indices only, and reattaches the untouched header before re-serializing, guaranteeing row 0 never participates in the rotation.

CSV Row Rotator Use Cases

Cycling log-style or time-series data rows to bring recent entries to the top without a full sort
Exploring different starting points in cyclic or periodic data for testing or presentation
Reordering rows as a group while keeping the header and every column's content completely stable

Common Mistakes

Expecting the header row to shift too; it's always excluded and stays fixed at row 0.
Reaching for this tool when a content-based sort is actually needed, use CSV Row Sorter for ordering by column values.

Tips

A shift amount equal to the total data row count returns the original order unchanged, a handy sanity check.
If you need both a header-preserving shift and a content-based order, apply CSV Row Sorter first, then rotate if a further cyclic offset is still needed.

CSV Row Rotator