Help
Pick your add-in, or say what is going wrong. Each has a step-by-step guide, and most have short articles on the problems people search for.
Searches 80 articles and every add-in by name.
Hardcoded Value Detector
Numbers typed over formulas
- Excel™ guideHardcoded Value Detector, step by step
- Google Sheets™ guideHardcoded Value Detector, step by step
Help articles
AI Readiness Scanner and Fixer
Worksheets Copilot™ reads wrong
- Excel™ guideAI Readiness Scanner and Fixer, step by step
- Google Sheets™ guideAI Readiness Scanner and Fixer, step by step
Help articles
Two-File Reconciliation
Match on a key, not row order
- Excel™ guideTwo-File Reconciliation, step by step
- Google Sheets™ guideTwo-File Reconciliation, step by step
Help articles
- Reconciling a bank statement against a ledger in Google Sheets™
- Reconciling a CSV export against a Google Sheet™
- Moving from the Excel™ add-in to Google Sheets™
- How to reconcile two Google Sheets™ with different column order
- When one system books amounts as negatives and the other as positives
- VLOOKUP or XLOOKUP not matching in Google Sheets™: spaces, zeros and the sorted trap
Change Diff
What changed since the last save
No help articles yet. The guide covers the whole thing.
Import Cleaner for Xero
Exports in, uploads checked
- Excel™ guideImport Cleaner for Xero, step by step
- Google Sheets™ guideImport Cleaner for Xero, step by step
Help articles
Structure Flattener
A sent report, made a table
No help articles yet. The guide covers the whole thing.
Unit-aware Calculation Checker
Units that contradict each other
No help articles yet. The guide covers the whole thing.
External Link and Dependency Mapper
Links Excel™ cannot show you
No help articles yet. The guide covers the whole thing.
Calculation Sign-Off and Lock
Prove the calculation has not changed
No help articles yet. The guide covers the whole thing.
Selection-Scoped Formula Explainer
What that formula actually does
Help articles
Import Cleaner for Sage™
Sage exports in, uploads checked
- Excel™ guideImport Cleaner for Sage™, step by step
- Google Sheets™ guideImport Cleaner for Sage™, step by step
Help articles
Import Cleaner for QuickBooks™
QuickBooks files in, uploads checked
- Excel™ guideImport Cleaner for QuickBooks™, step by step
- Google Sheets™ guideImport Cleaner for QuickBooks™, step by step
Help articles
- QuickBooks™ bank CSV, 3 columns: dates, amounts and zeros
- QuickBooks™ bank CSV, 4 columns: Credit and Debit
- QuickBooks™ customers and suppliers import: names, headings and limits
- QuickBooks™ journal entries import: columns, balance and names
- QuickBooks™ report exports in Google Sheets™: titles, totals and text numbers
UK Bank CSV Cleaner
Bank CSVs ready for Xero, QuickBooks, Sage
Help articles
- Bank CSV dates wrong in Google Sheets™: 06/03 read as 3 June
- Bank CSV amounts will not add up: £ signs, commas and text numbers
- Bank CSV with separate Paid in and Paid out columns: one signed amount
- Lay a UK bank CSV out for Xero™, QuickBooks™ or Sage™ bank import
- Bank CSV with extra rows, repeats and duplicates: clean before upload
Payout Export Cleaner
Shopify and Stripe payouts, split
- Excel™ guidePayout Export Cleaner, step by step
- Google Sheets™ guidePayout Export Cleaner, step by step
Help articles
- Payout total does not match its lines: why, and how to find the gap
- Payout fees missing or netted off: how to see what you were charged
- Stripe™ payout reconciliation: split gross, fee and net in Google Sheets™
- Multi-currency payout export: how to check it without converting
- Shopify™ payout export in Google Sheets™: what the add-on checks
- Payout export dates and amounts stored as text: how to fix them safely
Sheet Speed Checker
Why your sheet is slow
Help articles
- Why is my Google Sheet™ so slow? 12 causes and how to find yours
- IMPORTRANGE making Google Sheets™ slow? Import once, reference many
- Google Sheets™ 20 million cell limit: find and delete empty rows safely
- Conditional formatting slowing down Google Sheets™? Merge the fragments
- NOW() and TODAY() in Google Sheets™: the hidden cost of volatile functions
- VLOOKUP on whole columns in Google Sheets™: faster alternatives
Form Response Cleaner
Google Form™ responses, cleaned
Help articles
- Count checkbox answers from a Google Form™ (COUNTIF on multi-select)
- Why you shouldn't sort or edit the Form Responses tab (and what to do instead)
- Phone numbers losing the leading zero in Google Form™ responses
- Remove duplicate Google Form™ submissions, keeping the latest
- Google Form™ responses: shorten long question headers without breaking the form
- How to split Google Form™ checkbox responses into separate columns
Mail Merge Pre-flight Check
Check the merge before you send
Help articles
- Mail merge sent “Hi ,” — how to handle blank first names
- Check an email list for typos and duplicates in Google Sheets™
- Check your list before a Gmail™ mail merge
- Check your list before a GMass merge
- Check your list before a Mailmeteor merge
- Check your list before a YAMM merge
- Gmail™ mail merge fields not working? Check your column headers
- How many emails can I send with a mail merge from Gmail™ per day?
- Mail merge dates showing as numbers in Google Sheets™ (and currency losing its £)
- The mail merge that sent the wrong details to the wrong person
- A pre-send checklist for school newsletters from Google Sheets™
Personal Data and Sharing Check
Personal data hiding in a sheet
Help articles
- Hidden tabs in Google Sheets™ aren't private: here's who can see them
- Does Google Sheets™ version history keep deleted data? How to share a clean copy
- How to check who a Google Sheet™ is shared with (and remove people)
- Find NI numbers, bank details and dates of birth in a Google Sheet™
- Answering a subject access request from a spreadsheet: a step-by-step guide
- Before you share a staff list: a 10-point checklist for Google Sheets™
- IMPORTRANGE and privacy: what people you share with can see
- School data in Google Sheets™: pupil lists, SEN and sharing
Seller Export Cleaner
Etsy, eBay and Vinted in one ledger
Help articles
- Etsy™ payment statement CSV explained, column by column
- How to download your eBay™ transaction report (and join a whole year)
- How to get your Vinted™ sales history for a tax return
- Etsy™ fees in a spreadsheet: transaction, processing, offsite ads and VAT on fees
- Selling on Etsy™, eBay™ and Vinted™: one spreadsheet for all three