excel-to-json-mcp

Excel To Json MCP Server

Excel and CSV conversion is the focus of excel-to-json-mcp, with tools for delimited text and files supplied by URL. It serves users who need spreadsheet rows represented as JSON through MCP.

Server facts

excel-to-json-mcp

Project

Author
he-yang
License
Not specified

Tech

Runtime / language
Not specified
Transports
stdio
Remote available
No
Authentication
Not specified

Activity

GitHub stars
8
Last commit
Data as of

Tags

  • Excel
  • json
  • mcp
  • wtsolutions

Overview

Spreadsheet rows become JSON records through two distinct input paths in excel-to-json-mcp. The excel_to_json_mcp_from_data tool accepts text whose columns are separated by commas or tabs, while excel_to_json_mcp_from_url takes a URL for an .xlsx workbook or CSV file. Direct text input needs at least 2 rows, and the same minimum applies to each workbook sheet: a header followed by data. Headers supply the JSON property names, with subsequent rows providing their values. For workbook conversion, results retain sheet names alongside arrays of records, preserving the distinction between sheets.

Conversion includes value handling rather than treating every cell as text. Numeric values become numbers, true and false are recognized without regard to letter case, supported date formats are detected and converted, and empty values become empty strings. Responses include an error indicator, a status or explanatory message, and the conversion result. Documented failures cover unsuitable input formatting, insufficient rows, blank headers, simultaneous data and URL parameters, file retrieval problems, missing files, and internal errors. These paths support users working either from delimited text or from a remotely available spreadsheet.

excel-to-json-mcp setup notes

  • excel-to-json-mcp records stdio only; confirm a network transport upstream before planning remote access.
  • excel-to-json-mcp has no recorded license; confirm reuse terms in its repository.

Related MCP servers