Excel MCP Server

Overview InspectNew Schema Related Servers Reviews Score

filter_excel

Filter Excel data by applying a pandas query string to extract specific rows or columns. Specify the file path, query, and optional sheet name to retrieve filtered results efficiently.

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"
}

You must be authenticated.

Other Tools from Excel MCP Server

Related Tools

readDataBySheetName
@zhiwei5576/excel-mcp-server
read_excel
@ArchimedesCrypto/excel-reader-mcp
read_excel_by_sheet_index
@softgridinc-pte-ltd/mcp-excel-reader-server
read_excel
@yzfly/mcp-excel-server
read_excel_by_sheet_name
@softgridinc-pte-ltd/mcp-excel-reader-server
readSheetNames
@zhiwei5576/excel-mcp-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/yzfly/mcp-excel-server'

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