Data Processing
CSV Data Grouper
Group CSV data by specified columns with aggregation options. Perfect for summarizing and analyzing large datasets by categories, dates, or other criteria.
text· Text resultOpen tool
Quick start
Call this tool from your code in three languages.
cURL
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}'API reference
Send a POST request with your inputs as JSON. File parameters require a separate upload first.
Endpoint
HTTP
POST https://api.elysiatools.com/en/api/tools/csv-data-grouperParameters
| 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 |
MCP integration
Add this tool to your Model Context Protocol server so AI agents can list and call it.
Server configuration
Add this block to your MCP client configuration:
mcp.json
{
"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"
}
}
}List available tools
After connecting to the SSE endpoint, list the exposed tools:
tools/list
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/list"
}Call this tool
Invoke the tool by its id, passing arguments built from its parameters:
tools/call
{
"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
}
}
}Chain multiple tools in one session with a comma-separated toolId list, e.g. /mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp (max 20).