Excel Analyzer – Workbook Profiling, Formulas & Quality Audit
Analyze Excel workbooks (.xlsx, .xls, .xlsm) locally in your browser. Audit multi-worksheet statistics, formula counts, error cells (#REF!, #VALUE!), cell type distributions, and data quality metrics.
📑 Workbook Worksheets Summary
0 sheets detected| Worksheet Name | Visibility | Total Rows | Total Columns | Populated Cells | Formulas | Merged Cells |
|---|---|---|---|---|---|---|
| Upload an Excel file or load sample workbook to inspect worksheet statistics | ||||||
📊 Active Sheet Cell Types
🛡️ Formula & Quality Audit Findings
📋 Executive Excel Analysis & Formula Audit Report
Analysis report will be generated here upon Excel file input...
Excel Analyzer Features
Complete workbook statistics, formula audits, and multi-sheet profiling
📑 Multi-Worksheet Profiling
Audits all visible and hidden sheets within a workbook, comparing row counts, cell counts, and formulas.
🧮 Formula & Error Audit
Tracks formula counts and highlights broken formula references (`#N/A`, `#REF!`, `#VALUE!`, `#DIV/0!`).
📌 Merged Cell & Structure Detector
Detects merged cell ranges (`!merges`) across sheets that may impair data export or pivot table creation.
📊 Cell Data Type Breakdown
Provides visual distribution progress bars for text, numeric, formula, boolean/date, and blank cells.
📋 Executive Summary Export
Generates downloadable text/markdown reports summarizing workbook health and statistical insights.
🔒 100% Client-Side Privacy
All calculations execute in local browser JavaScript. Your Excel files are never uploaded to remote servers.
Find workbook issues before you rely on the numbers
If a workbook has many sheets or formulas, it can be difficult to check it cell by cell. Start with the workbook summary to find formula errors, unusual cell types, merged areas, and other patterns that deserve a closer look before you share or use the spreadsheet.
Open the workbook and select the sheet or sheets you need to review.
Look at the worksheet metrics and formula audit. Note warnings such as broken references, unusual data types, or merged cells in areas where consistent rows are expected.
Inspect the affected cells in the original workbook and export or copy the summary if you need a review record.
A warning needs context
Merged cells may be intentional in a title or report heading but troublesome in a table that will be sorted or imported. A formula warning may affect a key calculation, while an unusual cell type can be correct for a mixed-purpose column. Check where the issue occurs and what the workbook is used for.
The analysis can point you to possible problems, but it does not prove that every formula is correct or that the workbook's business logic is sound. Keep the source workbook and verify important totals against a trusted reference.
Frequently Asked Questions
Is my Excel workbook safe during analysis?
Yes, 100%. Your Excel file (.xlsx, .xls, .xlsm) is parsed, profiled, and audited entirely inside your web browser's local memory using client-side JavaScript. Zero data or files are uploaded to any external server.
Which workbook metrics are audited by the Excel Analyzer?
The tool audits total worksheets, visible vs hidden sheets, row and column counts per sheet, formula counts, formula error detection (#N/A, #REF!), cell data type distribution, merged cells, and missing value ratios.
Which Excel file formats are supported?
The tool supports .xlsx, .xls, .xlsm, and .csv spreadsheet formats.
Can I export the workbook analysis report?
Yes! You can copy the generated text report, download the executive summary file, or click Export Stats CSV to save worksheet and column statistics as a CSV file.