Everything runs in your browser. Your data and files are never uploaded to Flipper File.
Convert CSV Rows to Columns
This converter turns each row of a CSV file into a column, which is also called transposing. Paste CSV text, copy cells straight from Excel or Google Sheets, or load a file, and the flipped table shows up next to it as you type. You can copy the result or download it as a new CSV file.
How to use it
- Paste your data into the box on the left, or click Load file to open a .csv, .tsv, or .txt file. You can also drag a file onto the box.
- The delimiter is detected automatically. If it guesses wrong, pick Comma, Tab, Semicolon, or Pipe from the Input menu.
- Check the result in the Table view, or switch to Text to see the raw CSV.
- Click Copy, or Download to save a file. Choose Download for Excel if you plan to open the file in Excel.
What converting rows to columns does
Wide data, like a report with one column per month, often needs to be turned on its side so each month gets its own row. Transposing does exactly that. The first row becomes the first column, the second row becomes the second column, and so on.
Before, with each metric in a row:
| Month | Jan | Feb | Mar |
|---|---|---|---|
| Visitors | 1200 | 1350 | 1580 |
| Signups | 84 | 97 | 112 |
After, with each metric in a column:
| Month | Visitors | Signups |
|---|---|---|
| Jan | 1200 | 84 |
| Feb | 1350 | 97 |
| Mar | 1580 | 112 |
That tall layout is easier to sort, filter, chart, and import into databases, since each row is now one record.
Pasting from Excel or Google Sheets
When you copy cells from a spreadsheet, they're copied as tab-separated text. The converter recognizes this, and with Output set to Same as input, the result is also tab-separated. That means you can copy it and paste it straight back into a sheet, and every value lands in its own cell.
Excel and Google Sheets can also transpose with Paste Special. This tool is handy when your data is CSV text rather than a sheet, when the file is too large to open comfortably, or when you need a transposed file to send or upload somewhere.
Turning one row into a column
A single comma-separated line, like red,green,blue,yellow, becomes a column with one value per line. This is a quick way to turn a list from a CSV header, an export, or a tag field into a vertical list.
Uneven rows
If some rows have fewer values than others, the converter fills the gaps with empty cells so the table stays rectangular. The Table view shades those added cells in yellow, and a note tells you how many rows were short. A short row in the original often points to a missing delimiter or a stray line break.
Quoted values and special characters
Values wrapped in double quotes can contain commas, quotes, and even line breaks, like "Austin, TX" or "He said ""hi""". The converter reads these correctly and adds quotes back in the output wherever they're needed. Turn on Quote every value if the system you're importing into expects every field in quotes.
Rows to columns or columns to rows?
Both are the same operation. Transposing swaps the whole table at once, so rows become columns and columns become rows at the same time. If you're starting with columns you want as rows, the CSV Column to Row Converter walks through that case, including turning a single column into one comma-separated row.
Frequently asked questions
Is my data uploaded anywhere?
No. Parsing, transposing, copying, and downloading all happen in your browser. Your data never leaves your device.
Will it change my numbers, dates, or leading zeros?
No. Every value is treated as plain text and moved exactly as it is, so 00721 stays 00721 and dates keep their original format. Opening a CSV in Excel can strip leading zeros, but this tool never does.
How large a file can I transpose?
Files up to 50 MB and tables up to about 3 million cells. For large pastes, the live preview pauses and a Transpose button appears so the page stays responsive.
Why do accented letters look wrong when I open the result in Excel?
Excel sometimes guesses the wrong text encoding for CSV files. Choose Download for Excel, which adds a marker that tells Excel the file is UTF-8 and uses Windows line endings.
Can I undo a transpose?
Yes. Transposing twice gives you back the original table. Copy the result, paste it into the input box, and it flips back.