Search tools

Search for a command to run...

Pivot Table Tool (Summarize CSV & Excel Data)

Summarize spreadsheet data with a pivot table in your browser — group by rows and columns, sum, count, average, min or max, group dates by month, quarter or year, and export to Excel.

How to use

  1. 1Load a CSV or Excel file, or paste data.
  2. 2Choose the row and column fields, the value and how to summarize it.
  3. 3Export the pivot table to Excel or CSV.

Frequently asked questions

What can it calculate?

Sum, count, average, minimum, maximum and count of distinct values, with row, column and grand totals.

Can it group dates?

Yes — when the row field contains dates you can group by month, quarter or year.

Is my data private?

Yes — the calculation runs entirely in your browser.