Free public tool
Check your BOM before it breaks the handoff.
Upload one BOM, material list, schedule, or takeoff export. BOM Health Check flags duplicate parts, missing quantities, bad rows, unit conflicts, and other issues before your team compares, quotes, orders, or fabricates.
No credit card. Browser-based. Files stay in your browser.
Upload one export
Check one BOM, material list, schedule, or takeoff export.
Start with the sample or upload a CSV, XLSX, or text-based PDF. Processing happens in this browser session; raw files are not stored by default.
Health score
High risk
2 critical issue signals that this export needs cleanup before ordering, comparison, or cost impact.
Rows read
5
Material rows
5
Issues found
5
Rows needing review
3
Issues to review
Examples use source-row references only. Raw rows are kept local to this browser session.
| Severity | Issue | Count | Example row | Recommended action |
|---|---|---|---|---|
| critical | Quantity could not be parsed. Invalid quantities are excluded from trusted totals. | 1 | 5 | Correct the quantity format before using the export. |
| critical | Row is missing quantity. Missing quantities cannot be trusted for ordering, comparison, or cost impact. | 1 | 4 | Fill in the quantity or mark the row for review. |
| warning | Subtotal or total row detected. Summary rows can double-count material if treated as line items. | 1 | 6 | Remove subtotal rows or confirm they are excluded. |
| info | Duplicate part number found: PX000003. Repeated parts may be valid detail rows, but they should be consolidated or reviewed before handoff. | 1 | 1 | Confirm whether duplicates are detail rows or accidental duplicates. |
| info | Part PX000003 appears across multiple breakdowns. This can be valid when breakdown detail matters, but it affects total vs breakdown views. | 1 | 1 | Choose total view or breakdown view intentionally. |
Next step
Do not use this export for ordering or cost impact until critical issues are resolved.
Compare this against a revised exportWhat the health check looks for
Check one BOM, material list, or takeoff export for duplicate parts, missing quantities, bad rows, unit conflicts, and other issues before comparison or handoff.