Excel BOM & Cost Engine

Turn raw BOM exports into costed, revision-aware workbooks.

4.6 (213 reviews)40,310 downloadsv2.6.0
Excel 2016 → Microsoft 365 Windows / macOS (VBA)
Excel BOM & Cost Engine main interface

Overview

A free VBA workbook that ingests CAD BOM exports, normalises part numbers, applies cost rules per material and process, and produces a clean rollup with revision comparison. Built for manufacturing engineers who live in Excel and need a repeatable costing method.

Key features

  • CSV / XLSX BOM import with column mapping
  • Material and process cost rule tables
  • Revision-to-revision delta report
  • Multi-level BOM rollup with make/buy split
  • Unlocked, commented VBA source

Screenshots

Excel BOM & Cost Engine screenshot 1

Video tutorial

Reviews & ratings

4.5

213 ratings

Sofia Marchetti

Manufacturing Engineer

2026-06-28

Free and better than the internal tool we maintained for years. The delta report is the killer feature.

Kevin Wu

Cost Estimator

2026-05-14

Fast on 10k-line BOMs. Would like native Google Sheets support one day.

Write a review

Reviews will open once the catalogue is synced to the database.

Frequently asked questions

Version history

  1. v2.6.02026-07-28

    Faster rollup engine, new make/buy split.

  2. v2.5.02026-02-12

    Revision delta report added.

  3. v2.0.02025-08-30

    Rewritten import mapper.

Related tools