About pivotTable

Pick group-by columns and aggregates (count, sum, mean, min, max, distinct) or pivot one column into many. Results download as CSV.

Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.

Built on open-source libraries: Arquero, Papa Parse.

From the makers

Pilotbase: one admin app for PostgreSQL, MySQL, MongoDB, Redis and more, with an AI agent built in.

More free data tools

sqlBeautify

Format, highlight and fix SQL as you type

sqlCompare

Diff two SQL files like git, after formatting both

downtimeAlert

We check your URL, API or stats page every 30 seconds and email you when it's down

sqlTranslate

Convert SQL between 14 dialects

sqlInspector

Validate SQL and list the tables and columns it touches

csvProfiler

Column types, nulls, distinct values and stats for any CSV