How to unpivot excel columns without power query — browser-based melt tool
- Step 1Identify ID columns and value columns — ID columns (e.g. Region, Product) stay; value columns (e.g. 2021, 2022) become rows.
- Step 2Configure and run the unpivot — Enter ID and value column names. Choose variable and value column names for the output.
- Step 3Download the long-format file — Clean long-format .xlsx ready for Power BI, pandas, or R. No Power Query connection embedded.
Frequently asked questions
Is this exactly equivalent to Power Query Unpivot Columns?+
Functionally yes — the output structure is identical. The difference is there's no embedded query in the output and no refresh button.
What if I need the unpivot to refresh automatically on new data?+
Use Power Query for repeatable automated transforms. Use this tool for one-off reshaping.
Does it support unpivoting selected columns (not all value columns)?+
Yes. You specify exactly which column names are value columns — all others are treated as ID columns.
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.