CSV Tools
CSV Transpose
Swap rows and columns in a CSV file.
Loading tool…
What is CSV Transpose?
The CSV Transpose tool swaps the axes of your data: what was row 1, column A becomes row A, column 1. Useful for reshaping data for different analysis perspectives.
How it works
The tool reads all rows into a 2D array, then transposes it (matrix transpose). If the first row is a header, row index labels are prepended.
- Paste CSV. Paste or drop your CSV file.
- Choose options. Toggle whether to treat the first row as a header.
- Copy or download. Get the transposed CSV.
Examples
Wide to long
Convert a dataset with many columns into a long-form table for easier analysis.
Common mistakes
Uneven rows
Rows with fewer columns are padded with empty cells before transposing.
Alternatives
Spreadsheet transpose
Excel and Google Sheets can transpose data via Paste Special.
Frequently asked questions
What happens to trailing empty cells?
Rows shorter than the maximum column count are padded with empty strings.