CSV Transpose
Turn CSV on its side: rows become columns and columns become rows.
Processed on your device. Files are not uploaded
How to swap the rows and columns of a CSV file
Paste your CSV
Paste or type it into the box, or press Try an example.
Check the result
The first row becomes the first column.
Copy or download
Open it in a spreadsheet.
Worked example
This is what CSV Transpose gives for its own sample values. Open the tool above and change anything to try your own.
CSV
name,team,city,age Ada,Platform,London,36 Linus,Kernel,Helsinki,54 Grace,Compilers,New York,85 Ada,Platform,London,36 Alan,Research,London,41
- Delimiter
- Detect automatically
Transposed CSV
name,Ada,Linus,Grace,Ada,Alan team,Platform,Kernel,Compilers,Platform,Research city,London,Helsinki,New York,London,London age,36,54,85,36,41
About CSV Transpose
Turn CSV on its side, so rows become columns and columns become rows. It is useful when a report has years across the top and you want them down the side.
FAQs
Is the header treated specially?
No. The whole table is flipped, header row included.
What about uneven rows?
Short rows are padded with empty cells.
Can I keep only some columns?
Use CSV Column Extractor.