home / mcp / json to excel mcp server
Converts JSON data to CSV via an MCP service with two tools for data input from string or URL.
Configuration
View docs{
"mcpServers": {
"he-yang-json-to-excel-mcp": {
"command": "npx",
"args": [
"json-to-excel-mcp"
],
"env": {
"proCode": "YOUR_PRO_CODE_PLACEHOLDER"
}
}
}
}You can convert JSON data into CSV format using a dedicated MCP service that exposes two tools: one for JSON data provided directly and one for JSON content hosted at a URL. This MCP streamlines transforming JSON into a CSV string that you can easily import into Excel or other data tools, with options for advanced formatting if you have access to a Pro Code.
You interact with the JSON to Excel MCP through a client that supports MCP endpoints. Use the tool json_to_excel_mcp_from_data to convert a JSON payload you supply as a string. Use json_to_excel_mcp_from_url to fetch a JSON file from a publicly accessible URL and convert it to CSV. If you have a Pro Code, you can enable additional customization options when you provide the options object.
Prerequisites: ensure you have Node.js and npm installed on your machine.
Install and run the MCP locally using NPX. The following configuration is for the free version.
{
"mcpServers": {
"json_to_excel_mcp": {
"args": [
"json-to-excel-mcp"
],
"command": "npx"
}
}
}The tool supports a pro version with an optional proCode for custom conversion rules. If you provide options, you must also include proCode. If you do not have a valid Pro Code, use the free version without options.
Notes and behavior to expect: the converter handles numbers, booleans, strings, arrays, and objects appropriately. When converting a JSON array of objects, each object becomes a CSV row; a single object becomes a CSV with key-value pairs as columns. Headers are generated from the JSON keys.
Error handling includes messages for invalid JSON, empty input, or issues fetching data from a URL. The output is a CSV-formatted string suitable for importing into Excel.
Converts a JSON data string into CSV format. Accepts a JSON array or a single object and outputs a CSV string with appropriate headers.
Converts JSON data fetched from a public URL into CSV format. The URL must point to a .json file and the content should be a valid JSON array or object.