Group By
Group JSON array rows by the value of a column. Everything runs on your device — nothing is sent to a server.
The result will appear here…
or press Ctrl+Enter
Everything runs in your browser. Your data is never sent to our servers.
728 × 90Ad Space AvailablePlace your ad here
Example
Example Input
[{"city":"A"},{"city":"B"},{"city":"A"}] (city)Example Output
{"A":[{"city":"A"},{"city":"A"}],"B":[{"city":"B"}]}How to Use
- 1Paste your data into the Input field.
- 2If the tool has "More settings" (mode, query, columns, etc.), set them as needed.
- 3Click the button (or press Ctrl+Enter) to process.
- 4Copy the result with the Copy button.
About Group By
Group By groups a JSON array of objects by a specific column value, producing an object where each key is a group value and its value is the list of rows.
Similar to GROUP BY in SQL. It is useful for summarizing data per category — e.g. grouping orders by status or users by country.
Processed in the browser. To order within groups, combine it with Sort Dataset.
FAQ
Is my data sent to a server?
No. Group By runs entirely in your browser using client-side libraries. Your data never leaves your device.