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

  1. Paste your CSV

    Paste or type it into the box, or press Try an example.

  2. Check the result

    The first row becomes the first column.

  3. 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.

Related tools