Audit Spreadsheet
Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model, including financial-model integrity checks like BS balance, cash tie-out, and logic sanity. Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this spreads
Overview
The Audit Spreadsheet skill, hosted in the fivetaku/claude-office-skills repository, provides automated verification for spreadsheet data and logic. Compatible with Claude and Claude Code, this tool allows users to examine specific ranges, individual sheets, or entire workbooks for formula accuracy and common errors. It performs specialized financial integrity checks, such as verifying balance sheet equilibrium, cash tie-outs, and general logic sanity. By leveraging Python and Pandas-based analysis, the skill identifies inconsistencies that might lead to incorrect data reporting. This technical utility is designed to streamline the quality assurance process for complex models, ensuring that formulaic relationships remain intact across large datasets and multi-sheet workbooks.
Use Cases
Install Notes
# Review source first
open https://github.com/fivetaku/claude-office-skills/blob/main/claude-in-excel/audit-xls/SKILL.mdCopy or clone the skill folder into your agent skills directory after reviewing its instructions and scripts.
Security Notes
This skill operates within the environment provided by the fivetaku/claude-office-skills repository. Users should ensure the agent has the necessary permissions to access the target spreadsheet files and that the execution environment complies with their data privacy standards.
Related Skills
Requirements for Outputs
anthropics/skills
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or fr
3-Statement Financial Model Template Completion
fivetaku/claude-office-skills
Complete, populate and fill out 3-statement financial model templates (Income Statement, Balance Sheet, Cash Flow Statement). Use when asked to fill out model templates, complete existing model frameworks, populate financial models with data, complete a partially filled IS/BS/CF framework, or link integrated financial
Clean Data
fivetaku/claude-office-skills
Clean up messy spreadsheet data — trim whitespace, fix inconsistent casing, convert numbers-stored-as-text, standardize dates, remove duplicates, and flag mixed-type columns. Use when data is messy, inconsistent, or needs prep before analysis. Triggers on "clean this data", "clean up this sheet", "normalize this data",
DCF Model Builder
fivetaku/claude-office-skills
Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need