Work in progressInpan is being built in the open. Expect rough edges, missing pieces and changes from week to week.
Pivot tables over large public data, entirely in your browser.
Open a dataset or a file of your own, then group, split, filter and sort it live. Millions of rows, with no server behind it: the database runs in this tab, and nothing to install or sign up for.
Use a laptop or desktop browser. A large dataset downloads once, then opens from this device.
| Region | Sales | Qty | Profit | Orders |
|---|---|---|---|---|
| Total | 2,297,200.86 | 37,873 | 286,397.02 | 9,994 |
| Central | 501,239.89 | 8,780 | 39,706.36 | 2,323 |
| East | 678,781.24 | 10,618 | 91,522.78 | 2,848 |
| South | 391,721.91 | 6,209 | 46,749.43 | 1,620 |
| West | 725,457.82 | 12,266 | 108,418.45 | 3,203 |
Real datasets, millions of rows
Each dataset opens as every row, or as a pivot ready to change. The table draws only the rows in view, so scrolling stays smooth at any size.
- UK house sales, 1995–2023 · HM Land Registry28.3M sales
- Medicare Part D prescribing, 2023 · CMS26.8M rows
- US flight delays, 2015 · US DOT5.8M flights
- Superstore orders · sample9,994 lines
Or open a file of your own: CSV, TSV, JSON or Arrow to pivot, filter and sort, or Parquet of any size to browse.
Group, filter and sort where the data is
DuckDB, compiled to WebAssembly, runs in the page and answers each change. Group rows into a tree, split measures into columns, filter with conditions joined by All or Any, and sort by several keys in order. A column that cannot group, such as a measure or an ID that differs on nearly every row, stays listed with the reason.
Everything runs in this tab
Inpan has no server and no account. The page loads DuckDB, compiled to WebAssembly, and every query runs on your computer. Datasets come straight from their public hosts and are kept on this device, so the next visit opens them without downloading again. A file you open is read in this browser and never uploaded.