Excel MCP Server

MIT License

212

Overview InspectNew Schema Related Servers Reviews Score

writeDataBySheetName

Write data to a specific sheet in an Excel file, overwriting existing content if the sheet is present. Requires file path, sheet name, and data array for accurate execution.

Instructions

Write data to a specific sheet in the Excel file (overwrites if sheet exists)

Input Schema

Name	Required	Description
`data`	Yes	Array of objects to write to the sheet
`fileAbsolutePath`	Yes	The absolute path of the Excel file
`sheetName`	Yes	The name of the sheet to write

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "data": {
      "description": "Array of objects to write to the sheet",
      "items": {
        "additionalProperties": {},
        "type": "object"
      },
      "type": "array"
    },
    "fileAbsolutePath": {
      "description": "The absolute path of the Excel file",
      "type": "string"
    },
    "sheetName": {
      "description": "The name of the sheet to write",
      "type": "string"
    }
  },
  "required": [
    "fileAbsolutePath",
    "sheetName",
    "data"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Other Tools from Excel MCP Server

Related Tools

update_excel
@yzfly/mcp-excel-server
write_excel
@yzfly/mcp-excel-server
readDataBySheetName
@zhiwei5576/excel-mcp-server
writeSheetData
@zhiwei5576/excel-mcp-server
read_excel_by_sheet_index
@softgridinc-pte-ltd/mcp-excel-reader-server
read_excel
@yzfly/mcp-excel-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