Works with the AI tools you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+22 more

    Nex Bom Normalizer

    5

    Standardize, deduplicate, and clean messy Bill of Materials (BOM) files into procurement-ready CSVs.

    Free

    1 installSecurity scanned
    nex-bom-normalizer

    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

    Generated

    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.

    ~30 seconds
    1. 1

      Download the ZIP

      Free skills download straight away. Paid skills unlock right after purchase.

    2. 2

      Unzip into your skills folder

      Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.

    3. 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

    Needs access to

    Nex Ai

    Listed1 month ago

    What's inside

    Frequently Asked Questions