Elysia Tools Docs
EN
Language
ZHESPTRUFRDEEN
Back to site
Browse tools

Data Analysis

Pivot Table Generator

Generate interactive pivot tables from CSV/JSON data with customizable row, column, and value field configurations

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/pivot-table-generator' \
  -H 'Content-Type: application/json' \
  -d '{"inputData":"Enter your CSV or JSON data...\n\nCSV Example:\nRegion,Product,Sales,Quantity,Date\nNorth,Widget A,1000,50,2024-01-15\nSouth,Widget B,1500,75,2024-01-16\nNorth,Widget A,1200,60,2024-01-17\n\nJSON Example:\n[\n  {\"Region\": \"North\", \"Product\": \"Widget A\", \"Sales\": 1000, \"Quantity\": 50},\n  {\"Region\": \"South\", \"Product\": \"Widget B\", \"Sales\": 1500, \"Quantity\": 75}\n]","dataFormat":"csv","rowFields":"Comma-separated field names (e.g., Region, Category)","columnFields":"Comma-separated field names (e.g., Product, Month)","valueFields":"Comma-separated field names (e.g., Sales, Quantity)","aggregateFunction":"sum","filterConditions":"Enter filter conditions (one per line):\nRegion = North\nSales > 1000\nProduct != Widget C","includeGrandTotals":true,"includePercentages":false,"maxRows":"100","maxColumns":"20"}'

© 2026 Elysia Tools. Developer documentation.

Back to siteBrowse tools

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/pivot-table-generator

Parameters

NameTypeRequiredDescription
inputDatatextareaYes—
dataFormatselectYes—
rowFieldstextNoFields to use as rows in the pivot table. If empty, will use first non-numeric field.
columnFieldstextNoFields to use as columns in the pivot table. If empty, will use remaining fields.
valueFieldstextNoNumeric fields to aggregate. If empty, will auto-detect numeric fields.
aggregateFunctionselectYes—
filterConditionstextareaNoOptional filters to apply before generating pivot table. Format: Field operator value
includeGrandTotalscheckboxNoAdd grand total rows and columns to the pivot table
includePercentagescheckboxNoShow percentages alongside values
maxRowsnumberNoMaximum number of rows to display in the pivot table
maxColumnsnumberNoMaximum number of columns to display in the pivot table

Response format

Text result

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

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-pivot-table-generator": {
      "name": "pivot-table-generator",
      "description": "Generate interactive pivot tables from CSV/JSON data with customizable row, column, and value field configurations",
      "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=pivot-table-generator",
      "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": "pivot-table-generator",
    "arguments": {
  "inputData": "Enter your CSV or JSON data...\n\nCSV Example:\nRegion,Product,Sales,Quantity,Date\nNorth,Widget A,1000,50,2024-01-15\nSouth,Widget B,1500,75,2024-01-16\nNorth,Widget A,1200,60,2024-01-17\n\nJSON Example:\n[\n  {\"Region\": \"North\", \"Product\": \"Widget A\", \"Sales\": 1000, \"Quantity\": 50},\n  {\"Region\": \"South\", \"Product\": \"Widget B\", \"Sales\": 1500, \"Quantity\": 75}\n]",
  "dataFormat": "csv",
  "rowFields": "Comma-separated field names (e.g., Region, Category)",
  "columnFields": "Comma-separated field names (e.g., Product, Month)",
  "valueFields": "Comma-separated field names (e.g., Sales, Quantity)",
  "aggregateFunction": "sum",
  "filterConditions": "Enter filter conditions (one per line):\nRegion = North\nSales > 1000\nProduct != Widget C",
  "includeGrandTotals": true,
  "includePercentages": false,
  "maxRows": "100",
  "maxColumns": "20"
}
  }
}
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).

Questions or issues? Contact [email protected]

Browse tools
Open tool