- Home
- Skills
- Business & Operations
- nex-bom-normalizer
Works with the AI tools you already use
Nex Bom Normalizer
Standardize, deduplicate, and clean messy Bill of Materials (BOM) files into procurement-ready CSVs.
Free
nex-bom-normalizer
Example session with this skill installed
Clean up this messy parts list in source_bom.xlsx and give me a standardized CSV for the assembly house.
- Read your context and instructions
- Compiled the nex-bom-normalizer
- Generated the data export
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.
nex-bom-normalizer.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
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.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
1 install
Downloaded by developers to date
Free forever
No account required to browse
Trust & safety
Security scanned
Verified clean 1 month ago
- Free to download with an account