excel-mcp-server

MIT License

1,007

Overview InspectNew Schema Related Servers Reviews Score

create_pivot_table

Generate pivot tables in Excel worksheets by specifying data range, rows, values, and aggregation function to summarize and analyze data efficiently.

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": {
      "default": null,
      "items": {
        "type": "string"
      },
      "title": "Columns",
      "type": "array"
    },
    "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"
}

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