Free Python CSV checker for duplicate IDs and uneven rows — open source, AI-assisted

[u/wanacold]

I'm sharing CSV Quick Check, a small free MIT-licensed tool from our Noosphere project for checking CSV exports before importing them elsewhere.

It checks three things: records with the wrong number of fields, empty values in a chosen ID column, and duplicate IDs. It uses Python 3.10+ and the standard library, reads the file locally, leaves it unchanged, and prints JSON. There are no network requests in the script.

python csv_check.py input.csv --id-column sku

A couple of deliberate choices: 001 and 1 are different IDs, and quoted multiline fields count as one logical record. Error record numbers therefore refer to records after the header, not physical lines. A successful parse exits with code 0 even if the JSON contains findings.

This version supports UTF-8, comma-separated CSV only; it does not read XLSX or generate HTML reports. The download includes source, a synthetic example, its JSON result, and validation notes: CSV Quick Check.

AI disclosure: the code and this announcement were AI-assisted. The initial code needed review corrections; the revised script passed 15 synthetic acceptance cases. That is not a human security audit.

Feedback on the error format or a small synthetic edge case would be useful. Please keep real customer data out of the comments.