Count the rows in a CSV file
How many rows does the file really have? Counted properly — quoted line breaks and all — for a file of any size, without opening it in a spreadsheet.
Source
or drag one here · it stays on your device
Result
Add a file and the count appears here — rows, blank rows, columns, heading.
Download
Have a look at the result before downloading it.
How this works
- Add your file. Drop a CSV onto the page, or pick one.
- Read the count. Rows, columns, blank rows, and the heading.
- Optionally count per value. Pick a column for a breakdown.
What it cannot do
- A count is a count: for what is inside the rows, the health check reads the same file.
Questions
- Why is this different from counting lines?
- A value can contain a line break inside quotes, so a line count over-counts. This counts records the way a CSV reader does, and reports the blank rows separately.
- Does it count the heading row?
- The count shown is data rows; the heading is reported on its own line.
- How big a file can it count?
- Any size the disk holds — it reads the file once, from disk, without loading it.
- Can I get a count per value, like rows per status?
- Yes — pick a column and the page shows how many rows hold each value, the way a pivot count would.
- Is my file uploaded anywhere?
- No. When you count the rows in a CSV file here, the work happens inside this page and the browser is told to block outbound connections, so there is no upload to intercept. Watch the Network tab of your developer tools while you count the rows in a CSV file: the only requests are for this site’s own code, and none carries your file.
Your file is processed in this page and never uploaded — the privacy page shows how to confirm that yourself.