Standardize, deduplicate, and clean messy Bill of Materials (BOM) files into procurement-ready CSVs. Use when: Deduplicate component lists by merging matching MPNs and Manufacturers; Convert messy EDA exports into a canonical column format for procurement; Automatically fix and uppercase inconsistent reference designators.
66%
Does it follow best practices?
Run evals on this skill
Adds up to 20 points to the overall score
Passed
No findings from the security scan
Fix and improve this skill with Tessl
tessl review fix ./skills/nex-bom-normalizer/SKILL.mdFree skill by Nex AI. This file is the public guide from Agensi. Scripts, extension source, and templates from the original package are not in this folder.
Engineering and procurement teams waste hours manually cleaning inconsistent BOMs exported from different EDA tools. Messy reference designators, duplicate part entries, and non-standard column headers cause ordering errors and assembly delays.
Python-based CLI tool (scripts/normalize.py). Works with CSV and XLSX input files.
A generic LLM prompt often misses edge cases in part deduplication or fails to maintain strict column ordering. This skill uses a dedicated Python script to ensure 100% data integrity, providing a repeatable process with a detailed audit log of every fix applied.
Does not perform external API lookups for pricing or stock. Data normalization is strictly local based on the provided input file.
Request
Clean up this messy parts list in source_bom.xlsx and give me a standardized CSV for the assembly house.
Result
I've normalized source_bom.xlsx.
This skill automates the cleaning of messy Bill of Materials (BOM) files, standardizing headers, deduplicating parts based on MPN, and formatting reference designators to ensure your data is ready for procurement or PCB assembly.
The tool supports both CSV and XLSX file formats, and it is designed to work with exports from popular EDA tools like Altium, KiCad, and Eagle.
Your purchase includes the Python-based CLI tool (normalize.py), a detailed README for setup, and example input/output files to help you get started immediately.
Yes, the skill automatically identifies rows missing critical data like MPN or Quantity and exports them into a separate CSV file so you can quickly review and fix errors.
Unlike a generic LLM prompt that may hallucinate or skip lines, this skill uses a deterministic Python script to ensure 100% data integrity and provide a clear audit log of every change made.
The nex-bom-normalizer operates strictly locally on your input files; it does not connect to external APIs for real-time pricing or component availability lookups.
Built by Nex AI. More skills, including the paid catalog: https://www.agensi.io/creators/ch1n4-g3nd4x
NexaiGuy/nex-ai-skills
4034c84
Also appears in
since Nov 6, 2026
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.