Structured Data
CSV Rows to Columns Converter
Transpose a simple comma-separated table so rows become columns. Short rows are padded with a filler you choose. Runs in your browser.
This tool runs open-source code from OmniTools (MIT License). See open-source credits.
CSV Rows to Columns Converter transposes a comma-separated table, so row 1 becomes column 1. It splits on every comma and line break, with no quote handling. Short rows are padded so the output stays rectangular. The default filler is x, and it also replaces cells that were already empty.
The output is comma-separated text with one line per input column. The header row is not special: it becomes the first column.
- Turn a key,value list such as name,Ada and role,admin into one header row and one value row.
- Flip a table that lists months as rows so that the months become columns.
- Find ragged rows: the x filler shows exactly which rows were short.
Instructions
- Paste comma-separated rows. Two rows name,score and Ada,9 become name,Ada and score,9.
- Keep Custom filler as x to mark padded cells, or type another marker such as NA.
- Turn on Fill missing cells with empty values to pad with nothing instead.
- Lines that start with Comment prefix (default //) are skipped. A line that starts with # is treated as data.
- Delete a trailing blank line first. Otherwise it becomes an extra column of filler.
Example
Input: item,qty,price pen,2 ink,1,4
Settings: Fill missing cells with empty values: off, Custom filler: x (the defaults)
Result: item,pen,ink qty,2,1 price,x,4
The pen row has no price. The default Custom filler x fills that cell.
Limits
- Quoted commas split the field. "Doe, Jane" becomes two cells, and each keeps a stray quote mark.
- Only commas separate cells. Semicolons and tabs stay inside the cell text.
- The filler cannot tell a real empty cell from a missing one. Both receive the same value.
- Spaces after commas stay part of the next cell. A cell that contains 0 is kept as 0.