CSV Transpose

Flip rows and columns in a CSV table

Input CSV5 rows × 4 cols

Transposed CSV (4 rows × 5 cols)

Name,Alice,Bob,Carol,Dave
Age,30,25,35,28
City,New York,London,Tokyo,Berlin
Role,Engineer,Designer,Manager,Developer

How CSV transposition works

Transposing a CSV swaps its rows and columns: the first column becomes the first row, the second column becomes the second row, and so on. This is the CSV equivalent of the matrix transpose operation. It is useful when your data is in wide format (many columns) and you need it in long format (many rows), or vice versa — a common step when reshaping data for APIs, spreadsheets, or databases. The converter handles quoted fields containing commas correctly (RFC 4180 compliant), and pads shorter rows with empty cells to produce a rectangular result.

Built and maintained by Meet Shah · Last updated 19 July 2026

What this tool is used for

Flipping a wide report into a tall one so each attribute becomes a row.
Turning a table with dates across the top into one with dates down the side.
Reshaping an export to match the orientation an importer expects.
Making a very wide table readable by turning it on its side.
Comparing two records side by side by transposing the pair.

Frequently Asked Questions

What does transposing do to my data?: Turns rows into columns: the first row becomes the first column, so a table of 3 rows and 10 columns becomes 10 rows and 3 columns. The header row becomes a header *column*, which is usually the point — long-format data becoming wide, or the reverse.
What if the rows have different lengths?: Short rows are padded with empty cells, because a transposed table must be rectangular. Ragged input almost always means an unquoted delimiter upstream, so it is worth checking the source rather than accepting the padding.
Are quoted fields handled?: Yes — values containing commas, quotes or newlines are parsed and re-quoted per RFC 4180, so `"Smith, John"` stays one cell rather than splitting and shifting every column after it.
When is this actually needed?: Reshaping an export for a chart that wants series in columns rather than rows, feeding a tool that expects one observation per row, or making a very wide table readable. It is the CSV equivalent of Excel's Paste Special → Transpose.
Is a very wide result a problem?: It can be. Transposing 20,000 rows gives 20,000 columns, and Excel stops at 16,384 while many parsers slow down badly long before that. If the result is that wide, the data probably wants restructuring rather than transposing.
What happens to the header row when transposing?: It becomes the first column, which is usually what you want but is no longer a header to any consumer. Anything reading the result expects field names across the top, so the transposed file often needs a new header entirely.

Common errors and gotchas

Transposing a file with a header row and getting the headers as the first column, which most importers will not expect.
Assuming rows are equal length, where a ragged file produces gaps in unpredictable places.
Losing column types, since a transposed column now mixes what were several different types.
Overlooking quoted fields containing commas, which a naive transpose misaligns.
Transposing a very wide file past a spreadsheet's row limit.