Know how many records are actually in the file
A row total is a small number that can catch a big problem. If last week’s customer export had 8,400 records and today’s has 840, it is easier to spot the missing zero before the file goes to a mailing platform. A count is also handy when checking a vendor delivery, reconciling an import, estimating how many records need review, or confirming that a filter produced the expected number of rows.
This counter reads the CSV structure rather than treating every line break as a new record. That matters when a quoted note or address contains a line break: it can span more than one physical line while still belonging to a single CSV row.
Decide whether the first record is a heading
Most spreadsheet exports start with a heading row such as Order ID,Status,Amount. Keep First row contains column names checked to exclude that row from the data count. If your file has no headings and begins directly with a record, turn the option off so the first record is counted too.
Truly empty lines are skipped. A row containing delimiters but blank cells, such as ,,, is still a record and counts. This distinction helps explain why the total may differ from a text editor’s line count.
Use the count as a quick file check
Upload or paste the file and the counter shows the data-row total alongside the column count. The table preview lets you confirm that the first record is being interpreted as expected. You can copy the number for a message or download a compact CSV report with the row total and header setting.
This is a structural count, not a data-quality check. It does not decide whether a row has a valid email, complete fields, or a unique ID. Use CSV Validator to inspect formatting, or CSV Row Filter to count records that meet a condition.
Questions about CSV row counts
Does the count include the header row?
By default, no. The first row is treated as column headings. Turn off the header option when the file has no heading row and you want to count every record.
Why does this total differ from the number of lines in a text editor?
A quoted CSV field can contain a line break, so one record may span multiple physical lines. The counter counts parsed records and ignores truly empty lines.
Do rows with blank cells count?
Yes, if the row is present in the delimited data. For example, a row containing separators with empty values still counts as a record.
Can I count a file without column headings?
Yes. Turn off First row contains column names to include the first record in the total.
Can I save the count for a report?
Copy the total or download the small CSV report. The original data file is not changed.
Is the file uploaded?
No. The counter reads the selected data in your browser.
Need a closer look at the rows?
Open the data in the CSV Table Viewer, or use CSV Row Filter when you need a count for records matching a condition. Browse all CSV tools.