CSV File Checker: what to check
Use this checker before an import when you need to know what is wrong, even if you plan to make the changes in another application.
What a CSV error checker can tell you
A CSV can open in a spreadsheet and still have a row with too many fields, a repeated header, or an unfinished quoted value. The checker reads the file as CSV and compares each record with the header. Valid empty values, quoted commas, escaped double quotes, and multiline cells are supported.
Errors describe structural problems. Warnings identify things that may be intentional, such as repeated records, edge whitespace, or a value that looks different from the rest of its column. A warning does not mean that the business value is wrong.
Use the line number in your error report
The header is record 1. A quoted cell can contain several physical lines, so record numbers and line numbers are shown separately. Jump to Exact Cell takes you to the affected record, even when it is on another preview page.
Download Error Report saves the category, severity, location, explanation, suggested correction, and resolution status. The report is generated on your device and can be shared independently of the full source file.
Check an import before changing data
Start with the reported errors, then decide whether the warnings matter for the receiving application. CommaMend checks CSV structure; it does not know every platform’s required headers, allowed dates, or account rules. Compare those requirements with the importer’s documentation. Repairs and manual changes stay in a separate working copy until you download it.
Try a real CSV example
| Name | Team | |
|---|---|---|
| Ada | Science | |
| Sam | Arts | Extra field |
The second data record has three fields under two headers. The checker identifies record 3 and physical line 3 without deciding which value should change.
Download the example CSVSelect the example in the tool above. Your file is processed locally, and changes require your approval.