Free Bill of Materials Template (Excel)
What's in the Bill of Materials template
The BOM sheet holds one row per part or assembly, up to 100, with level (Level 1/2/3), parent assembly, part/assembly name, category, quantity per assembly, and unit cost.
Extended cost calculates automatically as quantity times unit cost for every row, so a change to a single part's unit cost immediately shows its impact on that line.
The summary below the table rolls up total extended cost, then breaks it down two ways: by level (Level 1 top assembly cost vs. Level 2 and 3 components) and by category (raw material, component, subassembly).
Multi-level structure, with cost rolled up automatically
Many free BOM templates stop at a flat parts list with no automatic cost rollup - you'd have to total the cost columns yourself, and there's no built-in way to see cost by level or by category.
This template's Level column (1/2/3) and Parent assembly column let you structure a simple multi-level BOM - a top assembly, its subassemblies, and the raw parts inside those - while the summary's SUMIF-based rollups total cost by level and by category without you writing a single formula.
The keyword 'bill of materials template excel 2010' just reflects people searching for version compatibility - this file opens and calculates identically in Excel 2010 and every version since, and in Google Sheets.
Who this template is for
Product engineers, small manufacturers, and makers who need a simple multi-level parts list with cost rollups, without a full PLM or ERP bill-of-materials module.
It's a planning and costing tool - for procurement tracking with suppliers and order status, see our purchase order and vendor scorecard templates alongside this one.
How to use it
- List every part or assembly on the BOM sheet with level, parent assembly, category, quantity and unit cost.
- Extended cost calculates automatically for every row.
- Check the summary below the table for total cost, cost by level, and cost by category.
Download the free Free Bill of Materials Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
How many levels does this BOM support?
Three - Level 1 (the top assembly), Level 2 (subassemblies/components), and Level 3 (the raw parts and hardware inside those).
How is extended cost calculated?
Quantity per assembly multiplied by unit cost, for every row. The summary sums extended cost overall, by level, and by category.
Does this work in Excel 2010?
Yes. It uses only standard formulas (SUMIF, IF, IFERROR) supported since Excel 2010, and it also opens correctly in Google Sheets.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All formulas keep working.
How many parts can I list?
Up to 100 rows across all levels and categories combined.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.