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
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Excel row counter in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add one or more files
Drop Excel, ODS or CSV files on the page.
- STEP 02
Say if row 1 is a header
With the header option on, data rows exclude the heading row.
- STEP 03
Read the report
A text report lists each sheet with its counts, plus a grand total for multi-sheet files.
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.
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 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.
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 |
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.
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.