About the CSV Transpose Tool
Transposing a table turns its rows into columns and its columns into rows, so the first row becomes the first column. It is handy when a report lists months across the top but your chart wants them down the side, or when you need to read a wide record with many fields as a tall list. Paste the CSV and the flipped version appears at once. Rows of different lengths are padded with empty cells so that the table stays rectangular. The separator is detected, quoted values are kept, and everything runs in your browser.
Updated October 2026
How to use the CSV Transpose Tool
- 1Paste your CSV into the box.
- 2The transposed table appears on the right straight away.
- 3Check the note with the new number of rows and columns.
- 4Copy the result or download it as a CSV file.
- 5Paste it again to flip it back if you need the original layout.
Why transpose
Data is not always laid out the way the next program wants it. Spreadsheet formulas, charts and imports each prefer a direction. Doing the flip by hand with copy and paste special is fine for a small block but easy to get wrong for a big one. A tool that flips the text gives the same result every time.
It also helps when you receive a record with hundreds of fields in one row and want to read it as a vertical list.
Example
A small sales table has the header row month, jan, feb, mar followed by sales and costs rows. After transposing, the months run down the first column and sales and costs become the column titles. The numbers keep their meaning; only the layout changes.
Tips
Make sure every row has the same number of cells before you flip it, or accept the padding. If your file uses semicolons, the output keeps the same separator. After flipping, check the first row, because it now holds what used to be the first column.
What the tool does not change
The values themselves are copied as they are: no numbers are rounded, no dates reformatted and no text is trimmed. Quoted cells stay quoted where they need to be, so a cell with a comma inside is still one cell after the flip.
If the table is very large, the result may take a moment to appear on a phone, but nothing leaves your device. After you swap rows and columns, CSV Column Swapper lets you reorder the new columns, and CSV Tools covers other edits. CSV to JSON Converter then turns the flipped table into JSON when you need it for an app.
Features
- Rows become columns and the other way round
- Short rows are padded with empty cells
- Handles quoted values
- Detects comma, semicolon, tab and pipe
- Shows the new size
- Private: nothing is uploaded
Frequently asked questions
What does it mean to transpose a CSV?
Transposing turns rows into columns. Cell in row 2, column 3 moves to row 3, column 2. A table with 3 rows and 4 columns becomes a table with 4 rows and 3 columns.
When would I need to transpose CSV data?
When a source lists categories across the top and your target expects them down the side. It is common for chart data, survey results and records exported with one record per column.
What happens if some rows are shorter?
They are padded with empty cells so the transposed table has no missing positions. The note under the box reminds you when this happened.
Is the first row treated as a header?
No. The whole table is flipped, so the first row becomes the first column. That is exactly what you want for tables where the labels are in the first row and the first column.
Can I get the original back?
Yes. Transposing twice returns the original table, apart from the empty cells added to short rows.
Is the CSV sent to a server?
No. The flip happens in your browser and your data stays on your device.