Export a fully costed BoM structure to Excel, one click
Hierarchical, flattened, or level-1 XLSX exports with material, labour and subcontracting cost unified on every line — no wizard required, no module stacking, no post-export cleanup in Excel.
The problem
Odoo has no native way to export a full multi-level Bill of Materials to Excel. Cost engineers, procurement staff, and sales teams end up re-keying BoM data by hand so they can filter it, compare it against supplier quotes, or share it with people who have no Odoo login — slow, error-prone, and impossible to audit.
The solution
One app exports the complete BoM tree to XLSX in hierarchical, flattened, or level-1 mode, with material, labour and subcontracting cost placed on the same line — a single click from the BoM form, or in batch from the list, with an optional options wizard when you want column and depth control.
Everything a costed BoM export needs
Every capability below is implemented in the module.
Full hierarchical export
Preserve the complete BoM tree — components, sub-assemblies, operations and by-products — exactly as engineering and manufacturing planning need to see it.
Flattened roll-up mode
Collapse every level into a single component list, with identical materials aggregated into one row and total quantity — ready for procurement and total-material costing.
Selectable depth & level-1 mode
Cap the export at direct components only, or set a maximum depth, so sales and procurement get a top-level summary without deleting rows afterwards.
Material, labour & subcontracting on one line
All three cost dimensions sit on the same component or operation row instead of separate tabs you have to reconcile by hand.
Product Cost vs BoM Cost, clearly labelled
The stored unit Product Cost and the computed total BoM Cost are shown side by side with a variance column, ending the confusion between the two.
User-selectable columns
Toggle unit cost, material, labour, subcontracting, BoM cost, variance, supplier and lead-time columns before export, so the file is ready to send without spreadsheet cleanup.
Supplier & lead-time columns
Each component row can carry its preferred supplier, supplier part number and lead time, so the export doubles as a sourcing sheet.
One-click Quick Export, no forced wizard
A single Quick Export button on the BoM form generates the file immediately with sensible defaults; the options wizard is there only when you want to customise mode, depth or columns.
Batch export from the list view
Select several BoMs in the list and export them all in a single action, each one landing on its own worksheet in the same workbook.
How it works
Open or select BoMs
Open a single BoM form, or select several BoMs in the list for a batch export.
Quick Export or open options
Click Quick Export for an instant file with defaults, or Export to Excel to open the options wizard.
Choose mode, depth & columns
Pick full hierarchy, flattened, or level-1, set a maximum depth, and toggle the cost and supplier columns you need.
Download the XLSX
The generated workbook is ready to click and download, with each BoM on its own worksheet.
Frequently asked
No sales fog. If your question isn't here, email us and we'll answer it the same way.
Product Cost is the item's own stored standard cost per unit. BoM Cost is the computed cost of manufacturing it from its Bill of Materials — materials, labour and subcontracting rolled up. The export shows both side by side with a variance column, so the two are never confused.
Buy it on the Odoo App Store
Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.
Export BoM Structure to Excel
One-click XLSX export of a multi-level Bill of Materials — hierarchical, flattened or level-1 — with material, labour and subcontracting cost unified on every line and supplier and lead-time columns you choose.
Buy on Odoo App Store