{"_id":"xlsx-audit-mcp","_rev":"2-c87a9596ba423bef0aaab2757cbf2c36","name":"xlsx-audit-mcp","dist-tags":{"latest":"0.1.1"},"versions":{"0.1.0":{"name":"xlsx-audit-mcp","version":"0.1.0","keywords":["mcp","mcp-server","model-context-protocol","excel","xlsx","spreadsheet","formula","audit","dependency-tracing","financial-model","claude"],"author":{"name":"Kole Harvey"},"license":"MIT","_id":"xlsx-audit-mcp@0.1.0","maintainers":[{"name":"koleharvey","email":"cinnamonolive@emalupe.com"}],"bin":{"xlsx-audit-mcp":"dist/index.js"},"dist":{"shasum":"5361be665c9d89b9cc848c20462bee68d83e8506","tarball":"https://registry.npmjs.org/xlsx-audit-mcp/-/xlsx-audit-mcp-0.1.0.tgz","fileCount":9,"integrity":"sha512-3n9NxkkMAgEFxL1qzxBsbVXkIekG3LmdQN2OuOwPdyY/rpjukyWZcHRaRIFScV8VEPZ69tPplpPPoJ8LPWI6hg==","signatures":[{"sig":"MEUCIQCHDaCM8czrxjdUbyStkPHA4Qf+F/hKr6qHDpDp6Z7FpwIgdXLhQMJzbSB2qhdHe1yj7gjmiBmZ181UPXmUxULLJgE=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":28914},"type":"module","engines":{"node":">=18"},"gitHead":"28450a973a6ca38d643b78ed3c1f0c88dd47956b","mcpName":"io.github.arose26/xlsx-audit-mcp","scripts":{"test":"vitest run","build":"tsc","prepublishOnly":"npm run build && npm test"},"_npmUser":{"name":"koleharvey","email":"cinnamonolive@emalupe.com"},"_npmVersion":"11.19.0","description":"MCP server that audits Excel workbooks — formula dependency tracing, circular-reference detection, and risk smells (INDIRECT, hardcoded constants, external links). Reviews the model, not the data.","directories":{},"_nodeVersion":"26.7.0","dependencies":{"zod":"^3.25.0","fflate":"^0.8.2","fast-xml-parser":"^5.10.0","@modelcontextprotocol/sdk":"^1.30.0"},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^3.0.0","typescript":"^5.7.0","@types/node":"^22.0.0"},"_npmOperationalInternal":{"tmp":"tmp/xlsx-audit-mcp_0.1.0_1786750300820_0.009025398312188182","host":"s3://npm-registry-packages-npm-production"}},"0.1.1":{"_id":"xlsx-audit-mcp@0.1.1","bin":{"xlsx-audit-mcp":"dist/index.js"},"bugs":{"url":"https://github.com/koleharv/xlsx-audit-mcp/issues"},"dist":{"shasum":"4da5f19404b329f3e90c52782259dc147b76510a","tarball":"https://registry.npmjs.org/xlsx-audit-mcp/-/xlsx-audit-mcp-0.1.1.tgz","fileCount":9,"integrity":"sha512-KtfY9purmgrN/fuSI7Yt5UgJWtAY+IelSy8jBPYjN9sMImvvWQtd6bpmu6a4H/4MIcZFKVtGeaUNrGmgMQ9liw==","signatures":[{"sig":"MEQCIDkeZ4F2rXWy1QWf2Qv4J9Ci/CokuFDxfvq5hP3TwUBhAiAL3Er6jQQQsA/BAsIbI+pCiSI1LdrqkYu+XUN6PdO5mg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"},{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQCtcp94gcxrpg0nceg3cdsPajlDszF50feSjQk00lsXIAIhAOG/8tLuk66C/UtoP2CJ99dX279lvkwTJ8cCXEPJhdMV"}],"unpackedSize":29021},"name":"xlsx-audit-mcp","type":"module","author":{"name":"Kole Harvey"},"engines":{"node":">=18"},"gitHead":"ba65234c57c64e37ef9b369731f9718e03520d63","license":"MIT","mcpName":"io.github.koleharv/xlsx-audit-mcp","scripts":{"test":"vitest run","build":"tsc","prepublishOnly":"npm run build && npm test"},"version":"0.1.1","_npmUser":{"name":"koleharvey","email":"cinnamonolive@emalupe.com"},"homepage":"https://github.com/koleharv/xlsx-audit-mcp#readme","keywords":["mcp","mcp-server","model-context-protocol","excel","xlsx","spreadsheet","formula","audit","dependency-tracing","financial-model","claude"],"repository":{"url":"git+https://github.com/koleharv/xlsx-audit-mcp.git","type":"git"},"_npmVersion":"10.9.0","description":"MCP server that audits Excel workbooks — formula dependency tracing, circular-reference detection, and risk smells (INDIRECT, hardcoded constants, external links). Reviews the model, not the data.","directories":{},"maintainers":[{"name":"koleharvey","email":"cinnamonolive@emalupe.com"}],"_nodeVersion":"22.12.0","dependencies":{"zod":"^3.25.0","fflate":"^0.8.2","fast-xml-parser":"^5.10.0","@modelcontextprotocol/sdk":"^1.30.0"},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^3.0.0","typescript":"^5.7.0","@types/node":"^22.0.0"},"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/xlsx-audit-mcp_0.1.1_1792330146741_0.2596431705174538"}}},"time":{"created":"2026-08-14T23:31:40.774Z","modified":"2026-10-18T13:29:06.999Z","0.1.0":"2026-08-14T23:31:40.997Z","0.1.1":"2026-10-18T13:29:06.848Z"},"author":{"name":"Kole Harvey"},"license":"MIT","keywords":["mcp","mcp-server","model-context-protocol","excel","xlsx","spreadsheet","formula","audit","dependency-tracing","financial-model","claude"],"description":"MCP server that audits Excel workbooks — formula dependency tracing, circular-reference detection, and risk smells (INDIRECT, hardcoded constants, external links). Reviews the model, not the data.","maintainers":[{"name":"koleharvey","email":"cinnamonolive@emalupe.com"}],"readme":"# xlsx-audit-mcp\n\nAn [MCP](https://modelcontextprotocol.io) server that **audits Excel workbooks**. Other Excel MCP servers read and write your data — this one reviews your *model*:\n\n- *\"What feeds the Total cell on the Summary sheet?\"* — precedent tracing\n- *\"If I change this assumption, what breaks?\"* — dependent tracing, including cells that consume it through ranges like `SUM(A1:A40)`\n- *\"Audit this workbook\"* — circular references with example chains, volatile functions (`INDIRECT`, `OFFSET`, `NOW`, `RAND`...), hardcoded constants buried inside formulas, external workbook links, merged cells, extra-long formulas\n\nSpreadsheet mistakes are famously expensive. This is the \"trace precedents\" discipline auditors apply by hand, exposed to an LLM for a whole workbook at once. Local files only; nothing leaves your machine.\n\n## Quick start\n\n**Claude Code**\n\n```bash\nclaude mcp add xlsx-audit -- npx -y xlsx-audit-mcp\n```\n\n**Claude Desktop** — add to `claude_desktop_config.json`:\n\n```json\n{\n  \"mcpServers\": {\n    \"xlsx-audit\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"xlsx-audit-mcp\"]\n    }\n  }\n}\n```\n\nThen: *\"Audit C:\\\\models\\\\budget-2026.xlsx and tell me what looks fragile.\"*\n\n## Tools\n\n| Tool | What it does |\n|------|--------------|\n| `workbook_overview` | Sheets, dimensions, formula counts, defined names, external links |\n| `list_formulas` | Formulas with addresses and cached values, filterable (`INDIRECT`, `VLOOKUP`, ...) |\n| `trace_cell` | One cell's formula, value, precedents, and dependents (direct + via ranges) |\n| `audit_workbook` | Ranked risk report across the whole model |\n\n## How it works\n\n- **Reference tokenizer** that understands real formulas: string literals are stripped first (the `\"A1\"` in `INDIRECT(\"A1\")` is not a reference), function names can't collide (the `G10` in `LOG10(...)` is not a cell), `$` absolutes, quoted sheet names (`'My Data'!A1`), and ranges are handled.\n- **Shared formulas are materialized.** Excel stores filled formulas once with an offset scheme; the loader translates them per-cell (relative refs shifted, absolutes preserved), so dependency queries see what each cell actually computes.\n- **Ranges are never expanded for storage** — dependents queries use range-containment tests, and cycle detection caps range fan-out (a `SUM(A:A)` can't explode the graph; capped ranges are reported, not silently dropped).\n- **No formula evaluation.** Cached values from the file are shown instead — no spreadsheet engine dependency.\n\nKnown limitations: R1C1 notation and structured table references (`[@Column]`) are counted but not resolved into the graph.\n\n## Development\n\n```bash\nnpm install\nnpm test                 # offline tests — synthetic workbooks built in-suite\nnpm run build            # tsc → dist/\nnode scripts/smoke.mjs   # end-to-end: generates a workbook, drives the server over stdio\n```\n\nArchitecture: [`src/xlsx.ts`](src/xlsx.ts) (zip + XML → workbook model) and [`src/formulas.ts`](src/formulas.ts) (tokenizer, graph, smells) are pure logic; [`src/index.ts`](src/index.ts) is the MCP wiring.\n\n## License\n\nMIT\n","readmeFilename":"README.md","homepage":"https://github.com/koleharv/xlsx-audit-mcp#readme","repository":{"url":"git+https://github.com/koleharv/xlsx-audit-mcp.git","type":"git"},"bugs":{"url":"https://github.com/koleharv/xlsx-audit-mcp/issues"}}