Excel MCP Server

Overview InspectNew Schema Related Servers Reviews Score

analyze_excel

Analyze numeric data in Excel files to generate statistical insights. Specify file path, columns, and sheet name for targeted analysis. Returns JSON with detailed results.

Instructions

Perform statistical analysis on Excel data.

Args:
    file_path: Path to the Excel file
    columns: Comma-separated list of columns to analyze (analyzes all numeric columns if None)
    sheet_name: Name of the sheet to analyze (for Excel files)
    
Returns:
    JSON string with statistical analysis

Input Schema

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

Input Schema (JSON Schema)

{
  "properties": {
    "columns": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Columns"
    },
    "file_path": {
      "title": "File Path",
      "type": "string"
    },
    "sheet_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Sheet Name"
    }
  },
  "required": [
    "file_path"
  ],
  "title": "analyze_excelArguments",
  "type": "object"
}

You must be authenticated.

Other Tools from Excel MCP Server

Related Tools

analyzeExcelStructure
@zhiwei5576/excel-mcp-server
read_excel
@softgridinc-pte-ltd/mcp-excel-reader-server
excel_read
@cablate/mcp-doc-forge
readDataBySheetName
@zhiwei5576/excel-mcp-server
data_summary
@yzfly/mcp-excel-server

ID: vda5rccucp