Excel Pivot / Unpivot Online
Reshape a CSV or Excel spreadsheet — pivot long data wide, or unpivot wide data long — entirely in your browser.
1. Upload your data
Choose a file or drag and drop it here
.csv, .xlsx, or .xls
2. Preview
3. Choose ID columns to keep
4. Result
Reshaping happens entirely in your browser — your spreadsheet never touches our servers.
A live preview of both the input and the reshaped result, before you download anything.
No account, and no limit on how many times you can use it.
Pivot vs. Unpivot
Unpivoting (also called "melting") takes wide data — with one column per category, like separate Jan/Feb/Mar columns — and reshapes it into long, tidy data with one row per category per record. Most charting tools, databases, and pivot tables actually expect this long shape as their input. Pivoting does the reverse: it spreads one column's distinct values out into their own columns, which is often the shape you want for a human-readable summary table.
How to Unpivot a Spreadsheet
- Upload your file. A CSV or Excel file, with a header row.
- Choose ID columns. Check the columns that should stay as-is (like a name or date); leave the rest unchecked.
- Transform. Every unchecked column becomes one row per record, with "Variable" and "Value" columns holding the original column name and its value.
- Download. As CSV or as a real .xlsx file.
How to Pivot a Spreadsheet
- Upload your file, then switch to Pivot.
- Choose three columns: one for the new row labels, one whose values become new column headers, and one that supplies the values filling each cell.
- Transform and download the reshaped result.
Frequently Asked Questions
What do Pivot and Unpivot actually do?
Unpivot (also called "melting") takes wide data — one column per category — and reshapes it into long, tidy data with one row per category per record, which most charting tools and databases actually want. Pivot does the reverse: it takes long data and spreads one column's distinct values out into their own columns.
How do I unpivot a spreadsheet?
Upload your file, switch to Unpivot, check which columns should stay as-is (ID columns — usually things like name or date), and leave the rest unchecked. Every unchecked column becomes two new columns, "Variable" and "Value," with one row per original column per record.
How do I pivot a spreadsheet?
Upload your file, switch to Pivot, and choose which column becomes the new row labels, which column's values become new column headers, and which column supplies the values that fill each cell.
What happens if several rows share the same row and column in a pivot?
They're combined into one cell, the same way a spreadsheet pivot table does it. By default their values are added up; you can instead count them, average them, keep the smallest or largest, or keep the first or last. The result also shows how many cells combined several rows.
Are dates and codes with leading zeros kept as they are?
Yes. Dates in Excel files come out as readable dates (like 2026-01-31) instead of Excel's internal day numbers, and values such as ZIP codes, IDs or product codes with leading zeros, or very long numbers like phone numbers, stay exactly as written.
Can I upload a CSV instead of an Excel file?
Yes — CSV, .xlsx and .xls files all work. For an Excel file with several sheets, you choose which sheet to use. The result downloads as either CSV or Excel.
Is my spreadsheet uploaded anywhere?
No. The reshape happens entirely in your browser — your file is never sent to CurePDF's servers.
Is this tool free?
Yes, with no account required and no limit on how many times you can use it.