Audit an Excel workbook — verify formulas, check computed values, inspect formatting, report findings
Non-destructive audit of an existing Excel workbook. Reads everything, reports all findings, proposes fixes but does not apply them unless confirmed.
Invoke the spreadsheet-wizard agent from ~/.claude/agents/spreadsheet-wizard.md.
excel_describe_sheets → list all sheets, dimensions, table names
Report: "Workbook has N sheets: [names]. Primary data appears to be on [sheet]."
For each sheet:
excel_read_sheet with showFormula: true
Catalog every formula cell. Build a list: [CellAddr, FormulaText, ComputedValue]
excel_read_sheet with showFormula: false
Flag any cell showing: #REF!, #NAME?, #VALUE!, #DIV/0!, #N/A, #NULL!, #NUM!, #SPILL!
For each SUM/SUMIF/SUMIFS formula:
For each XLOOKUP/VLOOKUP:
excel_read_sheet with showStyle: true
Check:
excel_screen_capture → header + first 20 rows
Report: describe what you see.
## Verification Report — [filename]
### Summary
| Check | Status |
|-------|--------|
| Total formula cells | N |
| Passing | N |
| Errors | N |
| Warnings | N |
| Formatting issues | N |
### Errors (Must Fix)
- [Cell] [Formula] → [Error type]: [Diagnosis and recommended fix]
### Warnings (Should Fix)
- [Cell]: [Issue] — [Recommendation]
### Suggestions (Nice to Have)
- [Observation] — [Suggestion]
### Verdict
PASS / NEEDS FIXES / CRITICAL ERRORS
"Would you like me to apply these fixes?" — wait for confirmation before writing anything.
Verification report with cell-level findings. Screenshot of current state. Optional: apply fixes if user confirms.