Spreadsheet tools Free · No sign-up · No upload

CSV Row Counter

Get an instant count of the rows and columns in a CSV, plus its separator and encoding. The file is read in your browser, so it stays on your device.

  • Free, no sign-up
  • Files stay on your device
  • Counts rows and columns
  • Separator and encoding
Choose csv filesor drop them here · CSV, TSV, TXT
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: CSV → OUT: TXT
How was CSV row counter?
How it works

CSV row counter in three steps

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

  1. STEP 01

    Add your CSV files

    Drop one or many CSV, TSV or TXT files on the page.

  2. STEP 02

    Choose the options

    Say whether row 1 is a header and set the separator, or leave it on automatic.

  3. STEP 03

    Read the report

    Each file gets a short summary you can read or download.

What you get

What CSV 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 rowsCounts rows below the header, plus total lines with records.
  • Blank rows foundReports how many rows are completely empty.
  • Column count and ragged rowsShows the widest row and how many rows have fewer fields, which often signals a broken line.
  • Separator and encodingTells you whether the file uses commas, semicolons, tabs or pipes, and whether it is UTF-8, has a BOM or is Windows-1252.
  • Quotes respectedA cell with a line break inside quotes counts as one row, not two.

Good to know

  • Whole file in memoryThe file is read into your browser as a whole, so extremely large files may not fit, particularly on phones.
  • Counts onlyNothing in the file is changed. Use Remove duplicate CSV rows to clean up.
  • Guessed separatorAuto-detection can be wrong for unusual files. Set the separator manually if the column count looks off.
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 CSV row counter

Verify an export

Check that a download has the number of records you expect.

Check a list before upload

Confirm you are within a tool's row limit.

Debug a broken import

Rows with too few fields explain many import errors.

Size up a dataset

Know whether a file will fit in Excel's million-row limit.

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

Lines versus rows

A text editor counts lines, but a CSV row can span several lines when a cell contains a line break inside quotes. This tool parses the file properly, so the number you get is the number of real records.

What the extra details tell you

The ragged-row count flags lines with fewer columns than the widest one. That usually means an unclosed quote or a missing field.

The encoding line helps with garbled accents. If it reports Windows-1252 and you need UTF-8, convert with the CSV encoding converter. If the count of columns seems wrong, run Detect CSV separator. For Excel files, the matching tool is Excel row counter.

For a quick sanity check before an upload, read the data row count and the column count together. If a tool allows 10,000 rows and you have 10,400, you can split the file into two parts with the splitter.

FAQ

Questions, answered

How do I count the rows in a CSV file?

Open the file and read the summary it produces. It lists data rows, total records and columns.

Is my CSV read on a server?

No. It is read in your browser.

Does it count the header row?

Data rows exclude it when the header option is on. The total line count includes it.

Can it handle very big files?

It depends on your device memory, since the file is read whole. A computer manages far more than a phone.

What are ragged rows?

They are rows with fewer columns than the widest row, which can hint at a damaged line.

Does it work on Windows, Mac and mobile?

Yes, in current browsers.