CSV Row Length Checker: what to check
This check brings inconsistent column counts to the front of your review. Other CSV checks still run, so a quote problem will not be hidden.
Why CSV rows have different lengths
Each data record usually has the same number of fields as the header. A comma inside an unquoted product name can add a field. A missing separator can leave too few fields. A blank value between two separators is still a field and is not a row length error.
Counting commas alone is unreliable. A comma inside a quoted field is part of the value, and a newline inside quotes is part of the same logical record. The parser respects both before comparing field counts.
Choose the repair that matches your data
For an extra field, select the adjacent pair that belongs together. The fixed preview shows the combined value before Apply Fixes confirms it. CommaMend does not automatically assume that the first two fields should be merged.
For a short record, adding empty fields at the end is a suggestion, not proof that the missing values belong there. If a middle value is missing, use manual editing to place the intended values under the right headings. You can undo an approved repair.
Keep identifiers and record order intact
CSV values stay as text, including leading zeros in product codes or student identifiers. A field merge keeps the record in place and changes only the selected adjacent fields. After each repair, the file is checked again and the next remaining issue opens automatically.
Try a real CSV example
| SKU | Product | Price | |
|---|---|---|---|
| 0014 | Desk | large | 125.00 |
Four fields appear under three headers. If “Desk,large” is the product name, combine columns 2 and 3. Keep SKU 0014 and price 125.00 unchanged.
Download the example CSVSelect the example in the tool above. Your file is processed locally, and changes require your approval.