Which row's column count is reported as the main count?

The header row's column count is the primary number reported, since that's normally what defines a CSV's expected width.

What does 'ragged' mean here?

A ragged CSV is one where at least one data row has more cells than the header row does, which usually signals an unescaped delimiter or a malformed row somewhere in the file.

What if a data row has fewer columns than the header?

That's not flagged as ragged by this tool, since a short row is common (e.g. trailing optional fields) and doesn't affect the header-defined column count; use CSV Dimensions Finder if you want the absolute widest row's count regardless of direction.

How is this different from CSV Dimensions Finder?

CSV Dimensions Finder reports both row and column counts together as a general size summary. This tool focuses specifically on columns and explicitly calls out ragged-row detection.

CSV Column Counter - Count & Detect Ragged Rows

Overview

Introduction

A CSV's column count usually matters more than its row count when you're deciding how to process it, especially if some rows might be malformed. This tool reports the header's column count and flags ragged rows.

It's a quick sanity check before running a column-based tool like CSV Cutter or CSV Cell Filter.

What Is CSV Column Counter?

A column-focused CSV analyzer: it reports the header row's column count as the primary number, and separately checks whether any data row has more columns than that, flagging the file as ragged if so.

It's the columns-focused sibling of CSV Row Counter and the more general CSV Dimensions Finder.

How CSV Column Counter Works

The CSV is parsed with the shared grid parser. The header row's length becomes the primary column count. Every row's length is then compared to find the maximum across the whole file.

If that maximum exceeds the header's column count, the file is reported as ragged, along with the widest row's actual count.

When To Use CSV Column Counter

Use it before running any column-index-based tool (like CSV Cutter) to confirm the expected column count.

It's also a quick way to catch a malformed export where an unescaped delimiter created extra columns somewhere in the file.

Often used alongside CSV Dimensions Finder and CSV Row Counter.

Features

Advantages

Clearly separates the header-defined column count from any wider data rows, rather than silently averaging or guessing.
Fast, single-pass detection of ragged CSVs that might otherwise cause subtle bugs downstream.
Simple, focused output aimed specifically at understanding column structure.

Limitations

It doesn't flag rows that are narrower than the header, only ones that are wider.
It reports that a file is ragged, but not which specific row is the widest one.

Examples

Detecting a ragged CSV

Input

id,name
1,Ada
2,Alan,extra

Output

Header row column count: 2
Widest row column count: 3 (this CSV is ragged: at least one row has more columns than the header).

Row 2 has three cells (id, name, and an extra one) even though the header only defines two columns, so the file is flagged as ragged.

Best Practices & Notes

Best Practices

Investigate any ragged CSV before running column-index-based tools on it, since an extra unexpected column can shift indices.
Use CSV Data Finder to help locate exactly which row introduced the extra column if a file is flagged as ragged.
Treat a ragged result as a signal to check the source export for unescaped delimiters.

Developer Notes

Ragged detection compares the header's length against Math.max over every row's length rather than every row individually, which is enough to flag the condition but intentionally doesn't pinpoint every offending row; that's left to a more targeted search tool.

CSV Column Counter Use Cases

Sanity-checking a CSV's column count before running an index-based column tool on it
Catching malformed exports where an unescaped delimiter created extra columns
Quickly confirming how many fields a CSV export is supposed to have

Common Mistakes

Assuming a CSV isn't ragged just because the header count looks right; a later row can still be wider.
Expecting this tool to identify exactly which row is ragged; it only reports that at least one is.

Tips

If a file is flagged ragged, try CSV Data Finder with a regex to help pinpoint suspiciously long rows.
Re-export the source data with a different delimiter if ragged rows keep appearing due to unescaped values.

CSV Column Counter