---
title: Export Excel Bill of Materials
description: 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.
category: Fabrication
---

# 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 |

The `.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

Go to [/intake](/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

Navigate to [/projects](/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-<project>-bom.xlsx`
- **CSV for ERP** → downloads `frameai-<project>-bom.csv`

Both files reflect the **latest completed revision**.

---

## 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".