Convert Spreadsheet Columns into Rows
Turn monthly columns into rows, or rows into columns. Choose your identifier fields, review the layout, and download one CSV without hidden aggregation.
Two monthly columns become four useful records
Keep ID as the identifier. Select January, then February, and name the new fields Month and Value. Two people with two monthly values become four records, ready to filter, chart or import. Empty selected cells still get their own records.
| ID | January | February |
|---|---|---|
| 001 | 10 | 12 |
| 002 | 20 | 25 |
| ID | Month | Value |
|---|---|---|
| 001 | January | 10 |
| 001 | February | 12 |
| 002 | January | 20 |
| 002 | February | 25 |
This synthetic example preserves ID as text and follows the selected January, then February column order.
The saved CSV keeps literal text, including leading zeros, Unicode and line breaks. Import identifier and value columns as Text in spreadsheet software to avoid reinterpretation or formula evaluation.
How to reshape your table
- Upload one CSV, TSV or plain-values XLSX workbook. For XLSX, choose the worksheet.
- Choose the direction and the fields that identify each record. Select the value columns or name/value fields.
- Review the before-and-after mapping, counts, and any newly empty cells or formula-looking text.
- Download the UTF-8 CSV. A changed file or mapping requires a fresh review.
Supported inputs and limits
Choose the separator and UTF-8 or Windows-1252 encoding for CSV/TSV. XLSX uses one visible plain-values worksheet with a single header row. Formulas, merged cells and error cells are unsupported. Number formatting is not carried into CSV: stored numeric values and date serials are used, and Boolean values become TRUE/FALSE text.
Up to 50,000 input records, 200 fields and 500,000 input cells including headers. The reviewed result supports up to 300,000 records and 1,000,000 cells including headers, within 100 MiB and the processing time limit. Uploads must fit 50 MiB. These are ceilings; a table must satisfy every limit.
Related table tools
Need smaller import batches after reshaping? Split a large CSV. For a large Excel workbook, try Reduce Excel File Size.
Questions about your saved result
What happens to duplicate records?
Rows into columns requires unique identifier/name pairs. Repeated pairs stop the operation, even if their values match. The tool does not sum, average or silently choose a value.
What happens to blank cells?
Columns into rows keeps every selected empty value. In the reverse direction, review and acknowledge absent combinations that become empty cells.
Does it run spreadsheet formulas?
No. Formula-looking CSV text remains literal text in the saved file. Spreadsheet software may evaluate it when opened; use text import and set those columns to Text.
What does access include?
Previewing is free. SuperTool provides one anonymous validated result, followed by account access. Re-downloading the same completed result is free.
Where is my file processed?
Your uploaded file is processed in temporary app jobs on SuperTool’s hosting platform, without an external conversion API. See the existing SuperTool privacy information for account and service details.