The Google Sheets Audit Checklist
Inheriting a Google Sheet is an act of trust. Before you build on someone else's spreadsheet — or hand yours off — it pays to run a structured spreadsheet review so you know exactly what you're standing on. This Google Sheets audit checklist walks through what to check, why each item matters, and how to verify it quickly.
Start with the formulas
Formulas are where most silent errors hide. They look fine until a number is quietly wrong.
1. Hunt down broken references and formula errors
Visible error values mean a calculation has already failed. The common ones are #REF! (a referenced cell or range was deleted), #NAME? (a misspelled function or undefined named range), #VALUE! (the wrong data type, like text where a number is expected), #N/A (a lookup found no match), and #DIV/0! (division by an empty or zero cell). To find them fast, open Edit > Find and replace, tick Search using regular expressions, and search for #REF! or #N/A across all sheets. A single #REF! often signals a deleted column that broke a chain of dependent formulas.
2. Check formula consistency within each column
In a well-built sheet, every cell in a calculated column shares the same formula pattern, just shifted by row. The classic failure is one cell that someone hand-typed over — a pasted constant or a tweaked formula — that silently breaks the pattern. To check, select a calculated column and glance down it, or use Ctrl+` (backtick) to toggle Show formulas and scan for the cell that doesn't match its neighbors. One overwritten cell in a thousand-row total is the kind of thing that survives for months.
Trace what the sheet depends on
A spreadsheet is rarely self-contained. The riskiest dependencies are the ones you can't see at a glance.
3. Map external dependencies
Functions like IMPORTRANGE, IMPORTDATA, IMPORTXML, and IMPORTHTML pull data from other sheets, URLs, or web pages. The problem: those sources may be owned by someone else, may lose access, or may change structure without warning. An IMPORTRANGE pointing at a sheet you can't open is a dependency you don't control. Search the sheet for IMPORT using Find and replace, then confirm you actually have access to every source and understand what happens if one disappears.
4. Flag volatile and recalculation-heavy functions
Some functions recalculate constantly. NOW, TODAY, RAND, and RANDBETWEEN are volatile — they update on nearly every edit, which can make a large sheet sluggish and cause values to shift underneath you. INDIRECT and OFFSET are recalculation-heavy and hard to trace because they build references from text, which also blocks tools from following the dependency chain. Search for these names; a sheet that crawls on every keystroke usually has too many of them.
Inspect structure and presentation
Layout choices affect both reliability and how easily the next person can work with the file.
5. Reveal hidden sheets and heavy merged cells
Hidden sheets often hold lookups, scratch calculations, or stale data that still feeds the visible tabs. Right-click any sheet tab and check All Sheets, or look for the hidden-sheet indicator, to confirm nothing important is tucked away. Then watch for heavy use of merged cells — they break sorting, filtering, and range formulas, and they're a frequent source of subtle bugs. A few merged title cells are fine; merged cells inside a data range are a warning sign.
6. Confirm data validation coverage
Input cells without constraints invite bad data — a typo'd date, a category that doesn't exist, a negative where only positives make sense. Check whether the cells people type into use Data > Data validation rules (dropdowns, number ranges, date checks). If the inputs that drive the whole model are unconstrained, treat every downstream number with caution.
7. Review conditional formatting complexity
Conditional formatting is helpful until there are dozens of overlapping rules. Heavy use slows the sheet, and conflicting rules produce misleading colors that people then trust as signal. Open Format > Conditional formatting and review the rule list per sheet — if it's a long, tangled stack, the visual cues may not mean what they appear to.
Check the guardrails and documentation
The last group is about whether the sheet protects itself and explains itself.
8. Verify protections on critical cells
Formulas and reference tables that should never be edited by hand ought to be protected. Open Data > Protected sheets and ranges to see what's locked. If the core logic is wide open, it's only a matter of time before someone overwrites a formula with a typed-in value.
9. Audit named ranges
Named ranges make formulas readable, but only if they're documented and still valid. Open Data > Named ranges and check for names pointing at deleted or shifted ranges, and for names whose meaning isn't obvious. An undocumented named range buried in a formula is a small mystery you'll have to solve later.
10. Assess workbook structure, frozen headers, and filters
Step back and look at the whole workbook. Is it bloated with abandoned tabs and oversized ranges that hurt performance? Are header rows frozen (View > Freeze) so the sheet stays readable as you scroll? Are there active filters or filter views hiding rows that could mislead you into thinking data is missing? A clean, well-sized structure is itself a sign the sheet was built with care.
11. Find out whether the logic is documented
Finally, ask the most important question: is any of this explained anywhere? Look for a notes tab, cell notes (Insert > Note), or a README explaining assumptions, sources, and how the calculations work. A sheet nobody can explain is a liability no matter how clean the formulas look — and how to review a Google Sheet ultimately comes down to whether you can reconstruct the author's intent.
Run the checklist by hand — or automatically
You can work through every item above manually, and on a small sheet that's perfectly reasonable. For larger or unfamiliar files, you can also run the whole list automatically with Sheet Audit Pack, a free Google Sheets add-on that performs each of these checks and produces an Audit Summary with a 0–100 risk score, an Issues Log of what it found, and a Formula Map of the sheet's structure. Either way, the goal is the same: know what you're trusting before you trust it.
Frequently asked questions
How often should I audit a spreadsheet?
Audit any sheet before you start relying on it, before you hand it to someone else, and after any major structural change such as adding columns, restructuring tabs, or changing data sources. For shared sheets that many people edit, a periodic review catches the hand-edits and broken references that accumulate over time.
What's the most common issue in a spreadsheet review?
Inconsistent formulas within a column — a single hand-edited cell that breaks an otherwise uniform pattern — is one of the most common and most damaging problems, because it produces wrong numbers without ever showing an error value. Broken references and unmanaged external imports are close behind.
Do I need access to external sources to audit a sheet?
Not to find the dependencies — you can locate every IMPORTRANGE or IMPORTXML by searching the formulas. But to fully trust the sheet, you do need to confirm you have access to each source and understand what breaks if it changes or disappears. Listing those dependencies is often the single most valuable part of an audit.
