create_pivot_table

Generate pivot tables in Excel by specifying source data, row/column labels, values, and aggregation functions. Automate data summarization and analysis for improved insights directly within your worksheets.

Instructions

Create pivot table in worksheet.

Args:
    filepath: Path to Excel file
    sheet_name: Name of worksheet containing source data
    data_range: Source data range (e.g., "A1:E100" or "Sheet2!A1:E100")
    rows: Field names for row labels
    values: Field names for values
    columns: Field names for column labels (optional)
    agg_func: Aggregation function (sum, count, average, max, min)
    target_sheet: Target sheet for pivot table (optional, auto-created if not exists)
    target_cell: Target cell for pivot table (optional, finds empty area if not provided)
    pivot_name: Custom name for pivot table (optional, auto-generated if not provided)

Input Schema

Name	Required	Default
`agg_func`	No	mean
`columns`	No
`data_range`	Yes
`filepath`	Yes
`pivot_name`	No
`rows`	Yes
`sheet_name`	Yes
`target_cell`	No
`target_sheet`	No
`values`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "agg_func": {
      "default": "mean",
      "title": "Agg Func",
      "type": "string"
    },
    "columns": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Columns"
    },
    "data_range": {
      "title": "Data Range",
      "type": "string"
    },
    "filepath": {
      "title": "Filepath",
      "type": "string"
    },
    "pivot_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Pivot Name"
    },
    "rows": {
      "items": {
        "type": "string"
      },
      "title": "Rows",
      "type": "array"
    },
    "sheet_name": {
      "title": "Sheet Name",
      "type": "string"
    },
    "target_cell": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Target Cell"
    },
    "target_sheet": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Target Sheet"
    },
    "values": {
      "items": {
        "type": "string"
      },
      "title": "Values",
      "type": "array"
    }
  },
  "required": [
    "filepath",
    "sheet_name",
    "data_range",
    "rows",
    "values"
  ],
  "title": "create_pivot_tableArguments",
  "type": "object"
}

xlwings Excel MCP Server

create_pivot_table

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from xlwings Excel MCP Server

Related Tools

MCP directory API