Aggregate JSON Files Online
Group and aggregate JSON files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
About this tool
Group and summarise a JSON file by any column combination. Compute SUM, AVG, MIN, MAX, and COUNT for numeric columns. Download the aggregated result ready for reporting or further analysis — all in your browser.
Frequently Asked Questions
What aggregation functions does the JSON aggregate tool support?
SUM, AVG (mean), MIN, MAX, and COUNT. You can apply multiple functions to the same column and group by any number of columns.
Can I group by multiple columns when aggregating a JSON file?
Yes. Add multiple group-by columns and the aggregations are computed for each unique combination of values across those columns.
What happens to non-numeric columns when aggregating a JSON file?
SUM, AVG, MIN, and MAX apply to numeric columns only. COUNT works on any column type and counts non-null values. Non-aggregated, non-grouped columns must be excluded from the output.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Validate Email Addresses in JSON Files Online
Validate email addresses in JSON files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
Add Moving Average to JSON Files Online
Add a moving average, rolling sum, rolling min, or rolling max column to JSON files directly in your browser. Choose window size, order-by column, and optional partitioning — no upload required.
Search Text in JSON Files Online
Search for text across all string columns in JSON files directly in your browser. Filter rows to only those containing your search term and download the results — no upload required.
Get Top N Rows from JSON Files Online
Extract the top N rows per group from JSON files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.
Add Percent of Total to JSON Files Online
Add a percentage-of-total column to JSON files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.