Excel to JSON MCP by WTSolutions

中文

Introduction

The Excel to JSON MCP (Model Context Protocol) provides a standardized interface for converting Excel and CSV data into JSON format using the Model Context Protocol. This MCP implementation offers two specific tools for data conversion:

• excel_to_json_mcp_from_data: Converts tab-separated Excel data or comma-separated CSV text data into JSON format.
• excel_to_json_mcp_from_url: Converts Excel file (.xlsx) from a providedURL

Excel to JSON MCP is part of Excel to JSON by WTSolutions:

• Excel to JSON Web App: Convert Excel to JSON directly in Web Browser.
• Excel to JSON Excel Add-in: Convert Excel to JSON in Excel, works with Excel environment seamlessly.
• Excel to JSON API: Convert Excel to JSON by HTTPS POST request.
• <mark>Excel to JSON MCP Service: Convert Excel to JSON by AI Model MCP SSE/StreamableHTTP request.</mark> (<-- You are here.)

Server Config

Available MCP Servers :

Using Stdio(NPX)

Server Config JSON:

{
  "mcpServers": {
    "excel2json": {
      "args": [
        "mcp-remote",
        "https://mcp.wtsolutions.cn/sse",
        "--transport",
        "sse-only"
      ],
      "command": "npx",
      "tools": [
        "excel_to_json_mcp_from_data",
        "excel_to_json_mcp_from_url"
      ]
    }
  }
}

Using SSE

Transport: SSE

URL: https://mcp.wtsolutions.cn/excel-to-json-mcp-sse

Server Config JSON:

{
  "mcpServers": {
    "excel2jsonsse": {
      "type": "sse",
      "url": "https://mcp.wtsolutions.cn/sse"
    }
  }
}

Using Streamable HTTP

Transport: Streamable HTTP

URL: https://mcp.wtsolutions.cn/excel-to-json-mcp-shttp

Server Config JSON:

{
  "mcpServers": {
    "excel2jsonmcp": {
      "type": "streamableHttp",
      "url": "https://mcp.wtsolutions.cn/mcp"
    }
  }
}

MCP Tools

excel_to_json_mcp_from_data

Converts tab-separated Excel data or comma-separated CSV text data into JSON format.

Parameters

Note: Input data must be tab-separated (Excel) or comma-separated (CSV) text with at least two rows (header row + data row).

• The first row will be considered as "header" row, and this MCP will use it as column names, subsequently JSON keys.
• The following rows will be considered as "data" rows, and this MCP will treat them as JSON values.

Example Prompt 1:

Convert the following data into JSON format:

Name	Age	IsStudent
John Doe	25	false
Jane Smith	30	true

Example Prompt 2:

Convert the following data into JSON format:

Name,Age,IsStudent
John Doe,25,false
Jane Smith,30,true

excel_to_json_mcp_from_url

Converts an Excel file from a provided URL into JSON format.

Parameters

Note:

• Each sheet of the Excel file should contain at least two rows (header row + data row).
  1. The first row will be considered as "header" row, and this MCP will use it as column names, subsequently JSON keys.
  2. The following rows will be considered as "data" rows, and this MCP will treat them as JSON values.
• This Excel file should be in '.xlsx' format.
• Each sheet of the Excel file will be converted to a JSON object.
• Each JSON object will have 'sheetName' (string) and 'data' (array of objects) properties.
• Each JSON object in 'data' array will have properties corresponding to column names.
• Each JSON object in 'data' array will have values corresponding to cell values.

Example Prompt 1

Convert Excel file to JSON, file URL: https://tools.wtsolutions.cn/example.xlsx

Example Prompt 2

(applicable only when you do not have a URL and working with online AI LLM)

I've jsut uploaded one .xlsx file to you, please extract its URL and send it to MCP tool 'excel_to_json_mcp_from_url', for Excel to JSON conversion.

Response Format

The MCP tools return a JSON object with the following structure:

Example Success Response

{
  "content": [{
    "type": "text",
    "text": "{\"isError\":false,\"msg\":\"success\",\"data\":\"[{\"Name\":\"John Doe\",\"Age\":25,\"IsStudent\":false},{\"Name\":\"Jane Smith\",\"Age\":30,\"IsStudent\":true}]\"}"
  }]
}

Above is the response from MCP tool, and in most cases your LLM should interpret the response and present you with a JSON object, for example as bel…