← All tools

Pivot Table Explorer

Load a spreadsheet, click fields into Rows / Columns / Values / Filters, and watch a live pivot table build itself — nested subtotals, sorting, collapsible groups, CSV export and a quick chart.

Drop a .csv or .tsv file here — or choose a file
Everything runs in your browser. Your data never leaves this page.
Or paste data as text
Fields

Click R/C/V/F to add a field to Rows, Columns, Values or Filters. You can also drag a field into a zone.

Pivot layout
Rows
Columns
Values
Filters
Layout is remembered for the next time you load data with the same columns (saved to your browser only).
Click a row-field header (in the left columns) or a value column header to sort. Click ▾/▸ next to a row group to collapse or expand it.
Quick chart — row totals