Excel MCP Server

MIT License
212
11
  • Linux
  • Apple

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
LOG_PATHNoLog files storage path. If not set, logs will be stored in the 'logs' folder under the application root directory.logs
CACHE_MAX_AGENoCache expiration time in hours1
LOG_RETENTION_DAYSNoLog retention period in days7
LOG_CLEANUP_INTERVALNoLog cleanup interval in hours24
CACHE_CLEANUP_INTERVALNoCache cleanup interval in hours4

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
analyzeExcelStructure

Get Excel file structure including sheet list and column headers in JSON format

exportExcelStructure

Export Excel file structure (sheets and headers) to a new Excel template file

readSheetNames

Get all sheet names from the Excel file

readDataBySheetName

Get data from a specific sheet in the Excel file

readSheetData

Get data from all sheets in the Excel file

writeDataBySheetName

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

writeSheetData

Create a new Excel file with provided data

clearFileCache

Clear cached data for the specified Excel file

ID: w22e5v9u5s