Tiny Online Tools
A bill of materials export is rarely ready to hand to a supplier as-is. Column names differ between KiCad's own export, a hand-built spreadsheet and a distributor's format; the same part sometimes gets a different part-number string on different rows; and a row missing a designator or part number is easy to miss when you're scrolling through a few hundred lines.
This tool reads the CSV, detects which column holds the designator, value, footprint, part number, manufacturer and quantity — by header text, since none of that is standardized — and shows you exactly which column it picked for each field, so a wrong guess is visible instead of silently wrong. It then runs three checks: part numbers that appear on more than one row (a common sign of an unintentional duplicate, or just two rows that should have been merged), rows with no part number at all, and rows with no designator.
Components are also grouped by value and footprint, the same grouping a supplier's quoting system will do anyway, with combined quantities and designator lists. A KiCad export that (like some do) prints the same table twice — once per designator, once already grouped — is detected and only the first table is read, so nothing gets silently double-counted.
Two downloads are available: a grouped, cleaned CSV (one row per value+footprint group, combined quantities, and a flag when a group's rows disagree on part number) for handing to a supplier, and a flat normalized CSV that keeps the original one-row-per-line-item granularity with consistent column names.
Everything runs in your browser — the BOM is read and processed locally, nothing is uploaded.