An MCP server that converts JSON data to CSV format, supporting both direct JSON data strings and JSON files from URLs.

Installation

NPX

npx mcp-remote https://mcp2.wtsolutions.cn/sse --transport sse-only

Configuration

NPX Configuration

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

SSE Configuration

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

Streamable HTTP Configuration

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

Available Tools

Tool	Description
json_to_excel_mcp_from_data	Converts a JSON data string to a CSV format string
json_to_excel_mcp_from_url	Converts a JSON file from a provided URL (.json format) to a CSV format string

Features

• Convert JSON data strings to CSV format
• Convert JSON files from URLs to CSV format
• Automatic data type handling (numbers, booleans, strings, arrays, objects)
• Support for both JSON arrays and individual objects
• CSV headers generated from JSON object keys
• Multiple transport protocols (SSE, Streamable HTTP)

Usage Examples

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"]}

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

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.

Notes

Part of the JSON to Excel toolkit by WTSolutions. Currently free to use. Supports multiple transport protocols, including SSE and Streamable HTTP. Returns a structured response with isError, msg, and data fields. Includes comprehensive error handling for invalid JSON, network errors, and "file not found" scenarios.