Pivot Table Generator

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

Input Data *

Data Format *

Row Fields (optional)

Fields to use as rows in the pivot table. If empty, will use first non-numeric field.

Column Fields (optional)

Fields to use as columns in the pivot table. If empty, will use remaining fields.

Value Fields (optional)

Numeric fields to aggregate. If empty, will auto-detect numeric fields.

Aggregate Function *

Filter Conditions (optional)

Optional filters to apply before generating pivot table. Format: Field operator value

Include Grand Totals

Add grand total rows and columns to the pivot table

Include Percentages

Show percentages alongside values

Maximum Rows

Maximum number of rows to display in the pivot table

Maximum Columns

Maximum number of columns to display in the pivot table

API Documentation

Request Endpoint

POST /en/api/tools/pivot-table-generator

Request Parameters

Parameter Name	Type	Required	Description
inputData	textarea	Yes	-
dataFormat	select	Yes	-
rowFields	text	No	Fields to use as rows in the pivot table. If empty, will use first non-numeric field.
columnFields	text	No	Fields to use as columns in the pivot table. If empty, will use remaining fields.
valueFields	text	No	Numeric fields to aggregate. If empty, will auto-detect numeric fields.
aggregateFunction	select	Yes	-
filterConditions	textarea	No	Optional filters to apply before generating pivot table. Format: Field operator value
includeGrandTotals	checkbox	No	Add grand total rows and columns to the pivot table
includePercentages	checkbox	No	Show percentages alongside values
maxRows	number	No	Maximum number of rows to display in the pivot table
maxColumns	number	No	Maximum number of columns to display in the pivot table

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-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://elysiatools.com/mcp/sse?toolId=pivot-table-generator",
      "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]