Multi-Level BOM Diff Checker & Revision Compare
Compare two Excel or CSV BOM revisions (Rev A vs Rev B) in seconds. Audit multi-level hierarchy changes, RefDes swaps, and net purchase quantity deltas.
Files processed in memory & auto-deleted immediately · Zero data retention · Never used for AI training
Upload a Rev A file and a Rev B file.
Map your Rev A and Rev B columns
Upload two complete revisions of one finished product. Choose the same part-number role on both sides.
| Rev A heading | Rev B heading | Example value |
|---|---|---|
| Part Number | MPN | 00047 |
| Qty | Quantity per Parent | 2 |
| Outline | Level | 1.2.1 |
| RefDes | Designator | R1-R4 |
Compare BOM revision workflows
| Workflow | SpecRivet | Free Flat CSV Diff Tools | Manual Excel / Macro Add-ins | Enterprise PLM / MRP Suites |
|---|---|---|---|---|
| Input and setup | Upload two Excel or CSV revisions. | Convert each revision to a flat list. | Set up lookup formulas, macros, or an add-in. | Configure the system and import item master data and BOMs. |
| Hierarchy and reordering | Align by part number and assembly position, with RefDes and engineering-line evidence. | Compare flat rows without parent assembly context. | Keep composite keys and formulas aligned when rows reorder or part numbers repeat. | Compare revisions against managed item masters and product structures. |
| Net purchasing impact | Multiply leaf quantities through the hierarchy and compare per unit and per order. | Compare listed quantities without parent multipliers. | Build and maintain parent multipliers and rollup formulas. | Run the configured revision and planning reports after importing the BOM. |
| Cost and deployment | Free preview; one credit for the full Excel report. | Typically free for flat comparisons. | Requires Excel and setup time; some workflows need a paid add-in. | Higher-cost recurring licenses and item master onboarding are typical. |
BOM comparison FAQ
Which files can I compare?
Upload two complete BOM revisions in Excel or CSV, or choose two worksheets in one Excel workbook. The files can total up to 4 MB and 5,000 detail rows.
Can I compare a multi-level BOM after sorting it?
Dotted outline paths let the checker reconstruct parent positions after sorting. With integer levels, keep each set of child rows under its parent. Store dotted paths and part numbers with leading zeros as text in Excel.
How does the checker identify a part swap?
It links an old and new part when a unique reference designator or engineering line points to the same assembly position in both revisions. Ambiguous matches need review.
How is net purchase quantity calculated?
The checker multiplies each leaf quantity by its parent quantities, then subtracts Rev A from Rev B. Set the order quantity to see the batch difference. Unsafe quantities remain blank.
How much does it cost and what happens to my files?
Preview up to five changes per list for free. The full report and Excel export use one credit, with a first-account trial for eligible small files. Uploaded files are processed in memory and released after processing.
Review flagged quantities and source rows before issuing purchase orders. To the extent permitted by applicable law, SpecRivet’s total liability for a claim is limited to the amount you actually paid for the credit pack associated with that claim. Mandatory rights and liabilities that cannot lawfully be limited still apply.