SpecRivet
BOM checkerBOM shortage calculatorBOM diff checkerMulti-level BOM flattenerMulti-BOM consolidatorBOM AVL checkerPricing
Sign inSign up

Multi-Level & Indented BOM Flattener

Convert Indented BOM to Flat List & Parent-Child CSV. Roll up purchase quantities, check repeated subassemblies, and export one Excel workbook for both views.

Convert your BOM

BOM workbook or CSV
No file selected

Files are processed in memory. Up to 4 MB, 5,000 detail rows, and 64 columns with data.

Choose the output for your next step

Flattened Rollup
A BOM Explosion multiplies quantities through the assembly tree. The flat list combines the total demand for each part number across every use. Add intermediate subassemblies when your planning team also needs their quantities.
ERP Parent–Child Links
The relationship table records the quantity of each component per direct parent. A repeated subassembly keeps each placement and contributes its matching component recipe once.

Need unit costs and extended totals? Open BOM Checker & Cost Rollup.

Prepare a BOM for import

  • Use the rollup to verify totals across assembly levels. OpenBOM’s guide to flattened BOMs
  • Create items before import. Map the ERP CSV’s parent, component, and per-parent quantity to Product number, Part No., and Quantity. MRPeasy CSV import guide
  • Match finished-product and component SKUs in the Excel recipe template. Katana MRP recipe template
  • Map the workbook columns to your item properties and review the structure preview. Siemens Teamcenter structure import guide

BOM flattener FAQ

Which BOM files can I flatten?

Upload an XLSX, XLS, or UTF-8 CSV file. Map the hierarchy level, part number, and quantity per parent. The selected worksheet supports up to 5,000 detail rows and 64 columns with data.

How does the BOM flattener handle top-level rows?

If a single top-level assembly has child parts, its own row stays out of the purchase list. If the worksheet starts with multiple top-level items, all of them are counted and the ERP table groups them under a virtual parent. Enter your own top assembly part number or use the name derived from the file.

What happens to DNP rows and conflicting assemblies?

DNP rows and their descendants are excluded by default. Keep them for audit to see zero purchase demand and DNP - HOLD status. Broken hierarchies and conflicting recipes block export, with source rows shown in the diagnostics.

What does one credit unlock?

One credit unlocks the Excel workbook with both views and CSV download for the current view. The same account can recover the export with the original file and settings within 24 hours. Preview is free and eligible small files qualify for the first-account trial.

Next Step in Workflow

Multi-Level BOM Checker & Cost RollupAudit a BOM and roll up purchase quantities and costs.BOM Diff CheckerCompare two revisions and calculate net purchasing changes.Multi-BOM & Where-Used ConsolidatorCombine purchasing demand and trace parts across products.BOM Shortage CalculatorCheck stock and kit readiness for a planned build.BOM AVL CheckerCheck the contract manufacturer’s quote against approved parts and channels.

Review flagged rows before placing an order or importing your file. 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.

PrivacyTermsRefunds