Account

What new tool do you want?

Office & Documents

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.

Why a pivot table beats scrolling through raw rows

A spreadsheet with 10,000 individual sales transactions answers almost no question directly — 'which region sold the most in Q2' requires manually filtering and adding rows, a process that doesn't scale and is easy to get wrong. A pivot table instead regroups that same raw data by whatever fields you choose (region as rows, quarter as columns, sum of sale amount as the value) and does the aggregation instantly, turning a question that would take manual filtering and a calculator into a single table read at a glance.

Worked example: Pivot Table Tool

Loading a CSV of individual orders with columns for Region, Order Date and Amount, then setting Region as the row field, grouping Order Date by month as the column field, and summing Amount as the value, produces a grid showing each region's monthly total side by side, with row totals (each region's overall sum) and column totals (each month's total across all regions) calculated automatically. Switching the summary from Sum to Count of distinct values on the same setup instead answers a completely different question — how many unique orders each region placed each month — without touching the underlying data at all.

Why date grouping is its own separate feature, not automatic

Raw date values in a spreadsheet are specific — '2026-03-14', '2026-03-22' — which would produce a separate column or row for every single date if pivoted directly, defeating the purpose of summarizing. Explicitly choosing to group by month, quarter or year collapses those specific dates into meaningful buckets first, which is why the date-grouping option exists as a distinct step rather than happening automatically — the tool can't guess whether you want daily, monthly or yearly granularity without being told.

What running entirely in the browser means for this specific tool

Because the aggregation runs locally rather than on a server, this works for data you wouldn't want to upload anywhere — payroll figures, customer lists, internal financials — without the privacy question a cloud-based pivot tool would raise. The practical trade-off is that very large datasets are limited by your own device's memory rather than a server's processing power, which matters mainly for genuinely large files (hundreds of thousands of rows) rather than typical business reporting data.

A column of dates is noticed from the first rows, not from the header name

Date grouping appears when the values look like dates. On a long sheet, that means more than half of the first 50 rows in the chosen column parse as dates and contain a year or a slash. On a short sheet, every row has to look like a date. A header that merely says Date is not enough if the cells are plain text. Sum, count, average, min, max, and count distinct are the aggregations. Average, min, and max need numbers. If a value column has no numbers, those results are blank rather than zero. Figures are shown to two decimal places. The last row is a total, and with a column field the last column is emphasized as well. Count distinct counts different text, not only numbers.

Related tools

More: Office & Documents