About

Transposing tabular data is a matrix operation where an m × n table becomes n × m. Getting this wrong manually in a spreadsheet with hundreds of rows leads to misaligned data, broken imports, and corrupted database loads. This tool implements a strict RFC 4180-compliant CSV parser that correctly handles quoted fields, embedded delimiters, and escaped double-quotes before performing the transpose. It auto-detects the delimiter (comma, semicolon, tab, or pipe) and pads ragged rows with empty cells to produce a rectangular matrix. The output is re-serialized with proper quoting so it can be directly imported into any system. Note: this tool treats the first row identically to all others. If your first row contains headers, they will become the first column after transposition.

Formulas

The transpose operation maps each element from its original position to a swapped position in the output matrix:

B_j,i = A_i,j

Where A is the input matrix of size m × n (rows × columns), and B is the resulting transposed matrix of size n × m. The indices i and j represent the row and column indices respectively, where 0 ≤ i < m and 0 ≤ j < n.

For ragged input (rows of unequal length), the tool first normalizes to a rectangular matrix by computing the maximum column count n = max(len(row_i)) and padding shorter rows with empty strings.

Reference Data

Delimiter	Symbol	Common Use	Auto-Detected	RFC Standard
Comma	,	Most CSV files (US/UK locale)	Yes	RFC 4180
Semicolon	;	European locale CSVs (Excel EU)	Yes	No formal RFC
Tab	\t	TSV files, database exports	Yes	IANA TSV
Pipe	\|	Legacy systems, mainframe exports	Yes	No formal RFC
Space		Fixed-width approximations	No	None
Colon	:	/etc/passwd, config files	No	None

Frequently Asked Questions

The parser follows RFC 4180: any field wrapped in double quotes is treated as a literal value. Commas, newlines, and other delimiters inside quotes are preserved as part of the cell content. Escaped quotes (two consecutive double-quote characters "") are converted to a single double-quote in the output.

The tool calculates the maximum column count across all rows and pads shorter rows with empty strings before transposing. This ensures the output is always a valid rectangular matrix. The padded cells appear as empty values in the transposed result.

Transposition treats all rows identically. If row 0 contains headers like Name, Age, City, those values become the first column (column 0) in the output. There is no special header-detection logic. If you need headers in the transposed output, you must add them manually after conversion.

The tool counts occurrences of four candidate delimiters (comma, semicolon, tab, pipe) in the first five lines of input and selects the one with the highest consistent frequency. It can fail on ambiguous data - for example, a file where semicolons and commas appear equally often. In such cases, manually select the correct delimiter from the dropdown.

The tool runs entirely in the browser. Practical limits depend on available RAM. Files under 10 MB (roughly 100,000 rows × 20 columns) transpose in under one second on modern hardware. Files above 50 MB may cause browser tab slowdowns. For extremely large datasets, consider splitting the file first.

Yes. The serializer wraps any field containing the delimiter, double quotes, or newline characters in double quotes, and escapes internal double quotes by doubling them. This produces output fully compliant with RFC 4180, which both Excel and Google Sheets import correctly. For European Excel versions expecting semicolons, select semicolon as the output delimiter.