Export Excel Bill of Materials
Download a fabrication-ready Excel (.xlsx) or CSV bill of materials — mark list, section weights, surface areas, paint volumes, and connection schedule in one click.
Export Excel Bill of Materials
Steel fabricators procure and cost in Excel. The FrameAI BOM export converts your structural model directly into a procurement-ready spreadsheet — no copy-paste from PDFs, no manual weight lookups.
Available to **Pro and Studio** subscribers. Free-tier users see a paywall preview.
What's in the export
The .xlsx file has four sheets:
| Sheet | Contents |
|---|---|
| **Member BOM** | One row per member mark: section, grade, length, qty, unit weight, total weight, surface area, paint volume @ 80 μm DFT, connection type at each end |
| **Profile Summary** | Subtotals per section profile — total qty, total length, total weight in kg and tonnes |
| **Grade Summary** | Tonnage breakdown per steel grade (S235/S275/S355) — matches the shop-drawing cover sheet tonnage |
| **Connection Schedule** | Bolt counts per grade (8.8 / 10.9) and weld lengths per throat size |
.csv variant contains the Member BOM sheet only — for direct import into ERP or procurement systems (SAP MM, Procore, etc.).
Step 1. Upload your PDF drawing
/intake and upload a structural steel PDF. FrameAI will:
1. Extract the member schedule via GPT-4o vision
2. Run EN 1993-1-1 and EN 1993-1-8 checks
3. Auto-design bolted connections (eaves moment, apex, base plates)
4. Mark the revision as **done**
Step 2. Open the Project page
/projects and open the project. You'll see the revision table and, once at least one revision is **done**, a **Fabrication Package Available** banner.
Step 3. Download the BOM
In the banner, click:
- **📊 Excel BOM** → downloads
frameai--bom.xlsx - **CSV for ERP** → downloads
frameai--bom.csv
Column reference (Member BOM sheet)
| Column | Unit | Source |
|---|---|---|
| Mark | — | Extracted from drawing (e.g. C1, R3, B12) |
| Section | — | European hot-rolled designation (HEB 300, IPE 450, L80×80×8) |
| Steel Grade | — | S235 / S275 / S355 (extracted or defaulted S355) |
| Length | mm | Extracted from drawing |
| Quantity | no. | Extracted; defaults to 1 |
| Unit Weight | kg/m | EN 10365 nominal weight |
| Total Weight | kg | Unit weight × length × qty |
| Surface Area | m² | Perimeter approximation for paint/galvanising take-off |
| Paint Volume | L | Surface area × 80 μm DFT (0.08 L/m²) |
| Conn. Start | — | EN 1993-1-8 connection type at member start (base plate, endplate, etc.) |
| Conn. End | — | EN 1993-1-8 connection type at member end |
Tonnage cross-check
The
**Grade Summary** sheet total matches the tonnage shown on the shop-drawing cover sheet to the kg. If they differ by more than 0.1%, raise a support ticket — the extracted member data may contain an anomaly.ERP import tips
For
**SAP MM**: import the CSV using transaction code MM01 (material master) or ME21N (purchase order). Map:- Section → Material description
- Steel Grade → Material group
- Total Weight (kg) → Order quantity
For **Procore** and similar: the CSV imports natively via the Budget or RFI tools with a column-mapping step.
Limitations
- Section unit weights use EN 10365 nominal values. Actual mill weights may differ by ±2%.
- Angles (L-sections), channels (UPE/UPN), and T-sections are not yet in the unit-weight table — those rows show a blank unit weight.
- The connection schedule requires that the job ran EN 1993-1-8 connection design. If connections were skipped (e.g. unsupported frame type), the sheet shows "No connection data available".