Excel MCP Server

Overview InspectNew Endpoints Schema Related Servers Reviews Score

filter_excel

Extract specific data from Excel files using a pandas query string. Specify file path, query conditions, and sheet name to filter and return targeted information for analysis.

Instructions

Filter Excel data using a pandas query string.

Args:
    file_path: Path to the Excel file
    query: Pandas query string (e.g., "Age > 30 and Department == 'Sales'")
    sheet_name: Name of the sheet to filter (for Excel files)
    
Returns:
    Filtered data as string

Input Schema

Name	Required	Description	Default
`file_path`	Yes
`query`	Yes
`sheet_name`	No

Input Schema (JSON Schema)

{
  "properties": {
    "file_path": {
      "title": "File Path",
      "type": "string"
    },
    "query": {
      "title": "Query",
      "type": "string"
    },
    "sheet_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Sheet Name"
    }
  },
  "required": [
    "file_path",
    "query"
  ],
  "title": "filter_excelArguments",
  "type": "object"
}

This server cannot be installed

Other Tools from Excel MCP Server

Related Tools

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/yzfly/mcp-excel-server'

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