What JSON grouping is
Organize object records by shared field values
JSON grouping collects records whose selected field values match exactly. Choose one field for a simple group-by or combine several fields to explore more specific segments. UtilityDock preserves source order and performs every comparison locally.
Data exploration workflows
Understand how records are distributed
Group a dataset by status, category, owner, region, or a combination of fields to see its natural segments. Expand any group to inspect complete source records without writing a query or uploading sensitive data.
- Review records by workflow status
- Inspect customers by region and plan
- Organize events by type and date
- Find the largest and smallest segments
- Separate missing and null field states
- Create structured grouped fixtures
Analytics preparation
Inspect segments before aggregation or reporting
Group counts reveal how records are distributed before they enter a spreadsheet, notebook, or analytics system. The output keeps each group's values, count, and full records together for predictable downstream processing.
API response analysis
Explore large response arrays without a database
Saved API responses often contain arrays that are difficult to scan. Group objects by endpoint status, resource type, account, or another top-level field to understand the response while keeping every payload on your device.
Missing and null values
Keep absent and explicit values distinct
Records missing a selected field form a missing-value group. Records with that field set to null form a separate null group. Empty strings, zero, andfalse remain ordinary exact values.
Examples
Choose fields that answer the question
| Question | Group fields |
|---|---|
| How many records have each status? | status |
| How are accounts distributed? | region + plan |
| Which event types occur each day? | date + eventType |
| Which records lack ownership? | owner, then inspect Missing |
Data Toolkit
Continue with related UtilityDock JSON workflows
FAQ
Questions about grouping JSON arrays
Does UtilityDock upload or store my JSON?
No. Your files never leave your computer. Validation, field detection, grouping, preview, copying, and download creation all happen locally inside your browser.
What JSON shape can I group?
Version 1 accepts a non-empty array of JSON objects at the document root. You can group by one or more detected top-level fields.
How does grouping by multiple fields work?
Each unique combination of selected field values becomes a group. Records belong together only when every selected field has the same exact JSON value and presence state.
How are missing and null values handled?
Missing and null are distinct. Records missing the same selected field group together, while null groups with null. A missing field does not join a field explicitly set to null.
Does object property order affect a group?
No. When a selected field contains an object, properties are compared by value rather than property order. Array order remains meaningful.
What is included in downloaded grouped JSON?
Each group includes its present group values, any missing field names, its record count, and the complete source records assigned to that group.
Can this tool calculate sums or averages?
No. Version 1 organizes records into groups and reports counts only. It does not support aggregations, pivots, charts, SQL expressions, or APIs.