JSON array grouper
Group JSON records by one or more nested values. Keep every source record and download the grouped result.
At most 10,000 input records and 10 grouping paths. Up to 1,000,000 input characters, 50,000 values per JSON document and 64 nesting levels. Duplicate keys, negative zero and numbers that cannot safely retain their decimal value are rejected. Quote precision-sensitive numbers as strings. Formatting and object member order may change. Processing stays on your device. Each JSON Pointer is limited to 20,000 characters. Paste text to process locally. Review the result before downloading. Results update as you type. Up to 1,000,000 characters.
Your result
How to use JSON array grouper
- Paste a JSON array of records.
- Enter grouping paths as a JSON array and choose how to handle missing fields.
- Review the group and record counts, then download the JSON result and report.
Useful next steps
Group by a field or a combination of fields
Paste a JSON array and choose 1 to 10 JSON Pointer paths, such as ["/country","/address/city"]. Each unique combination becomes a group with its key values, record count and original records. Groups follow first occurrence and records retain their input order.
Keep missing values distinct from null
A missing field gets a separate group by default. Choose Reject record to require all selected paths in every record. Strings, numbers and booleans remain different types. Objects compare by their contents, independent of member order, while array order matters.
Download the full grouped dataset
The output contains keys, count and records for each group, plus a processing report. Paths use ~0 for a literal tilde and ~1 for a slash. An empty pointer selects the whole record. This tool groups records; it does not sum or average their values.