What does "cyclic" mean here?

Columns that shift off one edge wrap around to the other edge, rather than being dropped, so every original column is still present after the shift.

What's the difference between shifting left and right?

Shifting left moves each column's content toward lower indices, with columns from the left wrapping around to the right end; shifting right does the mirror image.

Does the header row move separately from the data?

No, each column moves as a complete unit, header cell and every data-row cell together, so a shifted column's header still correctly labels its data.

What if the shift amount is larger than the number of columns?

It wraps around correctly using modular arithmetic, so a shift amount larger than the column count behaves the same as its remainder after dividing by the column count.

Is this the same as CSV Column Swapper?

No, Column Swapper exchanges exactly two specific columns; this tool cyclically shifts every column's position at once by a chosen amount.

How is this different from CSV Row Rotator?

This tool rotates the column order (a horizontal shift); CSV Row Rotator rotates the order of data rows instead (a vertical shift), keeping the header fixed.

CSV Column Rotator - Cyclically Shift Column Order

Overview

Introduction

Sometimes a CSV's columns are all present and correct but simply need to be shifted around as a group, moving the last few columns to the front, for example, to match a required layout.

This tool performs that shift cyclically: nothing is lost, columns that fall off one edge simply wrap around to the other.

What Is CSV Column Rotator?

A structural CSV tool that cyclically rotates the entire column order left or right by a chosen number of positions.

Because a rotation moves whole columns, each header cell and its data always travel together, so the meaning of every column is preserved even though its position changes.

How CSV Column Rotator Works

The input is parsed and padded to a uniform grid, then a signed shift amount (positive for left, negative for right) is applied to every row using modular (wraparound) index arithmetic.

Each row's cells are reassigned to their new positions based on that shifted index, and the resulting grid is re-serialized back into CSV text.

When To Use CSV Column Rotator

Use it when a CSV's columns are all correct but need to be shifted as a group to match a required column order.

It's also useful for quickly experimenting with different column orderings without manually re-typing a header list.

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

Features

Advantages

Shifts every column in one operation instead of requiring several manual swaps.
Wraps cyclically, so no column is ever lost off the edge of the grid.
Keeps each column's header and data locked together throughout the shift.

Limitations

Only supports a uniform shift of every column; there's no way to rotate just a subset of columns.
A large, unfamiliar shift amount can be hard to reason about without first checking the exact result.

Examples

Shifting three columns left by one

Input

id,name,amount
1,Ada,120
2,Alan,90

Output

name,amount,id
Ada,120,1
Alan,90,2

Shifting left by 1 moves "name" and "amount" toward the front, wrapping "id" around to the last position.

Best Practices & Notes

Best Practices

Preview the result on a small sample before applying a rotation to a large production CSV, to confirm the shift direction matches your expectation.
Use CSV Column Swapper instead when only two specific columns need to trade places, rather than a full cyclic shift.
Combine with CSV Column Renamer afterward if a rotated layout calls for clearer header names.

Developer Notes

Uses a shared `wrap(value, modulus)` helper implementing true modular arithmetic (`((value % modulus) + modulus) % modulus`) so both a left shift and an equivalent negative right shift resolve to the correct wrapped index, even for shift amounts larger than the column count.

CSV Column Rotator Use Cases

Reordering a CSV's columns as a group to match a required import layout
Cycling through different column orderings quickly while exploring how a downstream tool responds
Moving a cluster of trailing columns to the front (or vice versa) without retyping the header row

Common Mistakes

Confusing left and right shift direction; test on a small sample first if the direction isn't obvious from the column names.
Expecting only some columns to move; a rotation always shifts every column by the same amount.

Tips

A shift amount equal to the total column count returns the original order unchanged, useful as a quick sanity check.
If you only need a couple of columns reordered, CSV Column Swapper is usually simpler than working out the right rotation amount.

CSV Column Rotator