Transposing a table swaps its rows and columns — what was column 1 becomes row 1, and so on. This is the same operation as the TRANSPOSE function in Excel or Google Sheets. Useful when you need to pivot data for different reporting or import formats. Runs entirely in your browser.
Transposing a CSV swaps its rows and columns — what was the first row becomes the first column, and what was the first column becomes the first row. This is the CSV equivalent of the matrix transpose operation in mathematics. It is commonly needed when data is organised in one orientation but a target system expects the other.
Data from some reporting tools comes in a "wide" format with many columns — dates as column headers and metrics as row values. Databases and most BI tools expect a "tall" or "long" format with dates in one column and a value column. Transposing is one step in this reshape. More complex reshaping (pivoting and unpivoting) typically requires spreadsheet formulas or a dedicated data tool — but for simple row/column swaps, transpose is all you need.
Conceptually yes. If your CSV represents a matrix (all values numeric), the transpose is the mathematical matrix transpose. For mixed data (strings, numbers, headers), it is simply a structural row/column swap.
Rows with fewer columns than the maximum are padded with empty fields so the output is rectangular. Rows with more columns than the header row are included with extra cells.
Transposing twice returns to the original — it is its own inverse operation. Paste the transposed output and click Transpose again.
No hard limit — the entire operation runs in your browser's JavaScript engine. Very large files (100,000+ rows or columns) may slow the browser; for those, a command-line tool like csvkit is more appropriate.
See also CSV Column Tools, CSV Delimiter Changer, and the full data format toolkit.