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