Transpose Table
Swap the rows and columns of CSV or pasted table data. Choose how the header and uneven rows are handled, see input and output sizes, download CSV or copy tab-separated output.
Loading Transpose Table…
About the Transpose Table
Transpose Table turns rows into columns and columns into rows. Paste data copied from a spreadsheet (tab-separated) or CSV, or upload a file.
Choose whether the header row is transposed with the data and what happens with rows of different lengths: pad them with blank cells or stop and list them. Quoted text, line breaks inside cells and trailing empty cells are preserved. Download the result as CSV or copy it as tab-separated text to paste straight into a spreadsheet.
How to use
- Paste table data or upload a CSV file.
- Check the delimiter and header option.
- Choose the uneven-row policy.
- Check the input and output dimensions and the preview.
- Download CSV or copy as tab-separated text.
Key features
- CSV, TSV and spreadsheet paste input.
- Header can be transposed or left out explicitly.
- Pad uneven rows or require correction.
- Input and output dimensions shown.
- Quoted content, multi-line cells and trailing empty cells kept.
- CSV download and tab-separated copy.
Best practices
- Use “require equal rows” when the shape matters.
- Paste from Excel or Sheets directly — tabs are detected.
- Check the dimensions after transposing.
Benefits
- No paste-special gymnastics.
- Exact cell contents preserved.
- Private: runs locally.
Frequently asked questions
What does “transpose the header” mean?
When on, the header row becomes the first column of the output. When off, the header row is left out and only data rows are transposed.
What if rows have different lengths?
Choose Pad to fill short rows with blank cells, or Require equal rows to stop and list the rows that differ.
Why copy as tab-separated?
Spreadsheets split pasted tab-separated text into cells automatically.
Is my data uploaded?
No. Files and pasted data are processed only in your browser. Nothing is uploaded or stored, and the tool keeps working offline once the page has loaded.