Multi-BOM Consolidator & Where-Used Analyzer
Consolidate multiple Excel and CSV BOMs into a purchasing rollup. Set build quantities and trace each component across products, assemblies, and reference designators.
Consolidate your BOMs
Up to 4 MB across all files, 5,000 detail rows in total, and 64 nonempty columns per sheet.
Consolidate multiple BOMs in Excel for batch production
Enter the planned build quantity for each product. If 10 controllers each use 2 capacitors and 50 sensors each use 1, the purchasing rollup lists a demand of 70 capacitors. Open the per-product breakdown to see what contributed to the total.
Upload the consolidated purchasing list to the BOM Shortage Calculator with Build Qty set to 1 to compare those totals against warehouse stock.
See how established systems approach consolidated materials. Altium 365 BOM Portal · Cetec ERP consolidation
Cross-BOM component where-used lookup
When a supplier flags a component for end of life or reports a bad lot, look up its part number to see the products and assemblies that use it. Assembly paths, reference designators, and source rows let you trace the finding back to the original BOM.
See other approaches to lookup and spreadsheet consolidation. OpenBOM where-used guide · MrExcel workbook discussion
Multi-BOM consolidation FAQ
Can I combine separate BOM files and workbook sheets?
Upload 2–15 Excel or CSV files and select one BOM per file, or select 2–15 BOM sheets from one Excel workbook. Flat and indented BOMs can be used together. Enter a build quantity for each product.
What happens when a part has conflicting BOM data?
Unit mismatches, broken hierarchies, and active make-or-buy conflicts block export and show the source rows to fix. Manufacturer, description, and reference designator differences are marked for review, with the calculated quantities preserved.
What does one credit unlock?
You get the full Excel workbook with purchasing, where-used, and audit sheets, plus a CSV for either view. Recover the same export within 24 hours using the original inputs and account. Both five-row previews are free.
What happens to the uploaded BOM files?
The files are processed in memory and released after processing. Recovering an export requires the original files and settings.
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.