Data Tools

Data Grouper

Group and organize data by multiple fields with nested grouping and summary statistics

Input data (JSON array)

Upload

Grouping rules

Field name

Include count

Summary field (optional)

Grouped result

Output will appear here...

Example input

[
  { "category": "Electronics", "brand": "Apple", "product": "iPhone", "price": 999.99, "sales": 150 },
  { "category": "Electronics", "brand": "Samsung", "product": "Galaxy", "price": 899.99, "sales": 120 },
  { "category": "Books", "brand": "O'Reilly", "product": "JavaScript Guide", "price": 49.99, "sales": 75 }
]

Group by category, then by brand
Include count at each level
Add summary statistics for price and sales