Transpose CSV Rows and Columns
Paste CSV text, or drop a .csv file, and download it back with every row turned into a column and every column turned into a row. Nothing is sent anywhere.
Transpose CSV Rows and Columns
Drop your CSV file here
Up to 20MB per file. Stays on this device.
Nothing is sent anywhere. Turn off your Wi-Fi and this page still works - try it.
How it works
- Drop or choose a .csv file, or paste CSV text directly into the text box.
- Review the preview: every original row is now a column, and every original column is now a row.
- Download the result as a CSV file, ready to open in Excel, Sheets, or any spreadsheet.
Input
| name | q1 | q2 |
| Iris | 120 | 150 |
| Coral | 90 | 110 |
Output
| name | Iris | Coral |
| q1 | 120 | 90 |
| q2 | 150 | 110 |
Every row becomes a column and every column becomes a row, including the header line.
Frequently asked questions
Is my CSV sent anywhere?
No. Pasted text and uploaded files are both read and transposed entirely on your device; nothing is sent to a server. Turn off your Wi-Fi after the page loads and it still works. This page loads 10KB of JavaScript, gzipped - about what your browser's network tab will show for this page's own scripts.
What does "transpose" actually mean here?
Every row in your file becomes one column in the output, and every column becomes one row - the same operation as a spreadsheet's "Paste Special > Transpose". A 3-row, 5-column table comes back as a 5-row, 3-column table, with the same values, just flipped along the diagonal.
What happens if rows have different numbers of columns (a ragged CSV)?
Short rows are padded with blank cells up to the width of the widest row before transposing, so the result is always a clean rectangle. Nothing shifts out of place just because one row happened to have fewer fields than another.
What happens to blank lines?
A completely blank line (no content in any of its cells) is skipped rather than turned into an entirely empty output column. If you need a strict, literal transpose that keeps blank lines as-is, turn off "Skip blank rows" once your file is loaded.
Does this handle quoted fields with commas or line breaks inside them?
Yes. This tool reads the whole file with a full CSV parser, so a quoted field like "Smith, John" or a quoted field containing its own line break is kept as one field, correctly, before transposing.
Is the downloaded CSV safe to open in Excel or Sheets?
Yes. Any cell value that would otherwise be interpreted as a spreadsheet formula (starting with =, +, @, or a tab) is automatically neutralized with a leading quote before download, the same protection used across every CSV export on this site.
Files are processed locally in your browser and never uploaded. Read more on the privacy page.