New: Detect Hardcoded Magic Numbers

Stop your spreadsheets from breaking silently.

The automated auditor for Google Sheets. Detect risky VLOOKUPs, fix reference drift, and quantify spreadsheet risk in seconds.

Privacy-first: by default, spreadsheet content stays in Google Sheets.

SheetSage Analysis

Workbook Health

Critical Risk

R1: VLOOKUP_EXACT High Risk

25 formulas missing "FALSE" argument.

R4: ANCHORING Medium

12 ranges drifting on copy/paste.

R5: HARDCODED Advice

36 "Magic Numbers" detected.

Snapshot taken 2m ago Restore

Demo

See SheetSage in action

A short walkthrough of the scan → review → fix → restore workflow.

When you have the Marketplace listing URL, update the “Install” button.

Why Analysts Trust SheetSage

5+ Rules
Covering exact matches, anchoring, and hardcoded values.
1-Click Fix
Safely patch 1,000+ formula errors instantly.
100% Local
Code runs in your sheet. No data exfiltration.

It's not just a spell-checker. It's an auditor.

Most errors in financial models come from lookup failures and formula drift. SheetSage targets the root causes.

VLOOKUP Hygiene

Detects missing FALSE arguments that cause approximate matching disasters. Also flags invalid column indices.

Drift Protection

Finds lookup ranges like A1:B10 that lack $ anchors, preventing them from shifting when you copy formulas down.

Magic Number Detection

Spot hardcoded thresholds (e.g., * 1.05) buried in formulas. Extract them to assumption cells for better maintainability.

Smart Clustering

Don't fix 5,000 rows one by one. SheetSage groups repeated formulas into a single "Cluster," letting you fix the pattern instantly.

Snapshot & Restore

Every fix creates a hidden snapshot. If a fix breaks your logic, hit "Restore" to revert instantly. Zero risk refactoring.

Privacy First

Built on Apps Script. Analysis happens within your Google session. No data, formulas, or cell values are sent to external servers.

Audit your workbook in 3 steps

1

Launch & Scan

Open Extensions > SheetSage. Click "Scan Workbook" to analyze every formula in seconds.

2

Review Priorities

See your Health Score. Issues are ranked by risk and clustered by formula pattern.

3

Fix with Confidence

Apply auto-fixes for VLOOKUPs or anchoring. Use guidance to refactor hardcoded values.

Privacy Policy

Enterprise-friendly by design: audit locally, keep control, and share only what you choose.

Effective date: 30 December 2025

Privacy at a glance

  • Runs inside Google Sheets (Apps Script) under your Google session.
  • No spreadsheet content is sent to our servers by default.
  • Snapshots stay in your workbook (hidden snapshot sheet) so restores are instant.
  • Local-only metrics (optional): stored in Google Apps Script properties; no formulas, sheet names, or cell addresses.
  • You control sharing: nothing leaves unless you copy/export a summary or send info to support.

Read the full policy

The complete Privacy Policy and Terms are available as standalone pages.

Install SheetSage

The Google Workspace Marketplace listing link isn't set yet. When it's ready, this button will point to the install page.

Requires Google Sheets - No credit card required