Excel MCP Server

MIT License

2,133

Overview InspectNew Endpoints Schema Related Servers Reviews Score

create_pivot_table

Generate pivot tables in Excel worksheets to organize, summarize, and analyze large datasets by specifying rows, columns, values, and aggregation functions.

Instructions

Create pivot table in worksheet.

Input Schema

Name	Required	Default
`agg_func`	No	mean
`columns`	No
`data_range`	Yes
`filepath`	Yes
`rows`	Yes
`sheet_name`	Yes
`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"
    },
    "rows": {
      "items": {
        "type": "string"
      },
      "title": "Rows",
      "type": "array"
    },
    "sheet_name": {
      "title": "Sheet Name",
      "type": "string"
    },
    "values": {
      "items": {
        "type": "string"
      },
      "title": "Values",
      "type": "array"
    }
  },
  "required": [
    "filepath",
    "sheet_name",
    "data_range",
    "rows",
    "values"
  ],
  "title": "create_pivot_tableArguments",
  "type": "object"
}

This server cannot be installed

Related Tools

create_pivot_table
@hyunjae-labs/xlwings-mcp-server
pivot_table
@yzfly/mcp-excel-server
create_chart
@haris-musa/excel-mcp-server
create_chart
@hyunjae-labs/xlwings-mcp-server
writeSheetData
@zhiwei5576/excel-mcp-server
data_summary
@yzfly/mcp-excel-server

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/haris-musa/excel-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server