Overview
The Excel to JSON MCP by WTSolutions provides a standardized Model Context Protocol interface to transform spreadsheet data into JSON. It exposes two tools: excel_to_json_mcp_from_data, which converts tab-separated Excel data or comma-separated CSV text into JSON using the first row as headers; and excel_to_json_mcp_from_url, which fetches an XLSX file from a URL and converts each sheet into a JSON object with sheetName and data. Each sheet is processed independently; the first row supplies the keys, and subsequent rows become JSON records. The MCP automatically detects data types (numbers, booleans, dates) and treats empty cells as empty strings. The service returns a uniform response format with isError, msg, and data. Supported deployments include NPX-based stdio, SSE at a given URL, and Streamable HTTP. Error messages cover common issues such as invalid data format, insufficient rows, missing header cells, or file not found. This MCP is part of the broader Excel to JSON suite (web app, Excel add-in, API) and is available free for now.
Features
excel_to_json_mcp_from_data
Converts tab-separated (Excel) or comma-separated (CSV) text data into JSON, using the first row as headers.
excel_to_json_mcp_from_url
Converts an Excel (.xlsx) file fetched from a URL into JSON; each sheet becomes a separate object with sheetName and data.
Sheet-level JSON output
Each sheet in the Excel file becomes a JSON object containing sheetName and a data array.
Automatic data type handling
Detects numbers, booleans, dates, and strings; empty values become empty strings.
Header-based key mapping
Uses the first row as JSON keys; header cells must be non-empty.
Input validation
Requires at least two rows (header + data).
Standard MCP response format
Returns a consistent JSON response with isError, msg, and data fields.
Multiple transport deployments
Supports NPX stdio, SSE, and Streamable HTTP deployment modes.
Who Is This For?
- Developers:Integrate Excel/CSV to JSON conversion via MCP into apps and workflows.
