Excel to JSON MCP by WTSolutions

中文

Introduction

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_to_json_mcp_from_data: Converts tab-separated Excel data or comma-separated CSV text data into JSON format.
• excel_to_json_mcp_from_url: Converts Excel file (.xlsx) from a providedURL

Excel to JSON MCP is part of Excel to JSON by WTSolutions:

• Excel to JSON Web App: Convert Excel to JSON directly in Web Browser.
• Excel to JSON Excel Add-in: Convert Excel to JSON in Excel, works with Excel environment seamlessly.
• Excel to JSON WPS Add-in: Convert Excel to JSON in WPS, works with WPS environment seamlessly.
• Excel to JSON API: Convert Excel to JSON by HTTPS POST request.
• Excel to JSON MCP Service: Convert Excel to JSON by AI Model MCP SSE/StreamableHTTP request. (<-- You are here.)

Server Config

Available MCP Servers :

Using Stdio(NPX)

Server Config JSON:

Case 1 : Free Version

If you are using the free version:

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

Case 2 : Pro Version

If you are using the pro version (with a valid proCode):

{
  "mcpServers": {
    "excel-to-json-mcp": {
      "args": [
        "excel-to-json-mcp"        
      ],
      "command": "npx",
      "env": {
        "proCode": "type in your proCode here"
      }
    }
  }
}

Using SSE

Not supported since v1.3.0

Using Streamable HTTP

Not supported since v1.3.0

MCP Tools

excel_to_json_mcp_from_data

Converts tab-separated Excel data or comma-separated CSV text data into JSON format.

Parameters

| Parameter | Type | Required | Description | |-----------|--------|----------|-----------------------------------------------------------------------------| | data | string | Yes | Tab-separated or comma-separated text data with at least two rows (header row + data row) | | options | object | No | Optional configuration object for customizing the conversion process. If you do not have a Pro Code, please pass only data parameter but not options parameter. |

Note: Input data must be tab-separated (Excel) or comma-separated (CSV) text with at least two rows (header row + data row).

• The first row will be considered as "header" row, and this MCP will use it as column names, subsequently JSON keys.
• The following rows will be considered as "data" rows, and this MCP will treat them as JSON values.

Example Prompt 1:

Convert the following data into JSON format:

Name	Age	IsStudent
John Doe	25	false
Jane Smith	30	true

Example Prompt 2:

Convert the following data into JSON format:

Name,Age,IsStudent
John Doe,25,false
Jane Smith,30,true

excel_to_json_mcp_from_url

Converts an Excel file from a provided URL into JSON format.

Parameters

| Parameter | Type | Required | Description | |-----------|--------|----------|--------------------------------------------------| | url | string | Yes | URL pointing to an Excel (.xlsx) | | options | object | No | Optional configuration object for customizing the conversion process. If you do not have a Pro Code, please pass only url parameter but not options parameter. |

Note:

• Each sheet of the Excel file should contain at least two rows (header row + data row).
  1. The first row will be considered as "header" row, and this MCP will use it as column names, subsequently JSON keys.
  2. The following rows will be considered as "data" rows, and this MCP will treat them as JSON values.
• This Excel file should be in '.xlsx' format.
• Each sheet of the Excel file will be converted to a JSON object.
• Each JSON object will have 'sheetName' (string) and 'data' (array of objects) properties.
• Each JSON object in 'data' array will have properties corresponding to column names.
• Each JSON object in 'data' array will have values corresponding to cell values.

Example Prompt 1

Convert Excel file to JSON, file URL: https://tools.wtsolutions.cn/example.xlsx

Example Prompt 2

(applicable only when you do not have a URL and working with online AI LLM)

I've jsut uploaded one .xlsx file to you, please extract its URL and send it to MCP tool 'excel_to_json_mcp_from_url', for Excel to JSON conversion.

Options Object

If you do not have a Pro Code, you can still use this MCP tool by passing only data or url parameter. However, please note that the conversion rules will be limited to the default ones as listed in the "Default" column in the following table.

The optional options object can contain the following properties for customizing the conversion process. This feature requires a valid Pro Code (Excel to JSON, JSON to Excel by WTSolutions Subscription), see Pricing.

| Property | Type | Default | Description | |----------------------|--------|-----------|-----------------------------------------------------------------------------| | proCode | string | "" | Pro Code for custom conversion rules which requires a valid subscription to Excel to JSON service. | | jsonMode | string | "flat" | Format mode for JSON output: "nested" or "flat" | | header | string | "row" | Specifies which row/column to use as headers: "row" (first row) or "column" (first column) | | delimiter | string | "." | Delimiter character for nested JSON keys when using jsonMode: "nested", acceptable delimiters are ".", "_", "__", "/". | | emptyCell | string | "emptyString" | Handling of empty cells: "emptyString", "null", or "exclude" | | booleanFormat | string | "trueFalse" | Format for boolean values: "trueFalse", "10", or "string" | | jsonFormat | string | "arrayOfObject" | Overall JSON output format: "arrayOfObject" or "2DArray" | | singleObjectFormat | string | "array" | Format when result has only one object: "array" (keep as array) or "object" (return as single object) |

Note:

• delimiter works only when jsonMode is "nested".
• singleObjectFormat works only when jsonFormat is "arrayOfObject".
• jsonFormat as "2DArray" works only when jsonMode is "flat".
• proCode is mandatory if you use any other options.

Response Format

The MCP tools return a JSON object with the following structure:

| Field | Type | Description | |----------|---------|-------------------------------------------------------------------------------------------------------------------------------------------| | isError | boolean | Indicates if there was an error processing the request | | msg | string | 'success' or error description | | data | string | Converted data as array of sheet objects if using URL, string if using direct data, '' if there was an error. Each sheet object contains 'sheetName' (string) and 'data' (array of objects) if using URL |

Example Success Response

{
  "content": [{
    "type": "text",
    "text": "{\"isError\":false,\"msg\":\"success\",\"data\":\"[{\"Name\":\"John Doe\",\"Age\":25,\"IsStudent\":false},{\"Name\":\"Jane Smith\",\"Age\":30,\"IsStudent\":true}]\"}"
  }]
}

Above is the response from MCP tool, and in most cases your LLM should interpret the response and present you with a JSON object, for example as below.

Note, different LLM models may have different ways to interpret the JSON object, so please check if the JSON object is correctly interpreted by your LLM model.

{
  "isError": false,
  "msg": "success",
  "data": "[{\"Name\":\"John Doe\",\"Age\":25,\"IsStudent\":false},{\"Name\":\"Jane Smith\",\"Age\":30,\"IsStudent\":true}]"
}

{
  "isError": false,
  "msg": "success",
  "data": [
    {
      "Name": "John Doe",
      "Age": 25,
      "IsStudent": false
    },
    {
      "Name": "Jane Smith",
      "Age": 30,
      "IsStudent": true
    }
  ]
}

[
  {
    "Name": "John Doe",
    "Age": 25,
    "IsStudent": false
  },
  {
    "Name": "Jane Smith",
    "Age": 30,
    "IsStudent": true
  }
]

Example Failed Response

{
  "content": [{
    "type": "text",
    "text": "{\"isError\": true, \"msg\": \"Network Error when fetching file\", \"data\": \"\"}"
  }]
}

Above is the response from MCP tool, and in most cases your LLM should interpret the response and present you with a JSON object, for example as below.

Note, different LLM models may have different ways to interpret the JSON object, so please check if the response is correctly interpreted by your LLM model.

{
  "isError": true,
  "msg": "Network Error when fetching file",
  "data": ""
}

or it is also possbile that your LLM would say "Network Error when fetching file, try again later" to you.

Data Type Handling

The API automatically detects and converts different data types:

• Numbers: Converted to numeric values
• Booleans: Recognizes 'true'/'false' (case-insensitive) and converts to boolean values
• Dates: Detects various date formats and converts them appropriately
• Strings: Treated as string values
• Empty values: Represented as empty strings

Error Handling

The MCP returns descriptive error messages for common issues:

• Excel Data Format Invalid: When input data is not tab-separated or comma-separated
• At least 2 rows are required: When input data has fewer than 2 rows
• Both data and url received: When both 'data' and 'url' parameters are provided
• Network Error when fetching file: When there's an error downloading the file from the provided URL
• File not found: When the file at the provided URL cannot be found
• Blank/Null/Empty cells in the first row not allowed: When header row contains empty cells
• Server Internal Error: When an unexpected error occurs

Service Agreement and Privacy Policy

By using Excel to JSON MCP, you agree to the service agreement, and privacy policy.

Pricing

Using default conversion rules, free.

Using custom conversion rules, requires a Pro Code. Please refer to the pricing page for more details.