CSV Transpose
Rotate CSV rows and columns — swap headers and records instantly
About CSV Transpose
Swaps the rows and columns of comma-separated data, so the header row becomes the first column and each record becomes a column of its own. Short rows are padded with empty cells to keep the grid rectangular, and cells containing commas or quotes are re-quoted in the output. Paste the data or load a .csv file; processing stays in your browser.
Category: Converters.
Frequently asked questions
What does transposing a CSV do?
▾
Transposing swaps rows and columns: what was a row becomes a column and vice versa. If your CSV has 3 rows and 4 columns, the transposed result will have 4 rows and 3 columns. It's useful when data is oriented horizontally but a tool expects it vertically.
Does it handle quoted cells with commas or newlines?
▾
Commas, yes; line breaks, no. Quoted cells can contain commas and doubled quotes (""), but the input is split into rows at every line break before quotes are read, so a multi-line cell gets cut in two.
What's the maximum CSV size I can transpose?
▾
There's no fixed limit, but speed depends on your device, and very tall files (tens of thousands of rows or more, depending on the browser) can fail with an error. Keep in mind that each input row becomes an output column, and Excel supports at most 16,384 columns.
Can I transpose back to the original?
▾
Yes. Paste the output back in and click Transpose again to restore the original layout. Rows that were shorter than the others come back padded with empty cells, and spaces around values are trimmed.