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 a pivot has duplicate row/column combinations?

The last matching value wins for that cell — this tool does a plain pivot, not a pivot with aggregation (no automatic summing or averaging of duplicates). If your data has meaningful duplicates you want summed, aggregate it before pivoting.

Can I upload a CSV instead of an Excel file?

Yes — both CSV and .xlsx/.xls files are accepted as input, and the result can be downloaded as either CSV or Excel.

Excel Pivot / Unpivot Online

0/5 · 0 ratings

Reshape a CSV or Excel spreadsheet — pivot long data wide, or unpivot wide data long — entirely in your browser.

✓ Never uploaded — processed in your browser

1. Upload your data

Choose a file or drag and drop it here

.csv, .xlsx, or .xls

Never uploaded

Reshaping happens entirely in your browser — your spreadsheet never touches our servers.

See before you download

A live preview of both the input and the reshaped result, before you download anything.

Free, no limit

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 reshapes wide data into long/tidy data; Pivot does the reverse, spreading one column's values into new columns.

Is my spreadsheet uploaded anywhere?

No. Reshaping happens entirely in your browser.

Is this tool free?

Yes, with no account required and no limit on how many times you can use it.

Reshape your data now