Guides
One per add-in. Each runs the whole thing on a worked example, with a picture of the pane at every stage, so you can see what it does before you install anything.
Every guide is free to read and needs no account. Where a step is on the paid tier it says so beside the heading; everything else works on the free one.
Find hardcoded values in an Excel™ workbook
The numbers somebody typed over a formula, and the constants buried inside one. Both are invisible to Excel™’s own inconsistent-formula warning. Fix them one at a time, and undo the fix.
Read the guide · Hardcoded Value Detector · Prices
Make an Excel™ worksheet Copilot-ready
Merged cells, banner rows, a header that contradicts its column. Scan a sheet for the things that change what Copilot™ reads, fix them one at a time, and restore the sheet if you want it back.
Read the guide · AI Readiness Scanner and Fixer · Prices
Reconcile two Excel™ tables on a key
Match two tables on a key rather than on row order, and get back what does not agree and why — on six sheets, including an audit sheet recording every option that was on.
Read the guide · Two-File Reconciliation · Prices
Compare an Excel™ workbook against an earlier version
What changed since the last save. Written for the case that matters: the formula somebody quietly replaced with a typed number.
Read the guide · Change Diff · Prices
Clean a Xero export, and check a sheet before uploading it
A Xero export arrives with text dates and text amounts that look like numbers and do not add up. Fix both, then check a sheet against Xero’s own rules before you upload it.
Read the guide · Import Cleaner for Xero · Prices
Flatten a formatted Excel™ report into a table
Section headers, subtotals, spacer rows — a report laid out to be read rather than pivoted. Turn it into a table on a new sheet, with the original untouched.
Read the guide · Structure Flattener · Prices
Check the units in an Excel™ calculation
Excel™ has no concept of a unit, so a length added to an area raises nothing. Find where a formula adds kN to N, or a moment to a force, using the units already written on the sheet.
Read the guide · Unit-aware Calculation Checker · Prices
Find every external link in an Excel™ workbook
Excel™ says the workbook has a link and will not say where. Find every one — in formulas, defined names, validation lists, conditional formats and hyperlinks — then break it safely, or read the map of what depends on what.
Read the guide · External Link and Dependency Mapper · Prices
How to take over someone else’s spreadsheet
A ten-step method for a model you did not build: what to read first, how to find what is hardcoded, which formulas will break when something changes, and how to read any one of them in the workbook’s own words rather than Excel™’s.
Read the guide · Selection-Scoped Formula Explainer · Prices
Prove an Excel™ calculation has not changed since it was signed off
Sign off the logic of a model, lock it, and give anyone who receives the file a way to check that the formulas have not moved since — naming the cells if they have. Verifying is free for everyone, forever, with no key and no account.
Read the guide · Calculation Sign-Off and Lock · Verify a file (free) · Prices
And the ten for Google Sheets™:
Score and fix a Google Sheet™ so an AI assistant reads it correctly
Gemini™ in Sheets, ChatGPT and Copilot™ all read a spreadsheet by guessing its shape, and merged cells, banner rows, blank gaps and numbers stored as text all make that guess wrong. Score the active sheet out of 100, read why each finding matters, and fix the safe ones. Scanning, the score, every explanation and Undo are free in every tier.
Read the guide · AI Readiness Scanner and Fixer · Prices
How to clean a Xero export and check an upload in Google Sheets™
Install the add-on, pick a direction, scan a sheet, read every finding, apply the safe fixes with a preview, and undo if you change your mind.
Read the guide · Import Cleaner for Xero · Prices
Find the numbers typed over formulas in a Google Sheet™
Find the cells where a formula was pasted over with a value, the constants buried inside formulas, and the totals that quietly stopped updating.
Read the guide · Hardcoded Value Detector · Prices
How to reconcile two Google Sheets™ on a key
Pick two tables, confirm how the columns line up, reconcile, write the report, and save a recipe for next month. Free up to 1,000 rows a side.
Read the guide · Two-File Reconciliation · Prices
How to find what is slowing your Google Sheet™
Check a sheet, read every finding, apply the safe fixes with a preview, and undo if you change your mind. Plus what each of the fifteen checks means.
Read the guide · Sheet Speed Checker · Prices
How to clean up Google Form™ responses
Open the cleaner, confirm options and headers, clean, and refresh as new responses arrive — with what every rule means and the by-hand formula for each.
Read the guide · Form Response Cleaner · Prices
Check your mail merge before you send
Pick the list, paste the template, check, and read what every rule means, with the by-hand fix for each.
Read the guide · Mail Merge Pre-flight Check · Prices
Find the personal data in a Google Sheet™ before you share it
What every finding means, why it matters, and how to fix it by hand — plus the before-you-share checklist.
Read the guide · Personal Data and Sharing Check · Prices
Turn Etsy, eBay and Vinted sales files into one ledger
Where to download each platform's sales file, how to build one ledger from them in Google Sheets™, and what every cleaning rule does.
Read the guide · Seller Export Cleaner · Prices
Keep a shared Google Sheet™ from being broken
Every check, every guardrail, what protection cannot do, and how to fix each problem by hand.