Ext Qty
What the build consumes
The table multiplies per-board quantity by total build quantity so engineering can see the true material demand for this run.
Drop an Excel or CSV BOM. Fix missing MPNs, RefDes mismatches, and distributor SKUs in a live grid. Save a draft, request real distributor pricing, and carry the table forward into procurement-aware quantities without leaving the spreadsheet.
CSV · XLSX · XLS
Drop BOM or choose file
| MPN | RefDes | Qty | Supplier | Unit Price | Stock | Status | |
|---|---|---|---|---|---|---|---|
| 1 | STM32F405RGT6 | U1 | 1 | Mouser | $7.42 | 4,820 | ✓ priced |
| 2 | RC0603FR-0710KL | R1–R5 | 1 | — | — | — | Qty mismatch |
| 3 | 497-6063-1-ND | U7 | 1 | — | — | — | needs MPN |
| 4 | GRM155R71C104KA88D | C1, C2, C3 | 3 | DigiKey | $0.012 | 82,000 | ✓ priced |
| 5 | LM358DR | U3 | 1 | — | — | — | DNP — skipped |
Resolves "ST Micro" and "STM" to canonical names. Acquisitions surfaced, not silently folded.
Missing MPNs, RefDes count mismatch, DNP marker extraction, and distributor SKUs posing as MPNs.
Distributor pricing appended directly to your rows: supplier, unit price, stock, MOQ, lead time, and the quantity math you actually buy against.
A single row from a messy customer BOM — a missing MPN, a buried DNP marker, a distributor SKU pretending to be a manufacturer part, a RefDes range, a vendor-abbreviated manufacturer name. Nothing is silently rewritten.
No ML. No confidence scores. A correction either matches a rule or the row is flagged for your decision.
CSV and Excel BOMs. Column mappings are detected automatically. No template to fill out first.
Clear validation errors in real-time as you edit cells. RefDes ranges expand, DNP rows separate, distributor SKUs are flagged.
Click Fast Quote to fetch distributor pricing. Save a draft so your work is still there on reopen. Quote-only columns stay quiet until they have real data, then open up with supplier, lead time, and purchasing math.
The BOM grid does not stop at “what this design consumes.” Once a row is quotable, it can show what you will actually need to order, what that does to unit cost, and what cash leaves the account.
The table multiplies per-board quantity by total build quantity so engineering can see the true material demand for this run.
MOQ, standard pack quantity, and the stock you already have on hand all feed into the purchasing quantity — in a small detail panel, not hidden in a side system.
You can keep engineering cost and purchasing cost in the same view: Ext Price for consumed material, Buy Total for what purchasing has to pay today.
Supplier, currency, lead time, Ext Qty, Buy Qty, and Buy Total stay out of the way until a quote exists. Then they appear with real values, not placeholders.
You can override supplier, unit price, manufacturer, notes, quantity, and row currency directly in the table. The page behaves like a spreadsheet, not a wizard.
A row-level currency change converts priced rows. Display Currency is stricter: it only activates after a quote and only when every priced row can be converted cleanly.
Save a draft, reopen it later, and keep the table state that matters: quote values, hidden columns, quantity planning inputs, and the audit trail of what changed.
The drawer can separate what came from the file, what the normalization pass changed, and what you changed later — so review does not become archaeology.
Every pass applies a fixed BOM rule library. Some rules clean the row quietly; others raise a visible issue you can resolve in the grid. No ML, no guessing, no "confidence score".
Legacy names and abbreviations map to one canonical name. Crucial for reliable pricing across distributors.
Ranges are expanded and checked against the quantity column. Mismatches are flagged immediately.
Do-Not-Populate markers buried in descriptions are extracted so they don't corrupt quoting or inflate quantities.
Rows without a manufacturer part number can be cleaned, but they cannot be priced reliably until an MPN is supplied.
If a row has neither an MPN nor a usable description, the tool marks it as impossible to identify.
A BOM line needs a quantity greater than zero before it can be counted, checked against RefDes, or sent for pricing.
Expanded designators are counted and compared to the quantity column so placement counts do not drift.
The same placement designator cannot appear on two rows. Duplicates are surfaced before assembly data is trusted.
Resistors, capacitors, ICs, connectors, and other board-placed parts need a placement reference unless marked DNP.
Continuous material and sub-assembly rows should not carry PCB placement designators meant for board parts.
Piece-count parts need whole-number quantities; continuous rows need a positive quantity and a real unit such as meters or liters.
Common unit labels are canonicalized so `pcs`, `piece`, `ea`, and local units read consistently in the grid.
Prefixes are compared with category clues so resistor rows do not quietly carry capacitor or connector designators.
Package fields are checked against category and canonical part data, so SOT-23 on a capacitor row stands out.
When a matched part description disagrees with the user-provided row description, the row is flagged for review.
Obsolete, end-of-life, and not-recommended-for-new-design statuses are highlighted before the part reaches purchasing.
The same manufacturer part appearing on multiple lines is flagged as a consolidation candidate.
Acquired or rebranded manufacturer names are surfaced so sourcing and datasheet history do not disappear.
When headers are guessed from messy exports, the page asks you to verify that MPN, manufacturer, quantity, and RefDes landed correctly.
SKUs posing as MPNs are detected and flagged. A real MPN is needed for accurate cross-supplier pricing.
These are the static dictionaries behind the checks: aliases, RefDes prefixes, category signatures, DNP phrases, unit labels, lifecycle words, and spreadsheet header names.
TI, ST Micro, STM, NXP Semi, Freescale, Cypress, Maxim, Dialog, IR, AVX, and other common brand variants.
R, C, L, D, LED, U, Q, J, P, Y, X, FB, TP, F, S, SW, MOD, and MP category hints.
MPN and description patterns for resistors, capacitors, ICs, diodes, transistors, connectors, crystals, fuses, switches, and more.
DNP, DNI, DNF, DNL, Do Not Populate, Do Not Install, Do Not Fit, No Pop, remove, unmount, and related markers.
pcs, pc, each, ea, piece, pieces, шт, meter/metre, m, liter/litre, ml, set, kit, assembly, and local variants.
active, production, mature, stable, NRND, last-time-buy, EOL, discontinued, obsolete, and supplier status variants.
MPN, part number, P/N, manufacturer, qty, designator, description, footprint, package, unit price, currency, lead time, notes, and DNP columns.
Zero-width characters, dash variants, and accidental internal whitespace are normalized before rule checks run.
RefDes ranges expand predictable spans while pathological ranges stay safe and visible for review.
Fast Quote needs a real manufacturer part number and a nonzero quantity. DNP rows are skipped automatically. Partial success is fine — priced rows stay priced even if others fail.
| Field | Written back to your row |
|---|---|
| Supplier | Distributor name (Mouser, DigiKey, etc.) |
| Unit Price | Price at your quantity break |
| Currency | USD, EUR, GBP as returned |
| Stock | Available inventory at time of query |
| MOQ | Minimum order quantity |
| SPQ | Standard pack quantity |
| Price Tiers | Full break-price table |
| Lead Time | Weeks to ship from distributor |
| RoHS | Compliance status where available |
| Lifecycle | Active / NRND / EOL status |
| Distributor PN | Distributor's own part number |
| Manufacturer | Canonical manufacturer name |
Honest tool boundaries. If you need automatic part swapping, you want an engineering team, not an automated normalizer.
No account required to start cleaning. Saved drafts and Fast Quote are available once signed in.
Upload your BOM