Spreadsheet tools Free · No sign-up · No upload

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
Choose spreadsheetor drop it here · XLSX, XLS, ODS, CSV, XLSM
Sheet name or number. Leave empty for the first sheet. Not used for CSV.
Leave empty for every column.
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: XLSX → OUT: TXT
How was Spreadsheet column statistics?
How it works

Spreadsheet column statistics in three steps

No account, no email, no waiting for an upload.

  1. 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.

  2. 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.

  3. STEP 03

    Download the summary

    Read the report, or open the CSV in a spreadsheet.

What you get

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.
Private by design

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 device→Their server→Your device

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

Your device does all the work

The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.

Made for real work

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.

Compare

Mediaextractr vs typical upload tools

MediaextractrPrivateTypical upload tools
Your file is uploadedNeverYes
Sign-up neededNoOften, after a few files
Daily file limitNoneOften 1–2 free files
WatermarkNeverSometimes
Wait for upload & downloadNoYes
Speed on very large filesDepends on your deviceDepends 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.

FAQ

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.