read_data_from_excel

Extract structured data from Excel worksheets, including cell values, addresses, and validation rules, in JSON format. Specify filepath, sheet name, and optional cell range for precise data retrieval.

Instructions

Read data from Excel worksheet with cell metadata including validation rules.

Args:
    filepath: Path to Excel file
    sheet_name: Name of worksheet
    start_cell: Starting cell (default A1)
    end_cell: Ending cell (optional, auto-expands if not provided)
    preview_only: Whether to return preview only

Returns:  
JSON string containing structured cell data with validation metadata.
Each cell includes: address, value, row, column, and validation info (if any).

Input Schema

Name	Required	Default
`end_cell`	No
`filepath`	Yes
`preview_only`	No
`sheet_name`	Yes
`start_cell`	No	A1

Input Schema (JSON Schema)

{
  "properties": {
    "end_cell": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "End Cell"
    },
    "filepath": {
      "title": "Filepath",
      "type": "string"
    },
    "preview_only": {
      "default": false,
      "title": "Preview Only",
      "type": "boolean"
    },
    "sheet_name": {
      "title": "Sheet Name",
      "type": "string"
    },
    "start_cell": {
      "default": "A1",
      "title": "Start Cell",
      "type": "string"
    }
  },
  "required": [
    "filepath",
    "sheet_name"
  ],
  "title": "read_data_from_excelArguments",
  "type": "object"
}

Excel MCP Server

read_data_from_excel

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Excel MCP Server

Related Tools

MCP directory API