Convert Wide (Pivoted) Excel Data to Long (Tall) Format

Transform columns-as-variables (wide format) into rows-as-observations (long format). Required for Power BI, Tableau, and pandas. Pro tier.

Loading tool…

Un-Pivot limits by plan

Free is enough for most one-off jobs. Pro raises the file and batch caps; Pro + Media unlocks GB-scale streaming and unlimited duration.

See all plans

Free

No signup needed

File size: 5 MB
Rows per file: 10,000
Files per batch: 1

Pro

£7/mo — 50× larger files

File size: 50 MB
Rows per file: 100,000
Files per batch: 5

Pro + Media

Stream multi-GB files

File size: 200 MB
Rows per file: 500,000
Files per batch: 20

Larger files supported on Developer (5 GB CSV) and Enterprise (unlimited). All processing happens in your browser — files never reach a server.

How it Works

1
Upload your wide-format Excel or CSV file
2
Select the ID columns (fixed) and the value columns to unpivot
3
Download the long-format file with variable names in a new column

Privacy First

0 bytes uploaded. The Un-Pivot Tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets never leave your device.

Frequently Asked Questions

What is wide vs. long format?

Wide: years as column headers (Sales_2021, Sales_2022, Sales_2023). Long: a single Year column with one row per year per entity. Power BI and Tableau prefer long format.

Can I rename the generated variable and value columns?

Yes — the output column names (default: 'variable' and 'value') are customisable in the options panel.

Related Excel Tools

Multi-Sheet Joiner

Perform Left Join or Inner Join between two sheets in an Excel workbook (or two files) on a common key column. Pro tier.

Open tool

Conditional Splitter

Split one Excel or CSV file into separate output files based on the unique values in a selected column. Pro tier.

Open tool