nex-bom-normalizer
Skill1 starsChanged 15 days agoMITView on GitHub
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.
In this repository79 other files it gives its agents.
- nex-ai-skillsSkill
- agent-checkpointSkill
- agent-ready-website-converterSkill
- fastapi-repo-security-preflightSkill
- kostprijs-calculatorSkill
- landing-page-conversion-auditSkill
- md-context-writerSkill
- nex-accent-contrast-extSkill
- nex-ada-web-accessibilitySkill
- nex-ai-literacy-packSkill
- nex-auto-sector-packSkill
- nex-belgian-search-trinitySkill
- nex-brand-palette-liteSkill
- nex-clean-copy-extSkill
- nex-clean-page-extSkill
- nex-cold-mail-1-templateSkill
- nex-color-spy-extSkill
- nex-component-library-formatterSkill
- nex-coppa-2026-packSkill
- nex-datasheet-extractorSkill
- nex-einvoice-deSkill
- nex-einvoice-esSkill
- nex-einvoice-frSkill
- nex-einvoice-plSkill
- nex-employee-handbook-usSkill
- nex-eu-accessibility-auditSkill
- nex-eudr-due-diligenceSkill
- nex-eu-hardware-compliance-docsSkill
- nex-favv-food-packSkill
- nex-font-grab-extSkill
- nex-frame-it-extSkill
- nex-full-capture-extSkill
- nex-gdpr-deepeningSkill
- nex-govcon-capture-packSkill
- nex-grant-writer-usSkill
- nex-hipaa-small-practiceSkill
- nex-hoa-management-packSkill
- nex-iso27001-kmo-packSkill
- nex-kinderopvang-adminSkill
- nex-kmo-portefeuille-flowSkill
- nex-landbouw-adminSkill
- nex-life-loggerSkill
- nex-manufacturing-handoff-packSkill
- nex-mcp-client-deliverySkill
- nex-medical-billing-priorauthSkill
- nex-meeting-finderSkill
- nex-offerte-generatorSkill
- nex-one-sector-classifierSkill
- nex-overheidsopdrachten-tenderSkill
- nex-page-watchSkill
- nex-prompt-booster-extSkill
- nex-property-mgmt-usSkill
- nex-receipt-vaultSkill
- nex-riziv-zorgpraktijkSkill
- nex-sales-tax-nexusSkill
- nex-screencast-cleanerSkill
- nex-single-section-htmlSkill
- nex-site-trust-extSkill
- nex-syndicus-vme-packSkill
- nex-tab-cost-extSkill
- The first 60 shown.
The file
We split this skill into the rules it gives an agent
1 rule. About 0 are common, 1 is distinctive, and 0 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈1
Distinctive · estimate
This author's own choices. Worth a look.
0
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- Distinctive: line 45
Does not perform external API lookups for pricing or stock.
≈ “Common” is an estimate: at least 1 in 5 of the 364,980 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
Nex BOM Normalizer
Free 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.
The problem
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.
What it does
- Standardizes inconsistent column headers into a canonical set (RefDes, Qty, MPN, Manufacturer, etc.).
- Deduplicates parts by merging rows based on Manufacturer Part Number and Manufacturer name.
- Normalizes reference designators into comma-separated, uppercase strings.
- Calculates and updates total quantities automatically during the merge process.
- Flags rows with missing required fields (MPN, Qty, Manufacturer) into a separate CSV for manual review.
Frameworks & tools
Python-based CLI tool (scripts/normalize.py). Works with CSV and XLSX input files.
Why this beats prompting it yourself
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.
Use cases
- Cleaning messy exports from Altium, KiCad, or Eagle for procurement.
- Merging multiple partial BOMs into a single master component list.
- Preparing parts lists for pick-and-place machine programming.
- Identifying missing part data before sending a quote request to a CM.
Known limitations
Does not perform external API lookups for pricing or stock. Data normalization is strictly local based on the provided input file.
Example
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.
- Merged 4 duplicate rows.
- Standardized columns to RefDes, Qty, MPN, Manufacturer.
- 2 rows flagged for missing MPNs in source_bom_flagged.csv. Cleaned file: source_bom_normalized.csv.
Questions
How does this skill help with hardware procurement workflows?
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.
What file formats and EDA tools are compatible with the nex-bom-normalizer?
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.
What is included in the download package?
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.
Does the skill notify me if there are missing part numbers or incomplete data?
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.
Why should I use this skill instead of just prompting a standard AI model to clean my CSV?
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.
Can this skill check for live stock levels or component pricing?
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
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

