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.

API Documentation

Request Endpoint

POST /en/api/tools/csv-data-grouper

Request Parameters

Parameter 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	select	Yes	-
includeHeader	checkbox	No	-
sortGroups	checkbox	No	-
trimValues	checkbox	No	Remove whitespace from beginning and end of cell values

Response Format

{
  "result": "Processed text content",
  "error": "Error message (optional)",
  "message": "Notification message (optional)",
  "metadata": {
    "key": "value"
  }
}

Text: Text

AI MCP Documentation

Add this tool to your MCP server 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://elysiatools.com/mcp/sse?toolId=csv-data-grouper",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

If you encounter any issues, please contact us at [email protected]