Data Processing
Group CSV data by specified columns with aggregation options. Perfect for summarizing and analyzing large datasets by categories, dates, or other criteria.
Call this tool from your code in three languages.
curl -X POST 'https://api.elysiatools.com/en/api/tools/csv-data-grouper' \
-H 'Content-Type: application/json' \
-d '{"csvInput":"Enter your CSV data (first row should contain headers)...","delimiter":",","groupByColumns":"Enter column names separated by commas (e.g., \"Category,Year\")","aggregationOptions":"[{\"column\": \"\", \"function\": \"count\"}]","outputFormat":"csv","includeHeader":true,"sortGroups":true,"trimValues":true}'Send a POST request with your inputs as JSON. File parameters require a separate upload first.
POST https://api.elysiatools.com/en/api/tools/csv-data-grouper| Name | Type | Required | Description |
|---|---|---|---|
| csvInput | textarea | Yes | — |
| delimiter | select | Yes | — |
| groupByColumns | text | Yes | Columns to group data by. Multiple columns will create nested groups. |
| aggregationOptions | textarea | No | JSON format: [{"column": "Amount", "function": "sum", "as": "Total_Amount"}] Simple format: Amount:sum,Name:count Default: Count records per group Available functions: count, sum, avg/average, min, max, first, last, join, unique, count_unique |
| outputFormat |
Add this tool to your Model Context Protocol server so AI agents can list and call it.
Add this block to your MCP client configuration:
{
"mcpServers": {
"elysiatools-csv-data-grouper": {
"name": "csv-data-grouper",
"description": "Group CSV data by specified columns with aggregation options. Perfect for summarizing and analyzing large datasets by categories, dates, or other criteria.",
"baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=csv-data-grouper",
"command": "",
"args": [],
"env": {},
"isActive": true,
"type": "sse"
}
}
}After connecting to the SSE endpoint, list the exposed tools:
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/list"
}Invoke the tool by its id, passing arguments built from its parameters:
{
"jsonrpc": "2.0",
"id": 2,
"method": "tools/call",
"params": {
"name": "csv-data-grouper",
"arguments": {
"csvInput": "Enter your CSV data (first row should contain headers)...",
"delimiter": ",",
"groupByColumns": "Enter column names separated by commas (e.g., \"Category,Year\")",
"aggregationOptions": "[{\"column\": \"\", \"function\": \"count\"}]",
"outputFormat": "csv",
"includeHeader": true,
"sortGroups": true,
"trimValues": true
}
}
}| select |
| Yes |
| — |
| includeHeader | checkbox | No | — |
| sortGroups | checkbox | No | — |
| trimValues | checkbox | No | Remove whitespace from beginning and end of cell values |
Text result
{
"result": "Processed text content",
"error": "Error message (optional)",
"message": "Notification message (optional)",
"metadata": {
"key": "value"
}
}Questions or issues? Contact [email protected]