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
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
CSV row counter in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your CSV files
Drop one or many CSV, TSV or TXT files on the page.
- STEP 02
Choose the options
Say whether row 1 is a header and set the separator, or leave it on automatic.
- STEP 03
Read the report
Each file gets a short summary you can read or download.
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.
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 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.
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 |
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.
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.