Free · Group and total any spreadsheet

Pivot Table Explorer

Open a CSV, choose rows, columns, and a value to total, and explore a pivot table without a spreadsheet app.

  • Papa Parse
  • Private in your browser
  • No signup
Go to tool

1Pick what to total

Open a CSV fileUp to 50,000 rows, 50 columns and eight million characters. Nothing is uploaded.

At most 500 row groups, 100 split columns and 25,000 result cells. Blank grouping values stay separate from text such as “(blank)”.

Numbers use decimal points and optional grouped commas, $, € or £. Currency marks do not convert currencies; group different currencies separately. Percentages use fractions (25% = 0.25). Parentheses mean negative. Display uses up to 12 significant digits; exports keep the computed numeric value.

2Your pivot table

Your pivot table will show hereOpen a CSV or press “Try a sample” to see it work.

Three simple steps

How to use it

  1. Open a UTF-8 CSV with up to 50,000 rows and 50 columns.
  2. Choose grouping fields and a sum, average, count, minimum, maximum or distinct count. Review any skipped values.
  3. Sort and page through the summary, then copy or download all groups at full computed precision.

Your files stay on this device

Your CSV stays in this tab. Parsing and calculations run locally in a separate browser worker.