Analyze Excel Data Online — Instant Stats Report, Free, No Upload
Get a two-sheet stats report: row counts, blanks, unique values, min/max, averages and more. No upload, no sign-up — the file never leaves your device.
Drop one .xlsx, .xlsm, or .xls file here, or click to browse
Supports .xlsx / .xlsm / .xls · read-only · processed locally · never uploaded
How to Analyze Excel Data Online
- Drop one .xlsx, .xlsm, or .xls workbook — it is parsed entirely in your browser and never uploaded.
- Click Analyze data — there are no options to configure; every worksheet (except internal sheets whose names start with _) is scanned as-is.
- Review the summary: each sheet shows its name, rows, and columns, followed by workbook totals.
- Download the report as your-file-name-analysis.xlsx, containing the Overview and Columns sheets described below.
This is a read-only analysis. Your original workbook is never modified or saved — the download is a brand-new report file generated from the scanned values.
Reading the Report: Overview and Columns
The downloaded report contains exactly two worksheets:
| Sheet in report | What it contains |
|---|---|
| Overview | One row per worksheet with its name, total rows (including the header row), and column count. The last row, TOTAL, sums rows and columns across the whole workbook. |
| Columns | One row per worksheet per column with the full column-level statistics listed in the next table. |
| Column in Columns sheet | What it shows |
|---|---|
| Sheet | The worksheet the column belongs to. |
| Column | Excel column letter: A, B, C, …, AA. |
| Header | The first-row value as text; when the first cell is empty, the column letter is used instead. |
| Total | Cells in the column, including the header row. |
| Non-empty | Cells holding a value — whitespace-only text counts as empty. |
| Empty | Null/missing cells, empty strings, and whitespace-only strings. |
| Unique | Distinct non-empty values after normalization (dates become ISO timestamps). |
| Numbers | Numeric cells — booleans never count as numbers. |
| Texts | Text cells, excluding empty and whitespace-only strings. |
| Booleans | TRUE / FALSE cells. |
| Dates | Real date cells. |
| Min / Max | Smallest and largest values using the priority rules below; blank for a fully empty column. |
| Mean | Average of numeric cells only, rounded to 6 decimals; blank without numbers. |
| Max length | Longest character count among text cells; non-text cells contribute 0. |
How Each Metric Is Calculated
| Metric | Rule |
|---|---|
| Empty | A cell is empty when it is null/missing, an empty string, or a whitespace-only string (spaces, tabs, non-breaking or ideographic spaces). |
| Non-empty | Total minus empty — a cell containing just one space counts as empty. |
| Unique | Non-empty values are normalized before comparison: dates become ISO timestamps and missing cells become null. The number 1 and the text "1" are two different unique values. |
| Numbers / Texts / Booleans / Dates | Typed from the raw cell: typeof number → Numbers (booleans are excluded), TRUE/FALSE → Booleans, Date instances → Dates, strings → Texts. |
| Mean | Numeric cells are averaged only across numeric cells and rounded half-up to 6 decimal places. Columns without numbers show an empty Mean. |
| Min / Max | Numbers take priority: min/max run over numeric cells only. Without numbers, dates are compared by ISO timestamp; otherwise texts are compared lexicographically. Booleans are ignored for min/max. |
| Max length | Character length of text cells only; numbers, booleans, and dates contribute 0. |
The first row is treated as a header and its value appears in the Header column, but it is still counted in Total, Non-empty, and every other statistic — the scan never excludes it.
When You Need a Data Health Check
- Taking over an unfamiliar export: someone hands you a workbook you have never seen and you need a fast inventory of every sheet and column.
- Hunting dirty data: whitespace-only cells, numbers and text mixed in one column, unexpected empty columns, or repeated values.
- Assessing data quality before an import, migration, ETL job, or dashboard feed, so problems surface before they break a pipeline.
Limitations
- The analysis is read-only and statistical — it does not clean, fix, or delete anything; use the dedicated cleaning tools for that.
- Encrypted workbooks (a password is required to open them) cannot be read.
- Formulas are seen through their cached values, and cells Excel stores as text stay text even when they look like numbers or dates.
- Legacy .xls files are accepted, but the report is always produced as .xlsx.
The report is a value-level .xlsx rebuilt from the scanned data: cell styles, column widths, merged cells, and charts are simplified. Your original file keeps all its formatting — only the downloaded report is plain.
Frequently Asked Questions
Is this Excel data analyzer really free?
Yes — 100% free, with no sign-up, no watermark, and no file limit. Everything runs in your browser.
Is my workbook uploaded to a server?
No. Parsing, statistics, and report generation all happen locally in your browser with JavaScript. Your file never leaves your device.
Does the analysis modify my original file?
No. The scan is strictly read-only. The download is a separate, newly generated -analysis.xlsx report; your workbook stays exactly as it was.
What counts as an empty cell?
Null or missing cells, empty strings, and whitespace-only strings (plain spaces, tabs, non-breaking spaces, ideographic spaces). A cell that looks blank but contains spaces is counted as empty.
Why is Mean blank for some columns?
Mean is computed from numeric cells only. Columns that contain only text, booleans, dates, or no values at all show an empty Mean.
Are the number 1 and the text "1" the same unique value?
No — types come from the raw cell, so 1 (number) and "1" (text) are two distinct unique values and appear in different type counts.
Is the header row excluded from the counts?
No. The first row is treated as a header and echoed in the Header column, but Total, Non-empty, Unique, and all other statistics still include it.
Can it analyze encrypted or legacy files?
Password-protected workbooks cannot be read without the password. Legacy .xls, .xlsm, and .xlsx files are supported, and the report is always a modern .xlsx.
Related Tools
Need the full reference? Read COUNTIF in Excel: Syntax, Examples and Errors — syntax, examples, common errors, and FAQ.
Need the full reference? Read SUMIF in Excel: Syntax, Examples and Errors — syntax, examples, common errors, and FAQ.
Need to clean or edit the problems the report uncovered?
Open the free online Excel editor