Updated · Built and checked by the PlinzoTools team, formulas tested against published sources
Count the number of data rows in CSV data (excluding the header).
This tool counts the number of data rows in pasted CSV data, treating the first line as a header and excluding it from the count -- a quick way to check how many actual records are in an export.
Paste your CSV data. The data row count updates instantly.
Besides the data row count, this tool also displays a second figure: the number of columns. The column count comes from the first line of your input, which is treated as the header. The data row count is the total number of parsed records minus one. If you paste nothing, both numbers show 0. If you paste only a header line, the tool reports 0 data rows and the number of columns in that header, which is a handy way to confirm that an export contains headers but no records.
The tool does not simply count line breaks. It runs your text through a small CSV parser that understands quoted fields. A field wrapped in double quotes can contain commas, and it can even contain line breaks, and it still counts as part of one record. Two quotation marks in a row inside a quoted field are read as a single literal quote character. This matters because exports from CRM systems, survey tools, and support desks often include multi-line comment fields. A naive line counter would report far more rows than you actually have; this tool reports the number of real records.
Completely empty lines are ignored, so a trailing blank line at the end of a file, or a gap between blocks, does not inflate the count. Both Windows-style (CRLF) and Unix-style (LF) line endings are handled.
Suppose you paste the following, using made-up data:
A plain line count would give five lines, or four after removing the header. The tool reports 3 data rows and 3 columns, because the note for Bob spans two physical lines but is one record. The comma inside Alice's note also does not create a fourth column.
A quick count is a good sanity check before and after any data operation. Before importing a contact list into an email platform, compare the count with what the source system said it exported. After removing duplicates or extracting columns, count again to confirm you did not lose records unexpectedly. It is also useful when a spreadsheet application struggles with a large file: you can paste a sample to check that its structure parses cleanly. Because everything runs in your browser, the data you paste is not uploaded anywhere, though very large files may be slow to paste into a text box, so for files with hundreds of thousands of rows a command-line tool may be more practical.
The tool assumes the first line is a header and excludes it -- if your data has no header, the reported count will be one less than the actual data row count.
Yes. The parser follows standard CSV quoting rules, so a quoted field that contains line breaks is kept inside a single record and counted once.
The tool splits on commas only. If your file uses semicolons or tabs, it will look like one column. Convert the delimiter to commas first and paste it again.
No. Empty lines are skipped, so trailing newlines at the end of a file will not increase the row total.
You can, but the first record will be treated as the header and left out. Add one to the displayed count, or insert a placeholder header line at the top before pasting.