Aggregation rulesAn array of objects is grouped by the group key (dot path) with a count per group; a numeric field can also be aggregated with sum / avg / min / max, and non-numeric values are skipped with a notice.
JSON array
Load a JSON array
Grouped
Grouped output will appear here
Group by without writing code

JSON Group By

Group by key · count / sum / avg / min / max · local

🔒Processed locally in your browser — never uploaded or stored

No upload, no storage

JSON is processed in memory and never sent to a server.

Share via URL fragment

Share links encode data in the # anchor — never sent to a server.

Remember last edit

Optionally keep your last input locally; clear it with one click.

Why use JSON Group By

Group by any key

Group an object array by any field (dot paths supported) with automatic counts — as intuitive as SQL group by.

Five aggregations

Beyond count, run sum / avg / min / max on a numeric field, toggled freely.

Nested fields work

Both the group key and the aggregate field accept a.b dot paths — no flattening first.

Output stays JSON

Results are a standard JSON array, ready for the table or CSV converters downstream.

Local · no upload

Grouping runs entirely in your browser; data is never uploaded or stored.