Excel Row Counter

Count rows (total, non-empty, data rows) in every sheet of a workbook.

Runs in your browser — nothing uploaded Free · no sign-up
Loading tool…

How to use the Excel Row Counter

  1. Upload your XLSX, XLS or CSV file(s).
  2. Select the worksheet and check the preview of the first rows.
  3. Choose the options for this tool (headers are preserved by default).
  4. Run the tool and download the result.

About this tool

The Excel Row Counter works with XLSX (Excel 2007+), XLS (Excel 97–2003), ODS and CSV files, with a preview of the selected worksheet before you process it.

Data types are preserved: numbers stay numbers, dates stay dates and text keeps leading zeros where the source stored it as text.

Also searched as: count rows in excel · excel row count · number of rows in xlsx · csv row counter · count records

Supported formats and good to know

Input
XLSX, XLS, ODS, CSV
Output
On-screen report
  • Files are processed in your browser on your own device — they are not uploaded to our server.
  • Very large files depend on your device's memory; a desktop browser is fastest for big files.

Formula and method

Workbooks are parsed in your browser with SheetJS. Each sheet is read into a grid of typed cells, the operation is applied, and a new workbook is written in XLSX (Office Open XML) or the chosen format.

Practical examples

Upload or enter a sample, try the different options, and compare the output with your original.

Frequently asked questions

How large can the file be?

The file is loaded fully into your browser's memory; files up to about 100 MB or a few hundred thousand rows work on most computers. To turn a very large CSV into Excel, use CSV to Excel, which reads big files in pieces.

Are formulas kept?

The calculated values are kept. Tools that rewrite sheets save values (not formulas) to avoid broken references; the File Information Viewer lists formulas found.

Is my data private?

Everything happens locally in your web browser. Your files and text are never uploaded to our server, so the tool also works for confidential material.

Is the Excel Row Counter free?

Yes. It is free to use with no account required.

Related articles