Convert Long ↔ Wide
1
Upload
2
Settings
3
Filter
4
Export
DataMadEasy
Long ↔ Wide Converter
Login
Sign Up
Forgot password?
Upload file
CSV, Excel, TXT, Parquet supported
Upload file
📂
Drop file here
or click to browse
Long → Wide format
· index col — rows to keep (e.g. country, id)
· column col — becomes new column headers (e.g. year)
· value col — cell values (e.g. sales)
Sample datasets
Conversion direction
Long → Wide
Wide → Long
Pivot long-format data into a wide table.
File type
CSV
Excel
TXT
Parquet

Upload a file to preview

Column settings
Configure how columns are mapped
🟢 Index columns (keep as rows)
These columns identify each row
🟡 Column to pivot
🟣 Value column
Aggregation

Configure columns to see preview

Filter (optional)
Filter rows before conversion

Enable filter to preview filtered data

Download
💾Workflow
Convert & Download
Converting…
Save workflow
Save current settings to reuse later
Load workflow

Click a download button to convert