Convert CSV Columns to Rows

It swaps the roles of rows and columns. A 3×2 CSV (3 rows, 2 columns) becomes a 2×3 output: the first column becomes the first row, the second column becomes the second row, and so on. If your input has N rows and M columns, the output has M rows and N columns.

Mathematically they do the same thing – both perform a matrix transpose. They exist as separate pages because people search with both phrasings. Whichever you land on, the operation is identical. You can run either tool’s output back through itself to restore the original.

With the default RFC 4180 parser, they are preserved correctly. A cell like "Smith, Jr." stays as one cell on input, and on output any cell containing the delimiter, a newline, or a double quote gets auto-wrapped in quotes with internal " escaped to "". Switch to “Simple split” if you want the naive behaviour.

Yes – that’s the default parser mode. It implements the quoted-field rules from RFC 4180 (2005): fields may be double-quoted, delimiters and newlines inside quotes are literal, and a literal double quote inside a quoted field is written as "". Output obeys the same rules.

Short rows are padded with empty strings to match the widest row before transposing. The stats panel reports how many empty cells were filled, so you can tell the data was uneven without having to count.

Anything up to around 100,000 cells (e.g., 1,000 rows × 100 columns) finishes in well under a second on a modern browser. Much larger and the main cost is the browser re-rendering the output textarea, not the parsing itself.

The output always uses the same delimiter you picked for input. Line endings are normalised: any mix of n and rn on input produces plain n on output. A UTF-8 BOM at the start of input is stripped automatically.

Typical reasons: restructuring a wide table into a long format (or vice versa) before loading into Excel / a database; flipping survey questions from columns to rows for analysis; rotating financial reports for a different dashboard layout; or just preparing input for a tool that expects the opposite orientation.

Only if the parser misreads the input. With RFC 4180 mode a round-trip (transpose, then transpose again) is lossless for standards-compliant CSV. With Simple mode a round-trip on CSV that contains quoted delimiters will corrupt those rows, which is why RFC 4180 is the default.

Yes. It runs entirely in your browser with plain JavaScript. No CSV is uploaded, nothing is logged, and no account is required. Load the page once, disconnect from the internet, and the tool keeps working.