Spreadsheet Column Statistics
Profile a sheet or CSV column by column: how many values are filled, how many are unique, and the sum, mean, median, minimum and maximum. All in your browser.
- Free, no sign-up
- Files stay on your device
- Per-column summary
- Report or CSV table
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Spreadsheet column statistics in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your file
Bring in your workbook or CSV from your device. For a workbook, name the sheet or leave it empty for the first.
- STEP 02
Choose columns and output
Analyse all columns or list some. Pick a readable report or a CSV table with one row per column.
- STEP 03
Download the summary
Read the report, or open the CSV in a spreadsheet.
What Spreadsheet column statistics does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Fill levelsFor each column, how many cells are filled, how many are empty and how many different values appear.
- Number summariesSum, minimum, maximum, mean, median and standard deviation for numeric columns.
- Type guessEach column is labelled number, date, text, mixed or empty.
- Dates and textDate columns show the earliest and latest date, and text columns show the shortest and longest lengths.
- Most common valuesThe top repeated values are listed, with their counts.
Good to know
- One sheet per runChoose the sheet you want, since each run analyses one.
- Numbers stored as textValues like 1,250 are counted as numbers, but percent signs and currency symbols are not. Clean them with Convert numbers stored as text first.
- Sample standard deviationThe spread is calculated with n minus 1, like Excel's STDEV.S.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Spreadsheet column statistics
Quick data quality check
Spot empty columns, odd types and unexpected unique counts.
Get totals without formulas
See sum and average per column without writing any.
Understand an unfamiliar file
Learn what a dataset holds before you analyse it.
Teach basic statistics
Show how mean, median and spread differ.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
Reading the report
Each column gets a block with its letter and name, then counts, then the numeric summary when it applies. A big gap between mean and median hints at outliers. A unique count equal to the row count suggests an ID column.
Using the CSV table
Choose the CSV output and every column becomes one row in a table with fields for filled, empty, unique, type, sum, min, max, mean, median, standard deviation and the most common values. That makes it easy to sort or filter the profile itself.
To count rows and sheets first, try the Excel row counter or CSV row counter. If you find dirty dates, fix them with Normalize date columns.
Questions, answered
How do I get a summary of every column in Excel?
Add the file here, then read the report that appears. Each column shows counts, unique values and numeric statistics.
Is my data sent anywhere to calculate the statistics?
No. All calculations run in your browser.
Which statistics are included?
Filled, empty and unique counts, sum, minimum, maximum, mean, median and standard deviation for numbers, plus most common values.
Can I analyse a CSV?
Yes, CSV files are supported, with automatic separator detection.
Can I limit it to some columns?
Yes, list them by header, letter or number.
Does it work on phones and Macs?
Yes, in any current browser.