How to use
- sales.xlsxproduct × month (Apr–Jun)
Add the wide table
- Keep product and represt become item and value
Keep columns, reshape
- sales_long.xlsxproduct, rep, item, value
Save the long table
Choose an Excel (.xlsx) or CSV file with “Choose file”. “Try with sample” loads a monthly sales table built on your device.
Pick a conversion. “Transpose” swaps rows and columns. “Wide → long” keeps the columns you choose and gathers the others into “Item” and “Value”. “Long → wide” asks for the row labels, the column that becomes columns, and the value column.
Check whether row 1 is a header (item names). A table without a header is shown with letters A, B, C…
Check the preview, the change in rows and columns, and the counts of left-out rows and empty cells.
Download as Excel (.xlsx) or CSV (UTF-8 with BOM, Shift_JIS and others).
What it does
Transposes rows and columns
Swaps rows and columns, including the header row. Rows with different numbers of cells are padded with blanks, so the result stays a clean grid.
Wide to long (unpivot)
Choose the key columns to keep. The other columns are gathered into “Item” and “Value” columns. Empty cells can be left out or kept as empty rows, and both column names can be changed.
Long to wide (pivot)
Choose the row labels, the column that becomes columns, and the value column. When the same row and column meet more than once, pick the first value, the sum, or a join.
Keeps dates and numbers as their types
Dates are written as dates and numbers as numbers. Digits-only CSV cells become numbers, while codes with a leading zero such as 01 stay text.
Check the result and the notes together
The first rows of the result and the change in rows and columns are shown, with counts of repeated values, non-numeric values and left-out rows or cells, before you save.
Use cases
- Turn a sales table with one column per month into month and amount columns for a pivot table
- Turn survey answers spread across question columns into one long list of questions and answers
- Rebuild long records as a cross-tab with dates as columns
- Swap rows and columns so that items read downwards
- Reshape a CSV into a layout that is easier to work with in Excel, then save it
Supported formats
Input
Output
Capability matrix
| Feature | Support | Notes |
|---|---|---|
| Transpose (swap rows and columns) | Supported | — |
| Wide to long (unpivot) | Supported | Several key columns can be kept |
| Long to wide (pivot) | Supported | Repeated values: first, sum or join |
| Aggregates other than sum (average, count, max…) | Not supported | Use an Excel pivot table for these |
| Formulas, formatting, merged cells, charts | Not supported | Values only (formulas become their results) |
| Converting several sheets at once | Not supported | One sheet per run |
| Legacy Excel (.xls) | Not supported | Re-save as .xlsx in Excel first |
Limits & notes
- Reads up to 100 MB and 3 million cells per file. The result is also limited to 3 million cells and to Excel’s grid (1,048,576 rows, 16,384 columns); beyond that, the conversion stops with an error.
- If empty cells are left out when reshaping to long, they come back as blanks when pivoted to wide. A column that is entirely blank, or a row whose values are all blank, does not come back.
- When the same row and column meet more than once in a pivot, they are combined with the chosen rule. Sum adds only numbers and leaves out non-numeric values.
- Columns with the same header name are treated as separate columns, so rename them first if needed.
- Works on a smartphone (390 px wide), but choosing columns takes many steps, so use a PC for large tables.
Privacy & safety
Reading, converting and building the download all happen in your browser. File contents are never sent to or stored on a server.
FAQ
How do I swap rows and columns in Excel?
How do I unpivot a wide table into a long one?
How do I pivot a long table back to wide?
Does it work with CSV files?
Are dates and numbers changed?
Are my files uploaded?
Related tools
Excel Cleanup
Tick what to fix and clean up spaces, character widths, dates and numbers across a whole Excel or CSV file at once. Changed cells are highlighted, and you can save as Excel or CSV.
Excel Merge
Combine sheets from several Excel or CSV files: stack their rows into one table, or keep them as separate sheets in one workbook. Columns are aligned by header name automatically.
Excel Deduplicate
Find duplicate rows in an Excel or CSV file by the columns you choose, ignoring the variations you choose, then remove them or merge each group into one row. Review every group, change which row survives, and save as Excel or CSV.
Excel Compare
Load an old and a new Excel or CSV file to see added, removed and changed rows, with every changed cell shown as “old → new”. Rows in a different order are matched by a key column such as a product code. Cell values are compared, not formatting or formulas. Save the result as a colour-coded Excel report or CSV.
Excel Text Tools
Pick Excel or CSV columns and stack steps in order: convert full-width and half-width text in bulk, split a column by a delimiter, combine columns, zero-pad numbers so leading zeros stay, and convert hiragana and katakana. Changed cells are highlighted, and you can save as Excel (.xlsx) or CSV.
CSV Encoding Fix
Convert CSV files that show garbled text in Excel to UTF-8 with BOM or Shift_JIS, with automatic encoding detection. Mojibake that was already saved, such as “日本語”, can usually be restored too.
Last updated: