Formula Audit XL connector for Claude
The Formula Audit XL connector is a remote MCP server. It lets Claude check an Excel model for the formula errors that break financial models. You attach a workbook to the chat, and Claude gets a list of the cells to review, with the formula and the reason for each one.
The connector is free. It needs no account and no sign-in. Every tool is read-only.
Add the connector
Formula Audit XL is listed in the Claude connector directory. Open the listing while you are signed in to Claude.ai and connect it. In Claude Desktop, open Settings → Connectors and search for Formula Audit XL.
You can also add it by URL as a custom connector:
- Open Settings → Connectors.
- Click Add custom connector.
- Name:
Formula Audit XL. URL:https://formulaudit.com/mcp. - Leave the OAuth fields empty, then click Add.
- In a chat, attach an .xlsx file and ask Claude to audit it with Formula Audit XL.
Claude Code:
claude mcp add --transport http formula-audit-xl https://formulaudit.com/mcp Tools
audit_workbook: Audits an .xlsx or .xlsm file that you attach to the chat. The file goes to the server as base64, at most 5 MB.audit_formulas: Runs the same checks on cell contents that Claude has already extracted from a workbook, for example with code execution. At most 50,000 cells. Use it for files that are too large to send whole.list_checks: Lists the six checks, what each one flags and why it matters. Takes no input.
Checks
- Circular references
- Links to other workbooks
- Hardcoded numbers in formulas, and typed values pasted over formulas
- Formulas that break the pattern of their row or column
- Broken named ranges
- Unused named ranges
Each result gives the count per check and up to 50 findings per check, with the sheet, the cell, the formula and the reason. The connector reads formulas as stored: it does not calculate the workbook and it does not run macros.
Example prompts
- "Audit this model for hardcoded numbers and circular references."
- "Which formulas in this workbook break the pattern of their row?"
- "Are there links to other files or broken named ranges in this spreadsheet?"
Limits
audit_workbook: one file of at most 5 MB and 100,000 cells, .xlsx or .xlsm, without a password.audit_formulas: at most 50,000 cells per call.- 30 tool calls in any 60 minutes from one IP address.
Your data
The server reads the file in memory for one request and never stores it. It does not log the file, the cells or the result. The server runs on Cloudflare. Text from the workbook (sheet names, formulas, link targets) is cleaned of control and hidden characters before it goes back to Claude, so Claude reads it as data. Details are in the privacy policy.
Troubleshooting
- Claude does not call the tools
- Open the tools menu in the chat and check that the Formula Audit XL connector is on. Then name it in the prompt: "Audit this workbook with Formula Audit XL."
- "The file is … MB; the limit is 5 MB" or "more than 100,000 cells, the limit here"
- Ask Claude to extract the formulas and numbers (with code execution) and to use audit_formulas. That tool accepts up to 50,000 cells per call, so split a larger model by sheet.
- "The file is not an .xlsx or .xlsm workbook"
- Save the workbook as .xlsx or .xlsm without a password. Legacy .xls files and password-protected workbooks are not supported.
- "Rate limit reached"
- One IP address can make 30 tool calls in any 60 minutes. Try again later.
Support
Write to hello@formulaudit.com or use the contact page. For a security concern, use the same address and put "Security" in the subject.
Audit inside Excel too
For Microsoft Excel on Windows, Mac and the web · No data leaves your machine