Excel MCP Server

MIT License

212

Overview InspectNew Schema Related Servers Reviews Score

readDataBySheetName

Extract data from a specified sheet in an Excel file by providing the file path, sheet name, and optional row configurations. Ideal for structured data retrieval and analysis.

Instructions

Get data from a specific sheet in the Excel file

Input Schema

Name	Required	Description
`dataStartRow`	No	The row number to start reading data from (default: 2)
`fileAbsolutePath`	Yes	The absolute path of the Excel file
`headerRow`	No	tThe row number to use as field names (default: 1)
`sheetName`	Yes	tThe name of the sheet to read

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "dataStartRow": {
      "default": 2,
      "description": "The row number to start reading data from (default: 2)",
      "type": "number"
    },
    "fileAbsolutePath": {
      "description": "The absolute path of the Excel file",
      "type": "string"
    },
    "headerRow": {
      "default": 1,
      "description": "tThe row number to use as field names (default: 1)",
      "type": "number"
    },
    "sheetName": {
      "description": "tThe name of the sheet to read",
      "type": "string"
    }
  },
  "required": [
    "fileAbsolutePath",
    "sheetName"
  ],
  "type": "object"
}

You must be authenticated.

Other Tools from Excel MCP Server

Related Tools

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
analyzeExcelStructure
@zhiwei5576/excel-mcp-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/zhiwei5576/excel-mcp-server'

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