PixelOkay
✧ FREE TOOL
Tools
✧ INTELLIGENT SPREADSHEET AUDITING BROWSER BASED

Spreadsheet Formula Detective

Uncover broken formulas, trace what influences a cell, spot unusual values, and understand how results are derived — without sending your workbook anywhere.

✓ Formula dependency maps✓ Suspicious result checks✓ Private by default
⇧
Drop a spreadsheet to investigate

or select an Excel / CSV file from your device

.XLSX.XLSM.CSV.TSVMAX 25 MB
On-device text model; no upload or model download until you explicitly approve.
Just exploring?
⌁
Trace any formula

Explore upstream inputs, downstream dependents, and saved values.

⚑
Detect subtle issues

Catch circular loops, broken references, anomalies and overwritten formulas.

✦
Explain with confidence

Understand calculations with transparent, verifiable reasoning.

Understand your Excel formulas, not just their numbers

PixelOkay Spreadsheet Formula Detective is a free, local-first Excel formula analyzer for reviewing complicated workbooks. Import an XLSX or XLSM file to inspect stored formulas, their references and cached results. Import CSV or TSV to look for unusual numeric data or formula-like text.

What does this Excel formula checker inspect?

Broken #REF! expressions, missing worksheets, circular dependencies, inconsistent copied formulas, hard-coded overrides, unusual numeric values, volatile functions and suspicious differences in saved results. The formula explorer provides direct and bounded transitive dependency tracing for many ordinary A1 references, with explicit warnings when references are not fully expanded. The searchable formula catalog supports workbook-wide investigation. The built-in quick verifier evaluates only a documented subset of arithmetic and aggregate functions; it is not a substitute for Excel’s calculation engine.

Is my spreadsheet uploaded?

No. Files are read and analyzed in this browser session, using built-in web platform capabilities. Nothing is submitted to a service. Optional on-device WebGPU AI explanations require your consent to download and load a compatible local text model; your workbook contents are not uploaded to an inference service.

LOCAL AI SETUP

Set up AI on this device

First, a model needs to be loaded on your device

Optional formula explanations use a local WebGPU text model. The first run may download large model files and runtime JavaScript from external CDNs after you choose Download & Load Model. The text model receives ONLY limited selected formula data and summarized findings (not the entire workbook). It never receives spreadsheet files themselves.

  1. 1. Check device
  2. 2. Download / cache
  3. 3. Prepare formula assistant
  4. 4. Review spreadsheet findings

Device & model resources

Measurements may be approximate
Device RAM / model memoryChecking device information…

Live system RAM, model RAM and GPU memory are not reliably exposed in browsers.

Browser website storageChecking storage…

Site-wide estimate; includes other PixelOkay tools and is not RAM.

ONE ACTION · ALL RECOGNIZED AI MODEL DOWNLOADS

Free AI model storage across PixelOkay

Scan this website origin for WebLLM and Transformers.js model caches, plus recognizable model files in other cache buckets. This includes caches from other PixelOkay tools, not only this tool. No site data or browser databases are cleared automatically.

Run a scan to see how many model caches can be cleared together.

Browser-native models and unknown IndexedDB/OPFS or private runtime caches may remain. Unknown application/user storage will not be deleted. Other running tools might redownload caches; close their tabs first.

Having trouble downloading or loading AI?

Old or incomplete AI model downloads may be using your browser's storage. First refresh the storage meter or try a smaller model. If setup still fails, inspect and remove recognized AI model caches with confirmation, then download again.

Only model caches are targeted. Other PixelOkay tools may need to redownload their models. Never clear all website data without exporting important chats and projects first.

Select “Check device” to see whether the current model can run.
Technical details and sanitized diagnostics

Diagnostics contain model ID, runtime stage, storage estimate and response timings only. No workbook, transcripts, filename, tokens or prompt text.

This model is for text-based formula explanations. Your original formula checks remain available without a model.
CROSS-TOOL MODEL CACHE CLEANUP

Delete all recognized AI model downloads?

Deleting these caches will cause other PixelOkay tools to download their models again. Loaded AI sessions in other tabs may be disrupted. Unidentified model caches and browser-managed models may remain.

Data-loss caution: This action does not intentionally delete saved chats, projects, drafts, localStorage or IndexedDB. Do not clear website data unless you have backed up work; clearing all website data may permanently erase saved work.

Using Spreadsheet Formula Detective

Inspect workbook or delimited-text formulas and saved values, follow a bounded set of A1 references and flag review leads without modifying the source file or running macros.

  1. Open a supported XLSX/XLSM workbook or CSV/TSV file within the size/cell limits; confirm the worksheet and formula counts in the overview.
  2. Select a formula to inspect its bounded A1 dependency trace, saved result and any narrow numeric consistency check; review unresolved references and anomaly leads against the workbook.
  3. Export selected findings as CSV/JSON or trace text; preserve the original file because this tool is read-only.

Example: In a workbook with a totals formula, inspect the referenced cells, check whether a saved result looks stale, and export the trace as a review note without changing the workbook.

Limits and privacy: Analysis is read-only and does not execute macros or rewrite the workbook. Saved formula values can be stale; quick verification covers only a narrow numeric subset. Named, structured, external, dynamic and oversized references remain unresolved. Inputs are limited to 25 MiB and 140,000 populated cells. Optional local WebGPU text AI is not required; setup downloads runtime/model files from external hosts after selection and may disclose the visitor IP. No findings do not certify workbook correctness.

Related tools