No More VLOOKUP ✓ 100% in-browser
PIVOT TOOL

Pivot

Transform tall data into a wide pivot table

Turn a long-format Name/Category/Value spreadsheet into a wide pivot table in one click. Choose your row key, pivot column and value column, then aggregate with sum, count, concat or first.

Open Pivot Tool →

How to Use — Step by Step

1
Upload your file
Long/tall format CSV or Excel (Name, Category, Value columns).
2
Choose Row Key
The column whose values become row identifiers.
3
Choose Pivot column
Its unique values become new column headers.
4
Choose Value column
The field to aggregate at each intersection.
5
Select aggregation
Sum · Count · Concat · First.
6
Click Pivot → Download
Wide-format table appears instantly; download as CSV.

Features

4 aggregation modes
Sum, Count, Concat, First.
Auto column generation
Pivot column values become headers automatically.
Sparse data safe
Missing intersections left blank (not zero).
Text & numbers
Concat and First work on any column type.
Instant preview
See the result before downloading.
100% in-browser
Your data never leaves your device.

Export

Download format: Output: Wide-format CSV — one row per Row Key, one column per Pivot value.

Privacy & Security

Your files never leave your device. All processing happens entirely inside your browser tab using JavaScript. No data is uploaded to any server, no account is required, and nothing is stored after you close the tab. Fully GDPR-friendly — no data processing obligations are created by using this tool.