Bill of Materials Cleaner (Python Automation)
A Python script that turns a messy parts list into a clean bill of materials in one command.
The screenshot shows a real run: 8 raw rows with duplicate part numbers in different cases, comma decimals ("2,50"), extra spaces, a blank row and a missing supplier were cleaned into 5 merged parts with line totals and a BOM total of $43.10.
What it does:
- Merges duplicate part numbers and adds up quantities
- Fixes decimal commas and normalises text and capitalisation
- Skips blank rows and flags missing suppliers as UNKNOWN
- Calculates line totals and the overall BOM cost
- Exports a clean CSV ready for Excel or your ERP
Tools: Python 3 standard library (csv), no extra installs.
Published