Excel to JSON

MCP Server converting Excel and CSV data into JSON

javascript

6

GitHub Stars

javascript

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "he-yang-excel-to-json-mcp": {
      "command": "npx",
      "args": [
        "excel-to-json-mcp"
      ],
      "env": {
        "proCode": "YOUR_PRO_CODE_HERE"
      }
    }
  }
}

You can convert Excel or CSV data into JSON using a dedicated MCP (Model Context Protocol) service. This MCP instance provides two tools: one for converting inline data and another for converting an Excel file from a URL, all through a standardized interface that integrates with MCP clients and pipelines.

How to use

You will connect to the Excel to JSON MCP Service using an MCP client or a compatible wrapper. Choose the tool based on your data source: use excel_to_json_mcp_from_data when you have tab-separated or comma-separated text data, or use excel_to_json_mcp_from_url when you have an online Excel file URL.

How to use with data

To convert inline data, provide a string containing tab-separated values (Excel style) or comma-separated values (CSV style). The first row becomes the header and defines the JSON keys. Subsequent rows are treated as data records.

Optional: you can supply an options object to customize the conversion. If you do not have a Pro Code, pass only the data parameter.

How to use with a URL

To convert data from an online Excel file, provide the file URL pointing to an .xlsx file. Each sheet will be converted into a JSON object with a sheetName and data array.

What you get back

The response includes a JSON structure where each sheet has a name and a list of row objects. Data types are inferred (numbers, booleans, strings, and dates) and empty values are preserved as empty strings unless configured otherwise.

How to install

Prerequisites: you need Node.js and npm or npx installed on your system.

Choose the local npm-based approach described here if you want to run the MCP tool directly from your shell using NPX.

Step-by-step setup for NPX (stdio)

{
  "mcpServers": {
    "excel-to-json-mcp": {
      "args": [
        "excel-to-json-mcp"        
      ],
      "command": "npx",
      "env": {
        "proCode": "YOUR_PRO_CODE_HERE"
      }
    }
  }
}

What to run in your environment

Install prerequisites if needed, then use your MCP client with the provided server configuration. If you have a Pro Code, include it in the environment as shown above to enable custom conversion rules.

Notes on proCode and options

A Pro Code enables customized conversion rules. If you do not have a Pro Code, you can still convert data using the default rules by providing only data or url parameters. The optional options object becomes available when you supply a Pro Code.

Available tools

excel_to_json_mcp_from_data

Converts tab-separated Excel data or comma-separated CSV text data into JSON format. Requires data and optional options for customization.

excel_to_json_mcp_from_url

Converts an Excel (.xlsx) file from a provided URL into JSON format. Requires url and optional options for customization.