Free Online Pivot Table Tool — Summarise Any Data Without Excel
Upload any data table and create pivot-style summaries: group by any column, aggregate by sum, average, count, min, or max on any numeric column.
Last updated: January 2026
Pivot Table Summarizer
Upload CSV or Excel file
or paste data below
What does a pivot table do and why do people use them?
A pivot table groups all rows that share a common value in a chosen column, then aggregates a numeric column for each group. Instead of scanning 500 rows of sales data to see how much each region sold, you pivot on "Region" and sum the "Revenue" column — and you get a clean table showing total revenue per region. It is the most-used Excel feature for a reason: it turns raw data into actionable summaries in seconds.
How to use the pivot summariser
Paste your data or upload a CSV or Excel file. The tool reads the headers from your first row and populates the Group By and Aggregate Column dropdowns automatically. Select which column you want to group by (for example, "Category" or "Region"), which column you want to aggregate (for example, "Sales" or "Amount"), and which function to apply — Sum, Average, Count, Min, or Max. Optionally select a Sub-Group column to create a cross-tab that shows values broken down by two dimensions.
Sum vs Average vs Count — which to use
Use Sum when you need totals — total revenue by region, total costs by department. Use Average when you need typical values — average order value by category, average salary by role. Use Count when you need frequency — how many transactions per customer, how many employees per department. Use Min and Max when you need range analysis — lowest and highest temperature by month, smallest and largest deal size by sales rep.
Exporting pivot results to Excel
Click Export as Excel to download the pivot summary as a properly formatted .xlsx file. The group labels are preserved exactly as shown on screen, with a bold header row and a grand total row at the bottom. Numeric values are formatted to two decimal places. You can use this file for further analysis, include it in a report, or send it to a colleague who works in Excel.
Frequently asked questions
How is this different from Excel's pivot table?
Excel's pivot table is more powerful — it supports multiple value fields, calculated fields, and drill-down. This tool covers the most common use case: one group-by column, one value column, one aggregation. For simple summaries it is faster and requires no software.
Can I group by multiple columns at once?
You can select a primary group and one secondary group (sub-group). The results show the combined key as a single label. Full multi-level grouping is a planned feature.
My numeric column is being treated as text — what do I do?
Check that your values contain only digits, decimal points, and optionally a currency symbol or comma. The parser strips $ and commas before parsing. If a value contains letters or other characters it will be treated as text and excluded from numeric aggregations.
Can I summarise date columns?
Date columns are currently treated as text. To summarise by month or quarter, add a Month or Quarter column to your data before uploading.
Is there a row limit?
The tool handles up to 50,000 rows in a modern browser. Performance may degrade beyond that on older hardware.