Excel To JSON MCP By WTSolutions

@he-yang

About Excel To JSON MCP By WTSolutions

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 #json #mcp #wtsolutions

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "excel_to_json_by_WTSolutions": {
      "args": [
        "mcp-remote",
        "https://mcp.wtsolutions.cn/excel-to-json-mcp-sse"
      ],
      "command": "npx",
      "tools": [
        "excel_to_json_mcp_from_data",
        "excel_to_json_mcp_from_url"
      ]
    }
  }
}

Tools

Overview

What is Excel To JSON MCP By WTSolutions?

Excel To JSON MCP By WTSolutions provides a standardized interface for converting Excel and CSV data into JSON format using the Model Context Protocol. It offers two tools: one for converting tab-separated or comma-separated text data, and another for converting Excel or CSV files from a provided URL.

How to use Excel To JSON MCP By WTSolutions?

Point your MCP client to the SSE endpoint https://mcp.wtsolutions.cn/excel-to-json-mcp-sse and call the excel_to_json_mcp_from_data tool with a data string (tab- or comma-separated, at least two rows) or the excel_to_json_mcp_from_url tool with a URL to an .xlsx or CSV file. The server automatically detects data types and returns JSON.

Key features of Excel To JSON MCP By WTSolutions

Converts tab-separated or comma-separated text to JSON.
Converts Excel/CSV files from a URL to JSON.
Handles multiple sheets with sheet names and data arrays.
Automatic detection of numbers, booleans, and dates.
Free to use with descriptive error messages.

Use cases of Excel To JSON MCP By WTSolutions

Convert spreadsheet data into JSON for an AI assistant.
Ingest CSV data from a web URL into structured JSON.
Transform tabular data from chat messages into machine-readable format.
Batch process Excel files from remote links programmatically.

FAQ from Excel To JSON MCP By WTSolutions

What data formats are supported?

Input data must be tab-separated or comma-separated text for the from_data tool, or Excel (.xlsx) or CSV files from a URL for the from_url tool.

What are the data requirements?

At least two rows are required: the first row is used as header (JSON keys) and can't contain empty cells; subsequent rows become data (JSON values).

How are data types handled?

Numbers, booleans (case-insensitive ‘true’/‘false’), and dates are automatically detected and converted; empty values become empty strings; everything else is treated as a string.

Is there a cost?

The service is free for now.

What transport does it use?

It uses SSE (Server-Sent Events) at the endpoint https://mcp.wtsolutions.cn/excel-to-json-mcp-sse.

Frequently asked questions

What data formats are supported?

Input data must be tab-separated or comma-separated text for the `from_data` tool, or Excel (.xlsx) or CSV files from a URL for the `from_url` tool.

What are the data requirements?

At least two rows are required: the first row is used as header (JSON keys) and can't contain empty cells; subsequent rows become data (JSON values).

How are data types handled?

Numbers, booleans (case-insensitive ‘true’/‘false’), and dates are automatically detected and converted; empty values become empty strings; everything else is treated as a string.

Is there a cost?

The service is free for now.

What transport does it use?

It uses SSE (Server-Sent Events) at the endpoint `https://mcp.wtsolutions.cn/excel-to-json-mcp-sse`.

Comments

Basic information

More Data & Analytics MCP servers

mcp-simple-arxiv

andybrandt

Tool to work with arXiv, provide LLM with ability to search and read papers from there

199

PowerDMARC

powerdmarc

PowerDMARC's MCP server brings live email authentication data directly into any MCP-compatible AI assistant: Claude, ChatGPT, Cursor, and others. Instead of generic DMARC advice, the AI works from a customer's actual acc

CryptoWhaleInsights

CryptoWhaleInsights Team

Real-time crypto whale tracking & market intelligence. Monitors 80+ verified whale wallets across 14 blockchains (BTC, ETH, SOL, BSC, Base, ARB, MATIC, TON, SUI, HYPE, TRX, SEI, INJ, APT). 55 tools: whale movements, fear

🪐✨ Jupyter MCP Server

datalayer

🪐 🔧 Model Context Protocol (MCP) Server for Jupyter.

1.2K

ArXiv MCP Server

blazickjp

A Model Context Protocol server for searching and analyzing arXiv papers

2.9K