JSON to Excel

Converts JSON data to CSV via an MCP service with two tools for data input from string or URL.

javascript

1

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-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.

How to use

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.

How to install

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"
    }
  }
}

Additional sections

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.

Available tools

json_to_excel_mcp_from_data

Converts a JSON data string into CSV format. Accepts a JSON array or a single object and outputs a CSV string with appropriate headers.

json_to_excel_mcp_from_url

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.