Spreadsheet health check
Before anyone relies on a client's workbook, this looks under the bonnet and ends with a verdict on whether it can be relied on. It changes nothing.
Runs best in: Copilot in Excel, on the open workbook. Use Cowork when you want it run across several files or chained with other skills.
- Works in:
- Copilot in Excel, Copilot Cowork
- Chains with:
- Run it on a client model before Variance hunter or Numbers to board slides rely on it. Tidy this export fixes layout problems it finds in raw exports.
- Version:
- 1.2 (October 2026)
Who it's for
Managers, reviewers and partners who receive workbooks from clients or rely on internal models. It suits anyone who has been caught out by a typed number sitting in a column of formulas.
The problem it solves
A client sends a workbook and someone has to decide whether it can be trusted. Hidden sheets, a hard-coded rate inside a formula, a total that stops a few rows short or a date stored as text can all sit unnoticed until a figure is wrong in front of a client. Checking properly means looking at every sheet, which rarely happens.
What it does
What the skill does
Give it the workbook and, if you like, what it's for and which sheets matter most. It lists the sheets and what each appears to be for, then runs a fixed set of checks covering structure, formulas, figures and inputs: hidden sheets, merged cells, external links, hard-coded numbers in formulas, an overwritten formula in a column, errors, circular references, ranges that stop short, totals that don't foot and dates or numbers stored as text. Every finding has a sheet, a cell reference and a severity of Stop, Fix or Note. It ends with a verdict on whether the workbook can be relied on and the three fixes that would help most.
Use cases
- Checking a client's cash flow forecast before it goes into a lending pack
- Reviewing a fixed asset register before the year-end work starts
- Finding the one typed value in a column of formulas
- Spotting totals that don't foot and subtotals that double count
- Checking an internal model before the firm relies on it
How to use it
Install it, then use it
Install House style first. It's the one file every skill reads for your firm name, sign-off, voice and format. Fill it in once and this skill's Your firm block only needs the settings for this job. Skip it and the skill asks for your firm name and sign-off once.
In Excel
- 1 Download the zip file from this page and unzip it. You'll have a folder called spreadsheet-health-check with SKILL.md, README.md and an examples folder inside.
- 2 Open SKILL.md in any text editor and fill in the Your firm block at the top, such as your severity labels, your tolerance for totals and anything your firm always wants flagged.
- 3 In the Copilot pane, open Settings (...), then Manage skills > Custom skills > Create OneDrive folder > Open skills folder.
- 4 Put the spreadsheet-health-check folder there, then select Refresh. The folder name must match the skill name, so don't rename it.
- 5 Point it at the workbook and ask it to health check it, saying what the workbook is for if you can.
- 6 Read the verdict and the findings, then go straight to each cell reference to decide what to fix.
In Cowork
- 1 Download the zip file from this page and unzip it. You'll have a folder called spreadsheet-health-check with SKILL.md, README.md and an examples folder inside.
- 2 Open SKILL.md in any text editor and fill in the Your firm block at the top, such as your severity labels, your tolerance for totals and anything your firm always wants flagged.
- 3 Open Customize > Skills, select the arrow next to Add, then Upload skill, and choose the zip (recommended) or the SKILL.md on its own. If you changed SKILL.md, upload that, or zip the folder's contents again first so SKILL.md stays at the top level.
- 4 Or skip the upload and put the spreadsheet-health-check folder in your OneDrive at Documents/Cowork/skills/. Keep the folder name as it is.
- 5 Start a new Cowork conversation so it picks up the skill.
- 6 Point it at the workbook and ask it to health check it, saying what the workbook is for if you can.
- 7 Read the verdict and the findings, then go straight to each cell reference to decide what to fix.
The skill itself
Read the full SKILL.md
This is the whole skill. Your firm name, sign-off and voice come from House style. Change the settings under Your firm for anything specific to this job. Everything else follows them.
---
name: spreadsheet-health-check
description: "Use before relying on a client's workbook or an internal model: reviews it for hard-coded numbers inside formula ranges, broken references, hidden sheets and rows, circular references, totals that do not foot, inconsistent formulas and merged cells, and lists every finding with a cell reference."
---
# Spreadsheet health check
A client sends a workbook. Before anyone relies on it, someone should look under the bonnet. This skill does that look, systematically, and writes down what it found with a cell reference for every item so the reviewer can go straight to it.
It changes nothing in the workbook. It reports.
## Your firm
Shared settings (firm name, sign-off, voice, how dates and money are written) come from the `house-style` skill in this pack. Fill that in once and every skill uses it. If it is not loaded, ask for the firm name and sign-off once at the start and carry on.
Settings specific to this skill. Edit before first use. If a setting is blank but has a default, use the default and say so in one line. If a blank setting has no default and the job cannot be done without it, ask for all such settings together in one message at the start. If the job can be done without it, leave it out and say so. Never make up a value for a firm setting.
- Severity labels (default): Stop (figures cannot be relied on until fixed), Fix (likely wrong or fragile), Note (worth knowing)
- Tolerance for totals that do not foot: (default £1)
- Anything the firm always wants flagged: (for example external links, macros, pasted values where formulas are expected)
## What you need from the user
The workbook. Optionally: which sheets matter most, and what the workbook is for (a cash flow, a fixed asset register, a management pack), which helps judge what "wrong" looks like.
## The checks
Run every one. For each finding: sheet, cell or range, what you found, severity.
**Structure**
- Hidden sheets, hidden rows, hidden columns, very hidden sheets
- Merged cells inside data ranges
- Sheets with no references to or from anywhere (orphans)
- External links to other workbooks, and whether they resolve
**Formulas**
- Hard-coded numbers inside a formula (=B5*1.2 where 1.2 should be an input cell)
- A column or row of formulas with one cell that is a typed value instead (the classic overwritten formula)
- Inconsistent formulas across a row or column where the pattern breaks
- Formulas returning errors (#REF!, #DIV/0!, #N/A, #VALUE!)
- Circular references
- Ranges that stop short of the data (SUM(B2:B50) where data runs to B60)
- Volatile or fragile functions used widely (INDIRECT, OFFSET) worth a note
**Figures**
- Totals that do not foot: a stated total against a SUM of its parts, outside tolerance
- Subtotals that double count (a total that includes another total)
- Percentages outside 0 to 100 where that makes no sense; negative values where only positive make sense
- Dates stored as text; numbers stored as text
**Inputs and assumptions**
- Input cells not visually distinguished from calculations (if the workbook has a convention, note where it is broken)
- Assumptions with no label or source
## Method
1. List the sheets and say what each appears to be for.
2. Run every check. Do not sample; check the whole sheet for the sheets that matter, and at least the structure checks on the rest.
3. Write the findings list, sorted by severity then by sheet.
4. Give an overall verdict: can this workbook be relied on as it stands?
5. Suggest the three fixes that would most improve it, in order.
## Output
1. **Verdict** in one line.
2. **Findings**: a table, Sheet | Cell or range | Finding | Severity | Suggested fix. As an Excel sheet if in Cowork, added to a copy of the workbook, never the original.
3. **Sheet map**: one line per sheet.
4. **Top three fixes**.
## Guardrails
- Change nothing in the workbook. Report only. If asked to fix, do it on a copy and list every change.
- Every finding has a cell reference. No "there are some issues with the formulas".
- Do not judge the accounting. Judge the spreadsheet. If a figure looks wrong for accounting reasons, say "worth a professional look at" and move on.
- If the workbook is too large to check fully, say which sheets were checked fully and which were sampled. Questions
Questions about this skill
Is the skill free?
Does it change my numbers?
Does it check the accounting?
What if the workbook is very large?
Is there a sample to try?
Firmwide
Want your own firm's procedures built in and kept working? That's a Firmwide install.
A fixed-price install, typically six to eight weeks: Copilot made safe and useful in your Microsoft 365, an agent and a skills pack for every department, handed over with training. Then Run keeps it working.
Next step
Want this tailored to your firm?
A free 30-minute Copilot Readiness Check with James, online. You leave knowing where Copilot can and cannot see your data, the two jobs to automate first and a rough install price. Your own skills, built from your procedures and handed over to each department on its own work.
Related skills
All skills- Excel Has example + expected result Works for any team
Tidy this export
Turns a messy bank or practice software export into a clean Excel table on a new sheet, then proves nothing was lost with row counts and totals before and after.
Includes a known export quirks table for Xero, Sage, QuickBooks Online, FreeAgent, bank CSVs and practice software.
- Job
- Getting data in shape
- Works in
- Copilot in Excel, Copilot Cowork
- Chains with
- Run it first on any export, then hand the clean sheet to Bank statement summary, Reconcile two lists, Aged debtors to action, Variance hunter or Year-on-year comparison.
Version 1.2 Download Tidy this export - Excel Has example + expected result Works for any team
Variance hunter
Builds a variance table with formulas, flags the movements over your threshold, labels them favourable or adverse and drafts the commentary.
- Job
- Month-end and reporting
- Works in
- Copilot in Excel, Copilot Cowork
- Chains with
- Tidy this export and Spreadsheet health check prepare the source. The variance sheet feeds Numbers to board slides. Commentary uses House style.
Version 1.2 Download Variance hunter - Excel Has example + expected result
Year-on-year comparison
Two years of accounts in. A comparison sheet with formulas out, then plain-English notes for the year-end meeting and questions for the client.
- Job
- Year-end
- Works in
- Copilot in Excel, Copilot Cowork
- Chains with
- Tidy this export prepares the source. The comparison sheet and notes feed Year-end review deck.
Version 1.2 Download Year-on-year comparison