← excel-mcp-server

excel-mcp-server 0.1.0

npm · @shmaxi/excel-mcp-server · current release

18
Tools
0
Resources
0
Templates
0
Prompts

Observation

Observed 2026-08-22T22:05:49.796Z using mcpSecurity-inventory. Status: succeeded. Negotiated protocol: 2025-06-18.

Server capabilities
{
  "tools": {}
}

Tools 18

ToolCategoryAnnotationsRisk
apply_formulaApply a formula to a cell
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "cell": {
      "type": "string",
      "description": "Cell reference (e.g., \"A1\")"
    },
    "formula": {
      "type": "string",
      "description": "Excel formula (e.g., \"=SUM(A1:A10)\")"
    }
  },
  "required": [
    "file_path",
    "sheet_name",
    "cell",
    "formula"
  ]
}
—— · ——
copy_rangeCopy a range of cells to another location
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "source_sheet": {
      "type": "string",
      "description": "Source worksheet name"
    },
    "source_range": {
      "type": "string",
      "description": "Source range (e.g., \"A1:C10\")"
    },
    "target_sheet": {
      "type": "string",
      "description": "Target worksheet name"
    },
    "target_cell": {
      "type": "string",
      "description": "Target starting cell (e.g., \"E1\")"
    }
  },
  "required": [
    "file_path",
    "source_sheet",
    "source_range",
    "target_sheet",
    "target_cell"
  ]
}
—— · ——
copy_worksheetCopy a worksheet within the same workbook
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "source_sheet": {
      "type": "string",
      "description": "Name of the worksheet to copy"
    },
    "target_sheet": {
      "type": "string",
      "description": "Name for the copied worksheet"
    }
  },
  "required": [
    "file_path",
    "source_sheet",
    "target_sheet"
  ]
}
—— · ——
create_chartCreate a chart in the worksheet
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "chart_type": {
      "type": "string",
      "description": "Type of chart (column, bar, line, pie, area, scatter)",
      "enum": [
        "column",
        "bar",
        "line",
        "pie",
        "area",
        "scatter"
      ]
    },
    "data_range": {
      "type": "string",
      "description": "Data range for the chart (e.g., \"A1:B10\")"
    },
    "position": {
      "type": "object",
      "description": "Chart position",
      "properties": {
        "cell": {
          "type": "string",
          "description": "Top-left cell for the chart"
        },
        "width": {
          "type": "number",
          "description": "Chart width in pixels",
          "default": 600
        },
        "height": {
          "type": "number",
          "description": "Chart height in pixels",
          "default": 400
        }
      },
      "required": [
        "cell"
      ]
    },
    "options": {
      "type": "object",
      "description": "Additional chart options",
      "properties": {
        "title": {
          "type": "string"
        },
        "xAxis": {
          "type": "object",
          "properties": {
            "title": {
              "type": "string"
            }
          }
        },
        "yAxis": {
          "type": "object",
          "properties": {
            "title": {
              "type": "string"
            }
          }
        },
        "legend": {
          "type": "object",
          "properties": {
            "position": {
              "type": "string",
              "enum": [
                "top",
                "bottom",
                "left",
                "right"
              ]
            }
          }
        }
      }
    }
  },
  "required": [
    "file_path",
    "sheet_name",
    "chart_type",
    "data_range",
    "position"
  ]
}
—— · ——
create_pivot_tableCreate a pivot table
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "source_sheet": {
      "type": "string",
      "description": "Source worksheet name"
    },
    "source_range": {
      "type": "string",
      "description": "Source data range"
    },
    "target_sheet": {
      "type": "string",
      "description": "Target worksheet for pivot table"
    },
    "target_cell": {
      "type": "string",
      "description": "Target cell for pivot table",
      "default": "A1"
    },
    "rows": {
      "type": "array",
      "description": "Fields for rows",
      "items": {
        "type": "string"
      }
    },
    "columns": {
      "type": "array",
      "description": "Fields for columns",
      "items": {
        "type": "string"
      }
    },
    "values": {
      "type": "array",
      "description": "Fields for values",
      "items": {
        "type": "object",
        "properties": {
          "field": {
            "type": "string"
          },
          "function": {
            "type": "string",
            "enum": [
              "sum",
              "count",
              "average",
              "min",
              "max"
            ]
          }
        }
      }
    }
  },
  "required": [
    "file_path",
    "source_sheet",
    "source_range",
    "target_sheet"
  ]
}
—— · ——
create_workbookCreate a new Excel workbook
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path where the workbook will be saved"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the initial worksheet",
      "default": "Sheet1"
    }
  },
  "required": [
    "file_path"
  ]
}
—— · ——
create_worksheetCreate a new worksheet in an existing workbook
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name for the new worksheet"
    }
  },
  "required": [
    "file_path",
    "sheet_name"
  ]
}
—— · ——
delete_rangeDelete a range of cells
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Worksheet name"
    },
    "range": {
      "type": "string",
      "description": "Range to delete (e.g., \"A1:C10\")"
    },
    "shift": {
      "type": "string",
      "description": "Shift direction after deletion",
      "enum": [
        "up",
        "left",
        "none"
      ],
      "default": "none"
    }
  },
  "required": [
    "file_path",
    "sheet_name",
    "range"
  ]
}
—— · ——
delete_worksheetDelete a worksheet from a workbook
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet to delete"
    }
  },
  "required": [
    "file_path",
    "sheet_name"
  ]
}
—— · ——
format_rangeApply formatting to a range of cells
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "range": {
      "type": "string",
      "description": "Cell range to format (e.g., \"A1:D10\")"
    },
    "format": {
      "type": "object",
      "description": "Formatting options",
      "properties": {
        "font": {
          "type": "object",
          "properties": {
            "name": {
              "type": "string"
            },
            "size": {
              "type": "number"
            },
            "bold": {
              "type": "boolean"
            },
            "italic": {
              "type": "boolean"
            },
            "underline": {
              "type": "boolean"
            },
            "color": {
              "type": "string"
            }
          }
        },
        "fill": {
          "type": "object",
          "properties": {
            "type": {
              "type": "string"
            },
            "pattern": {
              "type": "string"
            },
            "color": {
              "type": "string"
            },
            "bgColor": {
              "type": "string"
            }
          }
        },
        "alignment": {
          "type": "object",
          "properties": {
            "horizontal": {
              "type": "string"
            },
            "vertical": {
              "type": "string"
            },
            "wrapText": {
              "type": "boolean"
            }
          }
        },
        "border": {
          "type": "object"
        },
        "numFmt": {
          "type": "string"
        }
      }
    }
  },
  "required": [
    "file_path",
    "sheet_name",
    "range",
    "format"
  ]
}
—— · ——
get_workbook_metadataGet metadata about an Excel workbook
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    }
  },
  "required": [
    "file_path"
  ]
}
—— · ——
merge_cellsMerge a range of cells
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "range": {
      "type": "string",
      "description": "Cell range to merge (e.g., \"A1:D1\")"
    }
  },
  "required": [
    "file_path",
    "sheet_name",
    "range"
  ]
}
—— · ——
read_data_from_excelRead data from an Excel worksheet
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "range": {
      "type": "string",
      "description": "Cell range to read (e.g., \"A1:D10\")"
    }
  },
  "required": [
    "file_path",
    "sheet_name"
  ]
}
—— · ——
rename_worksheetRename a worksheet
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "old_name": {
      "type": "string",
      "description": "Current name of the worksheet"
    },
    "new_name": {
      "type": "string",
      "description": "New name for the worksheet"
    }
  },
  "required": [
    "file_path",
    "old_name",
    "new_name"
  ]
}
—— · ——
unmerge_cellsUnmerge previously merged cells
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "range": {
      "type": "string",
      "description": "Cell range to unmerge (e.g., \"A1:D1\")"
    }
  },
  "required": [
    "file_path",
    "sheet_name",
    "range"
  ]
}
—— · ——
validate_excel_rangeValidate if a range reference is valid
Input schema
{
  "type": "object",
  "properties": {
    "range": {
      "type": "string",
      "description": "Excel range to validate (e.g., \"A1:C10\")"
    }
  },
  "required": [
    "range"
  ]
}
—— · ——
validate_formula_syntaxValidate Excel formula syntax
Input schema
{
  "type": "object",
  "properties": {
    "formula": {
      "type": "string",
      "description": "Excel formula to validate"
    }
  },
  "required": [
    "formula"
  ]
}
—— · ——
write_data_to_excelWrite data to an Excel worksheet
Input schema
{
  "type": "object",
  "properties": {
    "file_path": {
      "type": "string",
      "description": "Path to the Excel file"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet"
    },
    "data": {
      "type": "array",
      "description": "Array of arrays representing rows of data",
      "items": {
        "type": "array"
      }
    },
    "start_cell": {
      "type": "string",
      "description": "Starting cell (e.g., \"A1\")",
      "default": "A1"
    }
  },
  "required": [
    "file_path",
    "sheet_name",
    "data"
  ]
}
—— · ——

Resources 0

Resource templates 0

Prompts 0

Let’s talk about MCP security.

Share your details and our security team will contact you.