Read and write Excel spreadsheets (XLSX) via @negokaz/excel-mcp-server (npx)

{
  "server": "@negokaz/excel-mcp-server",
  "version": "0.12.0",
  "transport": "stdio",
  "framing": "newline-delimited JSON (NOT Content-Length)",
  "launcher": "npx -y @negokaz/excel-mcp-server",
  "prerequisite": "existing .xlsx file required (server cannot create from scratch)",
  "tools_count": 6,
  "tools": ["excel_write_to_sheet", "excel_read_sheet", "excel_describe_sheets", "excel_format_range", "excel_copy_sheet", "excel_create_table"],
  "init": {
    "request": {
      "jsonrpc": "2.0",
      "id": 1,
      "method": "initialize",
      "params": {
        "protocolVersion": "2024-11-05",
        "capabilities": {},
        "clientInfo": {
          "name": "pathfinder",
          "version": "1.0.0"
        }
      }
    },
    "response": {
      "protocolVersion": "2024-11-05",
      "capabilities": {
        "tools": {
          "listChanged": true
        }
      },
      "serverInfo": {
        "name": "excel-mcp-server",
        "version": "0.12.0-SNAPSHOT-1ff4340"
      }
    },
    "latency_ms": 968
  },
  "write_tabular_data": {
    "request": {
      "jsonrpc": "2.0",
      "id": 3,
      "method": "tools/call",
      "params": {
        "name": "excel_write_to_sheet",
        "arguments": {
          "fileAbsolutePath": "/tmp/pathfinder-excel/demo.xlsx",
          "sheetName": "Scores",
          "newSheet": true,
          "range": "A1:C4",
          "values": [
            ["Name", "Subject", "Score"],
            ["Alice", "Math", 95],
            ["Bob", "Physics", 87],
            ["Carol", "Math", 92]
          ]
        }
      }
    },
    "response_html": "<table><tr><th></th><th>A</th><th>B</th><th>C</th></tr><tr><th>1</th><td>Name</td><td>Subject</td><td>Score</td></tr><tr><th>2</th><td>Alice</td><td>Math</td><td>95</td></tr><tr><th>3</th><td>Bob</td><td>Physics</td><td>87</td></tr><tr><th>4</th><td>Carol</td><td>Math</td><td>92</td></tr></table>",
    "latency_ms": 52
  },
  "write_formulas": {
    "request": {
      "jsonrpc": "2.0",
      "id": 4,
      "method": "tools/call",
      "params": {
        "name": "excel_write_to_sheet",
        "arguments": {
          "fileAbsolutePath": "/tmp/pathfinder-excel/demo.xlsx",
          "sheetName": "Scores",
          "newSheet": false,
          "range": "D1:D4",
          "values": [
            ["Grade"],
            ["=IF(C2>=90,"A","B")"],
            ["=IF(C3>=90,"A","B")"],
            ["=IF(C4>=90,"A","B")"]
          ]
        }
      }
    },
    "response_confirms_formulas": true,
    "latency_ms": 51
  },
  "read_computed_values": {
    "request": {
      "jsonrpc": "2.0",
      "id": 5,
      "method": "tools/call",
      "params": {
        "name": "excel_read_sheet",
        "arguments": {
          "fileAbsolutePath": "/tmp/pathfinder-excel/demo.xlsx",
          "sheetName": "Scores"
        }
      }
    },
    "response_html": "<table><tr><th></th><th>A</th><th>B</th><th>C</th><th>D</th></tr><tr><th>1</th><td>Name</td><td>Subject</td><td>Score</td><td>Grade</td></tr><tr><th>2</th><td>Alice</td><td>Math</td><td>95</td><td>A</td></tr><tr><th>3</th><td>Bob</td><td>Physics</td><td>87</td><td>B</td></tr><tr><th>4</th><td>Carol</td><td>Math</td><td>92</td><td>A</td></tr></table>",
    "note": "Formulas evaluated: IF(95>=90) → A, IF(87>=90) → B, IF(92>=90) → A",
    "latency_ms": 51
  },
  "read_raw_formulas": {
    "request": {
      "jsonrpc": "2.0",
      "id": 6,
      "method": "tools/call",
      "params": {
        "name": "excel_read_sheet",
        "arguments": {
          "fileAbsolutePath": "/tmp/pathfinder-excel/demo.xlsx",
          "sheetName": "Scores",
          "showFormula": true
        }
      }
    },
    "response_shows_formulas": "=IF(C2>=90,"A","B") etc. in column D",
    "latency_ms": 51
  },
  "describe_sheets": {
    "request": {
      "jsonrpc": "2.0",
      "id": 7,
      "method": "tools/call",
      "params": {
        "name": "excel_describe_sheets",
        "arguments": {
          "fileAbsolutePath": "/tmp/pathfinder-excel/demo.xlsx"
        }
      }
    },
    "response": {
      "backend": "excelize",
      "sheets": [
        {
          "name": "Sheet",
          "usedRange": "A1:A1",
          "tables": [],
          "pivotTables": [],
          "pagingRanges": ["A1:A1"]
        },
        {
          "name": "Scores",
          "usedRange": "A1:D4",
          "tables": [],
          "pivotTables": [],
          "pagingRanges": ["A1:D4"]
        }
      ]
    },
    "latency_ms": 51
  },
  "total_latency_ms": 1225
}