Workbook Analyzer

Profile every sheet, column and formula in one report.

A full health check for a workbook: row and column counts, data types per column, null rates, distinct values, formula inventory, external links and the largest contributors to file size. The report is the fastest way to understand a file someone else built.

Rating
4.9(1.4K)
Monthly uses
168K
Price
Free

or drag it here

.xlsx, .xls, .xlsm, .ods · processed locally, never uploaded

Files stay on your device

What it does well

  • Column-level profiling: type, nulls, distinct count, min/max and samples
  • Formula inventory grouped by function with usage counts
  • External link and volatile function detection with recalculation cost

How to use Workbook Analyzer

  1. 1

    Upload the workbook to analyse.

  2. 2

    Wait for the profile to build — a few seconds for most files.

  3. 3

    Explore per-sheet and per-column statistics.

  4. 4

    Download the report as XLSX or PDF.

Watch a walkthrough

How to use Workbook Analyzer

2 min 18 s · captions included

Watch on YouTube

Common problems and fixes

The analysis stalls on a very large file.

Turn on sampling, which profiles the first 50,000 rows per sheet — enough for accurate type and null statistics.

Column types are reported as mixed.

That is a real finding, not a bug: the column genuinely contains more than one type. Run the Data Validator to see which rows differ.

Frequently asked questions

What people say

Our IT team blocked every other online tool because they upload files. This one does not, so workbook analyzer finally got approved for use on real data.
Ines Duarte · Operations Manager ·
Fast, no signup wall, no watermark. I have sent the Workbook Analyzer link to half my department.
Hannah Whitfield · Business Analyst ·
Fast, no signup wall, no watermark. I have sent the Workbook Analyzer link to half my department.
Rajiv Menon · Office Manager ·

More analyse tools

Profile every sheet, diff two versions cell by cell, read hidden metadata and find the bloat that makes a workbook slow to open.

Browse Analyse