Exporting Grouped Data

Updated on Feb 9, 2026

The KendoReact Grid CSV export feature supports exporting grouped data with group headers and aggregate footers. When the Grid data is grouped, the export automatically includes group information in a flattened format suitable for CSV.

Basic Grouped Data Export

The following example demonstrates exporting grouped data to CSV. The Grid uses autoProcessData for built-in data processing and groups products by category and discontinued status. When exported, the CSV includes group headers and aggregate values (sum of unit prices per group):

Change Theme

Theme

Loading ...

Export Format

The exported CSV represents the grouped hierarchy in a flat format:

ProductID	ProductName	UnitPrice	...
Group: Category.CategoryName > Discontinued	Beverages: Beverages | Discontinued: false
1	Chai	18.00	...
2	Chang	19.00	...
		sum: 37.00

Nested Groups

The export handles multiple levels of grouping. In the example above, products are first grouped by Category.CategoryName and then by Discontinued status, creating a nested group structure in the exported CSV.

Aggregates

To include aggregates in the export, define them in your GroupDescriptor:

tsx

const aggregates: AggregateDescriptor[] = [{ field: 'UnitPrice', aggregate: 'sum' }];

const group: GroupDescriptor[] = [
    {
        field: 'Category.CategoryName',
        aggregates
    }
];

The supported aggregate functions are:

• sum - Sum of values
• average - Average of values
• count - Count of items
• min - Minimum value
• max - Maximum value

Suggested Links

• CSV Export Basics
• Customizing Exported Columns
• Data Transformation
• Grid Grouping
• API Reference of the Grid