mysheet MCP Server

What is mysheet MCP Server?

mysheet MCP Server is a Model Context Protocol server that converts Excel files into JSON format, with optional automatic uploading of embedded files to Tencent Cloud COS (Object Storage). It is designed for data processing within large language models or AI agents.

How to use mysheet MCP Server?

Install Java 21+ and Maven 3.6+, configure Tencent Cloud COS credentials and storage paths in application.yml, then start the server via ./mvnw spring-boot:run. The server exposes MCP tools (excel2Json, openFile, foreach, reset) that an AI agent can invoke to parse Excel files, manage sessions, and retrieve JSON data.

Key features of mysheet MCP Server

• Converts Excel files to JSON with detailed cell type information (text, number, money, date, file, boolean)
• Supports "row-object" parsing mode where each row becomes a JSON object
• Automatically uploads embedded files to Tencent Cloud COS and replaces local paths with COS URLs
• Uses Java 21 virtual threads for concurrent file uploads, boosting performance on large files
• Provides session management (openFile, foreach, reset) for reading large Excel files in batches
• Implements an MD5‑based cache to avoid re‑parsing identical files; cached data expires after 24 hours

Use cases of mysheet MCP Server

• Extracting structured data from Excel spreadsheets for LLM ingestion
• Processing Excel files that contain embedded images, documents, or other attachments stored on COS
• Handling large Excel files by reading rows in chunks through session‑based cursors
• Automating batch Excel‑to‑JSON conversion in AI agent workflows