Free web tool
Transpose CSV rows and columns.
Transpose a CSV when rows need to become columns and columns need to become rows. Think of it as rotating the whole table: the first row is not treated specially, so headers move along with everything else.
If the first row is name,Ada,Grace, those cells become part of the first output column after transposition. The tool transposes the entire matrix; it does not keep a header row fixed while rotating only the data.
If some CSV rows have fewer cells than others, the widest row defines the matrix width. Missing cells are filled with blanks. A surprising number of blanks in the output can therefore reveal inconsistent row lengths in the source CSV.
This operation only swaps coordinates. It does not group by keys, aggregate values, or turn category values into generated columns. For those reshaping jobs, a pivot or other structured transformation is a better fit.
A 5-row × 100-column matrix becomes 100 rows × 5 columns. That can make a human-readable table easier to scan, but it can also change which side of an import limit you hit, so check the resulting shape.
Use it for small exports where attributes were arranged vertically and records horizontally. After transposing, verify that the new first row has the header meaning you actually need before saving.