JSON to Excel MCP by WTSolutions

Introduction

The JSON to Excel MCP (Model Context Protocol) provides a standardized interface for converting JSON data into CSV format string using the Model Context Protocol. This MCP implementation offers two specific tools for data conversion:

json_to_excel_mcp_from_data: Converts JSON data string into CSV format.
json_to_excel_mcp_from_url: Converts JSON file from a provided URL (.json format) into CSV format string.

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

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

Related MCP server: Excel MCP Server

Server Config

Available MCP Servers (SSE and Streamable HTTP):

Using Stdio (NPX)

Server Config JSON:

Case 1 : Free Version

If you are using the free version:

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

Case 2 : Pro Version

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

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

Using SSE

Not supported starting from v0.3.0

Using Streamable HTTP

Not supported starting from v0.3.0

MCP Tools

json_to_excel_mcp_from_data

Converts JSON data string into CSV format string.

Parameters

Parameter	Type	Required	Description
data	string	Yes	JSON data string to be converted to CSV. Must be a valid JSON array or object.
options	object	No	Optional configuration object for customizing the conversion process. Requires a valid subscription to JSON to Excel service.

Note:
Input data must be a valid JSON string. JSON schema available at JSON Schema and validator available at JSON to Excel Web App.
If the JSON is an array of objects, each object will be treated as a row in the CSV.
If the JSON is a single object, it will be converted into a CSV with key-value pairs.
The CSV will include headers based on the keys in the JSON objects.
This tool returns CSV-formatted data that can be easily converted/imported to Excel.

Options Object

The options object can contain the following properties:

Property	Type	Default	Description
proCode	string	""	Pro Code for custom conversion rules which requires a valid subscription to JSON to Excel service. This is a mandatory input if options is provided.
jsonMode	string	"flat"	Format mode for JSON output: "nested", or "flat"
delimiter	string	"."	Delimiter character for nested JSON keys when using jsonMode: "nested", acceptable delimiters are ".", "_", "__", "/".
maxDepth	string	"unlimited"	Maximum depth for nested JSON objects when using jsonMode: "nested". For maxDepth, "unlimited", "1" ~ "20" acceptable.

Note:

proCode is mandatory if options is provided. If you do not have a valid Pro Code, please use the free version without the options parameter, default conversion rules will be applied.
Detailed conversion rules can be found in Pro Features.

Example Prompt 1:

Convert the following JSON data into CSV format:

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

Example Prompt 2:

Convert the following JSON object into CSV format:

{ "Name": "John Doe", "Age": 25, "IsStudent": false, "Courses": ["Math", "Science"] }

json_to_excel_mcp_from_url

Converts JSON data from a provided URL into Excel data.

Parameters

Parameter	Type	Required	Description
url	string	Yes	URL pointing to a JSON file (.json)
options	object	No	Optional configuration object for customizing the conversion process. Requires a valid subscription to JSON to Excel service.

Note:
The url should be publicly accessible.
The JSON file should be in .json format.
The JSON file should contain a valid JSON array or object. JSON schema available at JSON Schema and validator available at JSON to Excel Web App.
If the JSON is an array of objects, each object will be treated as a row in the CSV.
If the JSON is a single object, it will be converted into a CSV with key-value pairs.
This tool returns CSV-formatted data that can be easily converted/imported to Excel.

Options Object

The options object can contain the following properties:

Property	Type	Default	Description
proCode	string	""	Pro Code for custom conversion rules which requires a valid subscription to JSON to Excel service. This is a mandatory input if options is provided.
jsonMode	string	"flat"	Format mode for JSON output: "nested", or "flat"
delimiter	string	"."	Delimiter character for nested JSON keys when using jsonMode: "nested", acceptable delimiters are ".", "_", "__", "/".
maxDepth	string	"unlimited"	Maximum depth for nested JSON objects when using jsonMode: "nested". For maxDepth, "unlimited", "1" ~ "20" acceptable.

Note:

proCode is mandatory if options is provided. If you do not have a valid Pro Code, please use the free version without the options parameter, default conversion rules will be applied.
Detailed conversion rules can be found in Pro Features.

Example Prompt 1

Convert JSON file to Excel, file URL: https://mcp.wtsolutions.cn/example.json

Example Prompt 2

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

I've just uploaded one .json file to you, please extract its URL and send it to MCP tool 'json_to_excel_mcp_from_url', for JSON to Excel conversion.

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 CSV data string, '' if there was an error. This CSV data can be easily imported into Excel.

Example Success Response

{ "content": [{ "type": "text", "text": "{\"isError\":false,\"msg\":\"success\",\"data\":\"Name,Age,IsStudent\nJohn Doe,25,false\nJane Smith,30,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,Age,IsStudent\nJohn Doe,25,false\nJane Smith,30,true" }

Example Failed Response

{ "content": [{ "type": "text", "text": "{\"isError\": true, \"msg\": \"Invalid JSON format\", \"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": "Invalid JSON format", "data": "" }

or it is also possible that your LLM would say "Invalid JSON format, please provide a valid JSON string" to you.

Data Type Handling

The API automatically handles different data types in JSON:

Numbers: Converted to numeric values in CSV
Booleans: Converted to 'true'/'false' strings
Strings: Escaped and quoted if necessary
Arrays: Converted to JSON.stringify array string
Objects: Converted to JSON.stringify object string

Error Handling

The MCP returns descriptive error messages for common issues:

Invalid JSON format: When input data is not a valid JSON string
Empty JSON data: When input data is an empty JSON string
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
Server Internal Error: When an unexpected error occurs

Service Agreement and Privacy Policy

By using JSON to Excel 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.

Install Server

A

security – no known vulnerabilities

F

license - not found

A

quality - confirmed to work

How are these scores calculated?

Resources

Need Help?

Report Issue

Related Servers

JSON to Excel MCP by WTSolutions

JSON to Excel MCP by WTSolutions

Introduction

Server Config

Using Stdio (NPX)

Using SSE

Using Streamable HTTP

MCP Tools

json_to_excel_mcp_from_data

Parameters

Options Object

Example Prompt 1:

Example Prompt 2:

json_to_excel_mcp_from_url

Parameters

Options Object

Example Prompt 1

Example Prompt 2

Response Format

Example Success Response

Example Failed Response

Data Type Handling

Error Handling

Service Agreement and Privacy Policy

Pricing

Resources

Tools

Appeared in Searches

New MCP Servers

Latest Blog Posts

MCP directory API