How to convert a wide excel spreadsheet to long format (unpivot / melt)
- Step 1Upload your wide-format file — Drop an .xlsx or .csv with columns that represent repeated measurements (years, months, categories).
- Step 2Configure ID and value columns — Enter the ID column names (e.g. Country, Region) and the value column names (e.g. 2021, 2022, 2023) as comma-separated lists.
- Step 3Download the long-format file — The unpivoted spreadsheet has one row per original value, with the variable and value in separate columns.
Frequently asked questions
What is the variable column in the output?+
It contains the original column name (e.g. '2021', '2022'). You can rename it in the options to something like 'Year'.
Can it handle multiple value column groups?+
Single value column group only in this version. Stacked melt (multiple value pairs) is planned.
What happens to columns not specified as ID or value?+
Unspecified columns are ignored. Make sure to list all columns you want in the output.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.