Unpivot Excel
Turn a wide crosstab into a normalized long list - the reverse of a pivot table - by picking your ID columns. No Power Query, no upload.
Drop your file here or click to upload
Supports .xlsx, .xls, .xlsm, .xlsb, .csv · up to 50MB
How to Unpivot Data in Excel Online
- Upload your file - .xlsx, .xls, .xlsm, .xlsb, or .csv.
- Pick ID columns - the columns that identify each row and repeat.
- Name the output - choose names for the attribute and value columns.
- Download - get the long-format data, ready for pivots or charts.
Why Unpivot?
Crosstab layouts - one column per month, product, or region - look tidy but are hard to analyze. A normalized long list (one row per observation) is what pivot tables, charts, and databases expect. Unpivoting reshapes your data into that form so you can summarize it freely, and it's the exact reverse of building a pivot table.