read_data_from_excel

Extract structured data from Excel worksheets, including cell values, addresses, and validation rules. Specify file path, sheet name, and cell range. Returns JSON with detailed metadata for analysis or processing.

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": {
      "default": null,
      "title": "End Cell",
      "type": "string"
    },
    "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