Free BOM Template (Excel & CSV)
List the components and quantities in a finished product — download and fill in for your own recipes or assemblies.
Download Free BOM TemplateCSV format — opens directly in Excel, Google Sheets, or Numbers. No signup.
What's in the template
- finished_product_sku
- SKU of the finished product
- finished_product_name
- Human-readable product name
- component_sku
- SKU of the raw material/component
- component_name
- Human-readable component name
- quantity_per_unit
- Amount used per finished unit
- unit
- Unit of measure (kg, g, L, each)
How to use it
- Download the template and open it in Excel or Google Sheets.
- The file ships with three example rows (gummy candy and bakery recipes) — delete them once you understand the format, or keep them as a reference.
- For each finished product, add one row per component — reuse the same finished_product_sku on every row that belongs to it.
- Fill in quantity_per_unit using a consistent unit of measure per component (don't mix kg and g for the same item across rows).
- Save the file and keep it as your source of truth, or import it into inventory software once you're tracking costs at scale.
The limits of a spreadsheet BOM
A flat spreadsheet works well for simple, single-level products. It runs into trouble once you have secondary or intermediate products — a sub-assembly or semi-finished good that's itself built from other components, with its own cost that needs to roll up into whatever uses it. Tracking that by hand means updating multiple sheets any time a raw material price changes, and it's easy for the numbers to drift out of sync. See multi-level BOM costing for secondary products for how that rollup should work, and bill of materials explained for the fundamentals.
When you outgrow this template
The column shape of this template — SKU, component, quantity, unit — is deliberately import-friendly: it maps cleanly onto the kind of data BOM management software expects, so the switch from spreadsheet to system isn't a rebuild from scratch. In fact, Nstock can import this exact CSV directly to seed your BOMs. See multi-level BOM management for what changes once cost rollup, versioning, and production runs are handled automatically, or check the COGM calculator to see how component costs roll up into a finished-goods cost by hand first.
Frequently asked questions
How do I use this BOM template in Excel or Google Sheets?
Download the CSV file, then open it directly in Excel or Google Sheets (File > Open, or drag the file into Sheets) — CSV opens natively in both, no conversion needed. Each row is one component of one finished product, so a product with five ingredients gets five rows, all sharing the same finished_product_sku. Add rows as needed and save as CSV or as a native .xlsx/.gsheet file.
Can this template handle multi-level BOMs?
Not on its own. This template is one level per row: a finished product and its direct components. If a component is itself an assembly with its own sub-components (a multi-level or nested BOM), you need a second sheet for that intermediate product, and you have to manually track how cost rolls up between levels. Real multi-level BOM costing — where an intermediate product's cost automatically flows into the finished goods that use it — needs dedicated software.
Is this BOM template really free?
Yes. The template is free to download and use with no signup, account, or watermark. Nstock offers it as a starting point for manufacturers who aren't ready for full BOM management software yet.
Ready for BOM costing that updates itself?
Nstock imports this CSV directly and rolls up component and secondary-product costs into finished goods automatically, so your BOM cost is always current instead of a manual recalculation.