Spreadsheet tools Free · No sign-up · No upload

Excel Row Counter

Find out how many rows and columns each sheet really holds, plus the used range and formula count. Your workbook is read locally and never uploaded.

  • Free, no sign-up
  • Files stay on your device
  • Every sheet reported
  • Hidden sheets flagged
Choose spreadsheetsor drop them here · XLSX, XLS, ODS, CSV, XLSM
  • 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 Excel row counter?
How it works

Excel row counter in three steps

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

  1. STEP 01

    Add one or more files

    Drop Excel, ODS or CSV files on the page.

  2. STEP 02

    Say if row 1 is a header

    With the header option on, data rows exclude the heading row.

  3. STEP 03

    Read the report

    A text report lists each sheet with its counts, plus a grand total for multi-sheet files.

What you get

What Excel row counter does, and what it doesn't

We'd rather tell you up front than surprise you after the download.

What you get

  • Data rows per sheetCounts rows that hold at least one visible value, ignoring empty rows.
  • Used rangeShows the range that really contains cells, such as A1:H1204, rather than a formatted area that stretches to a million rows.
  • Columns and filled cellsSee the width of each sheet and how many cells are filled.
  • Formula countShows how many cells in each sheet are formulas.
  • Hidden sheets markedA sheet that is hidden is labelled so you can spot it.

Good to know

  • Counts, not changesNothing is edited. To remove empty rows use Delete blank Excel rows.
  • Values onlyCells that look empty but hold a space are counted as empty in the row count because only visible text is considered.
  • Plain CSV filesFor plain CSV files, CSV row counter adds separator and encoding details.
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 Excel row counter

Check an export is complete

Compare the row count with what the source system said it exported.

Find why a file is huge

A used range far larger than the data points to stray formatting.

Plan an import

Know how many records you are about to load.

Confirm a dataset size

Verify the rows in a downloaded dataset.

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

Why the numbers can differ from Excel

Excel's status bar and Ctrl+End may report a last cell far below your data because of old formatting. This tool counts real cell content, so its used range reflects the data you can actually see.

A quick checklist

Run the counter before and after you clean a file, then compare the numbers with the notes in each tool. If you merged files, the count should equal the sum of the parts.

To see more about every column, such as unique values and totals, open Spreadsheet column statistics. To look for hidden sheets and other file details, use the Spreadsheet metadata viewer.

The counter also works as a quick sanity check on imports. If a sheet should hold 5,000 customers and the report says 4,998 data rows, you know to look for two lines that went missing before you load anything.

FAQ

Questions, answered

How do I count rows in an Excel file without opening it?

Add the file here. The report lists the row and column count for every sheet.

Does counting upload my workbook?

No. Counting happens in your browser.

Does the count include the header?

Not when the header option is on. The report also shows rows with any value.

Can I count several files together?

Yes, add them all and each gets its own report.

What is the used range?

It is the block of cells that actually contains data, for example A1:F500.

Does it work on iPhone, Android and desktop?

Yes, in any modern browser. A phone is fine for a quick count of a small file.