CSV Transpose

How to use

1. 1Paste a CSV (or TSV, semicolon-separated, or pipe-separated) table into the input box. Use Open CSV file to pick a local file, or Load sample to start from an example.
2. 2Pick the input delimiter or leave it on Auto. The detected delimiter shows under the buttons so you can confirm before transposing.
3. 3Choose the output delimiter, then decide whether to pad short rows with empty cells, and whether to use Excel-friendly UTF-8 BOM and CRLF line endings.
4. 4Read the row and column counts under the output panel, and scan the preview table to confirm the transposed layout matches what you expected.
5. 5Click Copy CSV to copy the result, or Download to save it as a .csv or .tsv file you can open directly in Sheets, Excel, or any other spreadsheet app.

About this tool

CSV Transpose flips a CSV table so that each row becomes a column and each column becomes a row. The operation is the spreadsheet equivalent of paste-special-transpose: a 5-row by 10-column report becomes a 10-row by 5-column report, with the values in the same logical cells. It is the fastest way to fix the most common shape problem in exported data, where a wide pivot report needs to be turned long, or a long key-value list needs to be turned wide so each field becomes its own column. The input is parsed with an RFC 4180 quote-aware parser, so embedded commas, quoted multi-line cells, and CRLF row endings all survive the trip unchanged. Delimiter detection picks the best fit from comma, tab, semicolon, and pipe by sampling the first 30 non-empty lines, and the output delimiter is configurable independently so you can paste CSV and copy out TSV (or the reverse) in a single click. When rows have different widths, the Pad short rows option fills the gap with empty cells so the transposed result is a rectangle; turn it off when you want the transposed rows to be exactly as wide as the source data really was. Excel-friendly mode adds a UTF-8 byte-order mark and uses Windows line endings so Excel opens the downloaded file without prompting for an import wizard. A side-by-side preview renders the first rows and columns of the transposed table so you can sanity-check the orientation before you copy or download. Everything is parsed, transposed, and re-emitted in your browser. The CSV is never uploaded, logged, or sent to any server, which makes the tool safe for finance, HR, customer, and any other private spreadsheet data.

Free to use. Works in your browser. No signup, no login.