CSV Transposer
Swaps rows and columns so a wide layout becomes a tall one, or the reverse.
Loading the tool…
Processing happens locally in your browser.
What you paste or load is processed by this page and is not uploaded to a server. Nothing is stored unless you use a control that says it stores something, and you can clear anything this site has kept from the privacy page.
How to use this tool
- Paste the CSV.
- Select Transpose.
- Check the first output row, which was previously the first column.
What csv transposer does
Reports are often laid out with periods across the top and measures down the side, which reads well on a page and loads badly into anything else. Transposing swaps the two axes, turning each column into a row, which is frequently the single step that makes a hand-built report machine-readable.
Every cell is treated as data here, including the header row, because a transposed header is no longer a header. Rows of unequal length are padded so the result is rectangular, which means a ragged input produces a clean output rather than an error — worth knowing if the file also has structural problems.
Frequently asked questions
It becomes the first column. In a transposed file the original header is no longer a header, so every cell including the first row is treated as data.
Short rows are padded with empty values so the result is rectangular. Run the validator first if you did not expect the file to be ragged.
Yes. Transposing twice returns the original layout, apart from any padding that was added to ragged rows.