中文

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

• json_to_excel_mcp_from_data: Converts JSON data string into CSV format.
• json_to_excel_mcp_from_url: Converts JSON file from a provided URL (.json format) into CSV format string.

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

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

Available MCP Servers (SSE and Streamable HTTP):

Server Config JSON:

{
  "mcpServers": {
    "json_to_excel": {
      "args": [
        "mcp-remote",
        "https://mcp2.wtsolutions.cn/sse",
        "--transport",
        "sse-only"
      ],
      "command": "npx"
    }
  }
}

Transport: SSE

URL: https://mcp2.wtsolutions.cn/sse

Server Config JSON:

{
  "mcpServers": {
    "json2excelsse": {
      "type": "sse",
      "url": "https://mcp2.wtsolutions.cn/sse"
    }
  }
}

Transport: Streamable HTTP

URL: https://mcp2.wtsolutions.cn/mcp

Server Config JSON:

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

Converts JSON data string into CSV format string.

Note:

• Input data must be a valid JSON string. JSON schema available at JSON Schema and validator available at JSON to Excel Web App.
• If the JSON is an array of objects, each object will be treated as a row in the CSV.
• If the JSON is a single object, it will be converted into a CSV with key-value pairs.
• The CSV will include headers based on the keys in the JSON objects.
• This tool returns CSV-formatted data that can be easily converted/imported to Excel.

Convert the following JSON data into CSV format:

[
  {"Name": "John Doe", "Age": 25, "IsStudent": false},
  {"Name": "Jane Smith", "Age": 30, "IsStudent": true}
]

Convert the following JSON object into CSV format:

{
  "Name": "John Doe",
  "Age": 25,
  "IsStudent": false,
  "Courses": ["Math", "Science"]
}

Converts JSON data from a provided URL into Excel data.

Note:

• The url should be publicly accessible.
• The JSON file should be in .json format.
• The JSON file should contain a valid JSON array or object. JSON schema available at JSON Schema and validator available at JSON to Excel Web App.
• If the JSON is an array of objects, each object will be treated as a row in the CSV.
• If the JSON is a single object, it will be converted into a CSV with key-value pairs.
• This tool returns CSV-formatted data that can be easily converted/imported to Excel.

Convert JSON file to Excel, file URL: https://mcp.wtsolutions.cn/example.json

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

I've just uploaded one .json file to you, please extract its URL and send it to MCP tool 'json_to_excel_mcp_from_url', for JSON to Excel conversion.

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

{
  "content": [{
    "type": "text",
    "text": "{\"isError\":false,\"msg\":\"success\",\"data\":\"Name,Age,IsStudent\nJohn Doe,25,false\nJane Smith,30,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 below.

Note, different LLM models may have different ways to interpret the JSON object, so please check if the JSON object is correctly interpreted by your LLM model.

{
  "isError": false,
  "msg": "success",
  "data": "Name,Age,IsStudent\nJohn Doe,25,false\nJane Smith,30,true"
}

{
  "content": [{
    "type": "text",
    "text": "{\"isError\": true, \"msg\": \"Invalid JSON format\", \"data\": \"\"}"
  }]
}

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 below.

Note, different LLM models may have different ways to interpret the JSON object, so please check if the response is correctly interpreted by your LLM model.

{
  "isError": true,
  "msg": "Invalid JSON format",
  "data": ""
}

or it is also possible that your LLM would say "Invalid JSON format, please provide a valid JSON string" to you.

The API automatically handles different data types in JSON:

• Numbers: Converted to numeric values in CSV
• Booleans: Converted to 'true'/'false' strings
• Strings: Escaped and quoted if necessary
• Arrays: Converted to JSON.stringify array string
• Objects: Converted to JSON.stringify object string

The MCP returns descriptive error messages for common issues:

• Invalid JSON format: When input data is not a valid JSON string
• Empty JSON data: When input data is an empty JSON string
• Network Error when fetching file: When there's an error downloading the file from the provided URL
• File not found: When the file at the provided URL cannot be found
• Server Internal Error: When an unexpected error occurs

By using JSON to Excel MCP, you agree to the service agreement, and privacy policy.

Free for now.

https://buymeacoffee.com/wtsolutions