read_xlsx

read_xlsx

Extract and convert Excel (xlsx) file data into JSON, CSV, or table formats. Specify sheet names, cell ranges, and search parameters for precise data retrieval.

Instructions

Read and extract data from Excel (xlsx) files. Supports reading specific sheets, cell ranges, and converting data to various formats.

Input Schema

Name	Required	Description
`filePath`	Yes	Path to the Excel file to read
`format`	No	Output format for the data (default: table)
`includeHeaders`	No	Whether to include headers in the output (default: true)
`maxRows`	No	Maximum number of rows to return (default: 100, max: 1000)
`range`	No	Cell range to read (e.g., 'A1:C10', optional, defaults to entire sheet)
`searchColumn`	No	Column name or index to search in (e.g., 'A', '1', or 'Name')
`searchType`	No	Type of search to perform (default: exact)
`searchValue`	No	Value to search for in the specified column
`sheetName`	No	Name of the specific sheet to read (optional, defaults to first sheet)

Input Schema (JSON Schema)

{
  "properties": {
    "filePath": {
      "description": "Path to the Excel file to read",
      "type": "string"
    },
    "format": {
      "description": "Output format for the data (default: table)",
      "enum": [
        "json",
        "csv",
        "table"
      ],
      "type": "string"
    },
    "includeHeaders": {
      "description": "Whether to include headers in the output (default: true)",
      "type": "boolean"
    },
    "maxRows": {
      "description": "Maximum number of rows to return (default: 100, max: 1000)",
      "type": "number"
    },
    "range": {
      "description": "Cell range to read (e.g., 'A1:C10', optional, defaults to entire sheet)",
      "type": "string"
    },
    "searchColumn": {
      "description": "Column name or index to search in (e.g., 'A', '1', or 'Name')",
      "type": "string"
    },
    "searchType": {
      "description": "Type of search to perform (default: exact)",
      "enum": [
        "exact",
        "contains",
        "startsWith",
        "endsWith"
      ],
      "type": "string"
    },
    "searchValue": {
      "description": "Value to search for in the specified column",
      "type": "string"
    },
    "sheetName": {
      "description": "Name of the specific sheet to read (optional, defaults to first sheet)",
      "type": "string"
    }
  },
  "required": [
    "filePath"
  ],
  "type": "object"
}

XLSX Reader MCP

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from XLSX Reader MCP

Related Tools

MCP directory API