Pipe Spool Drawings to Bill of Material
Upload spool and isometric PDFs — scanned or CAD — and get every material line and a spool register in Excel. No parsing templates. The tables below are what Aginera actually read from two sample packages.
Aginera reads the bill of material printed on each pipe spool or isometric sheet — pipe, fittings, flanges, gaskets, bolt sets and valves with size, rating and material spec — and the sheet's own register fields (spool number, line, system, pipe class, coating, test pressure), then exports both to Excel. It works on scanned sheets, needs no per-customer template, and every line links back to the printed row it came from.
Sample 1 — a single spool isometric
A scanned sheet with a sectioned bill of material and a design-data block. Read with the OCR method in one pass.
Sample sheet 1 of 1. Title block, company names and drawing numbers removed. Download the sample PDF →
Pipe spool isometric — single sheet, scanned
One spool: 3" carbon-steel gas outlet with flanges, elbows, a reducer, a tee, thredolets, gaskets, bolt sets and a needle valve. Scanned sheet with a sectioned BILL OF MATERIAL box and a design-data block.
- Pages
- 1
- Read time
- ~20s
Bill of material as read by Aginera — 14 lines
Every line below was transcribed from the printed table on the sheet; nothing was typed in.
| Pos | Section | Description | Size / rating / material | Qty | Unit |
|---|---|---|---|---|---|
| Sheet 1Spool SAMPLE-ISO-001System CATEGORY NORMAL | |||||
| 1 | PIPE | PIPE SMLS | 3" STD. SA-106B S | 6 | ft |
| 2 | FLANGES | FLANGE RF WN | 2" 150# STD. SA-105N S | 1 | |
| 3 | FLANGES | FLANGE RF WN | 3" 150# STD. SA-105N S | 5 | |
| 4 | WELD FITTINGS | ELBOW 90 DEG LR BW | 3" STD. SA-234WPB S | 1 | |
| 5 | WELD FITTINGS | ELBOW 90 DEG LR BW | 3" STD. SA-234WPB S | 2 | |
| 6 | WELD FITTINGS | WELD CAP BW | 3" STD. SA-234WPB S | 1 | |
| 7 | WELD FITTINGS | CONC REDUCER BW | 3" X 2" STD. SA-234WPB S | 1 | |
| 8 | WELD FITTINGS | STRAIGHT TEE BW | 3" X 3" STD. SA-234WPB S | 1 | |
| 10 | SCREWED & SOCKET WELD FITTINGS | THREDOLET | 3/4" ON 3" 3000# SA-105N S | 4 | |
| 11 | GASKETS | GASKET RF 1/8" FLEXITALLIC | 2" 150# 304 SS F | 1 | |
| 12 | GASKETS | GASKET RF 1/8" FLEXITALLIC | 3" 150# 304 SS F | 3 | |
| 13 | BOLTS | BOLTS CW/2 NUTS-4/SET | 5/8"X3 1/2" A193 B7 /A194 2H F | 2 | sets |
| 14 | BOLTS | BOLTS CW/2 NUTS-4/SET | 5/8"X3 1/4" A193 B7 /A194 2H F | 1 | set |
| 15 | VALVES | NEEDLE VALVE MXF THD | 1/2" 6000# CS NE6002 F | 1 | |
Spool register — read from the same sheets
Title block, fabrication notes and design data, one row per spool sheet. Exported as a Spools tab in the Excel workbook.
| Sheet | Spool | System | Pipe class | Coating | Design code | Design / test pressure | NDE | BOM lines |
|---|---|---|---|---|---|---|---|---|
| 1 | SAMPLE-ISO-001 | CATEGORY NORMAL | B31.3 EDITION 2004 | 200 Psig @ 400°F · 450PSIG @ 70°F | SW - 5% MPI BW - 5% RT | 14 |
Sample 2 — a six-spool fabrication package
One spool per sheet, each with its own bill of material and a fabrication-notes box. The register below is what makes a package sortable by spool.
Sample sheet 1 of 6. Title block, company names and drawing numbers removed. Download the sample PDF →
Pipe spool package — 6 spool sheets, scanned
Six bilge-system spool assemblies (3" SCH 80), one per sheet, each with its own BILL OF MATERIAL and a fabrication-notes box naming the spool, system, pipe class and coating.
- Pages
- 6
- Read time
- ~35s
Bill of material as read by Aginera — 15 lines
Every line below was transcribed from the printed table on the sheet; nothing was typed in.
| Pos | Description | Size / rating / material | Qty | Unit |
|---|---|---|---|---|
| Sheet 1Spool B-01System BILGEClass 2Coating BLAST AND PAINT | ||||
| 01 | PIPE, 3" SCH 80B-01-01 | 1 | ||
| 02 | ELBOW, 90° RAD, 3" SCH 80, BW | 1 | ||
| 03 | FLANGE, RFSO, 3" 150# | 1 | ||
| 04 | 6" LG NIPPLE, SCH 80, BW | 1 | ||
| Sheet 2Spool B-02System BILGEClass 2Coating BLAST AND PAINT | ||||
| 01 | PIPE, 3" SCH 80B-02-01 | 1 | ||
| 02 | FLANGE, RFSO, 3" 150# | 1 | ||
| Sheet 3Spool B-03System BILGEClass 2Coating BLAST AND PAINT | ||||
| 01 | ELBOW, 90° RAD, 3" SCH 80, BW | 1 | ||
| 02 | FLANGE, RFSO, 3" 150# | 1 | ||
| 03 | 7 1/2" LG NIPPLE, SCH 80, BW | 1 | ||
| Sheet 4Spool B-04System BILGEClass 2Coating BLAST AND PAINT | ||||
| 01 | PIPE, 3" SCH 80B-04-01 | 1 | ||
| 02 | FLANGE, RFSO, 3" 150# | 1 | ||
| Sheet 5Spool B-05System BILGEClass 2Coating BLAST AND PAINT | ||||
| 01 | PIPE, 3" SCH 80B-05-01 | 1 | ||
| 02 | ELBOW, 90° RAD, 3" SCH 80, BW | 2 | ||
| Sheet 6Spool B-06System BILGEClass 2Coating BLAST AND PAINT | ||||
| 01 | PIPE, 3" SCH 80B-06-01 | 1 | ||
| 02 | ELBOW, 90° RAD, 3" SCH 80, BW | 2 | ||
Spool register — read from the same sheets
Title block, fabrication notes and design data, one row per spool sheet. Exported as a Spools tab in the Excel workbook.
| Sheet | Spool | System | Pipe class | Coating | Design code | Design / test pressure | NDE | BOM lines |
|---|---|---|---|---|---|---|---|---|
| 1 | B-01 | BILGE | 2 | BLAST AND PAINT | 4 | |||
| 2 | B-02 | BILGE | 2 | BLAST AND PAINT | 2 | |||
| 3 | B-03 | BILGE | 2 | BLAST AND PAINT | 3 | |||
| 4 | B-04 | BILGE | 2 | BLAST AND PAINT | 2 | |||
| 5 | B-05 | BILGE | 2 | BLAST AND PAINT | 2 | |||
| 6 | B-06 | BILGE | 2 | BLAST AND PAINT | 2 |
How it works
Four steps from a spool package to a spreadsheet. No extraction run is needed for the material tables — this is a lighter pass than a full takeoff.
Upload the package
One multi-sheet PDF per spool package, or separate files. Scanned or CAD-exported — both read.
Read BOM tables
Open the sheet, click BOM, pick the pages, choose OCR for scans or Table for text PDFs, and read. About 20 seconds a sheet.
Check on the sheet
Every line knows where it came from: click it and the viewer jumps to that spool and highlights the printed row.
Export
Excel with a BOM tables sheet and a Spools register sheet, or CSV — ready for procurement, planning or your ERP.
Step-by-step with screenshots: PDF to bill of materials — documentation
What comes off the sheet — and what does not
From the title block, fabrication notes and design-data box Aginera captures the spool number, line number, system or service, pipe class, coating or surface treatment, drawing number, revision, sheet, design code, design and test pressure, NDE requirement, and the job or work-package number — only when it is printed. Nothing is guessed: a field the sheet does not carry stays blank.
Work package and price class are planner decisions rather than drawing content, so they are exported as empty columns on the Spools sheet for you to fill.
The reader needs a printed material list. An isometric with no bill of material is not yet a BOM source: Aginera's takeoff will read its instruments, valves and pipe runs, but it does not derive fittings, gaskets and bolt sets from the geometry. We say so on the documentation page as well.
Frequently Asked Questions
Do I need to set up a parsing template for each customer's drawing format?
No. Aginera finds the bill of material box and the title block on each sheet by reading the sheet itself, so a package from a new client reads the same way as one you have seen before. There is nothing to drag, map or save per customer.
Does it work on scanned spool drawings?
Yes. Both samples on this page are scanned (image-only) PDFs read with the OCR method — one vision read per sheet, about 20 seconds a page. CAD-exported PDFs with a text layer are read directly from the text, which is exact and free.
What comes out for each spool?
The bill of material lines exactly as printed — position, description, size, schedule or rating, material spec, quantity and unit, with piece marks where the sheet has them — grouped by sheet. Alongside it, a spool register: spool number, line number, system, pipe class, coating, drawing number, revision, design code, design and test pressure and NDE requirement, one row per spool sheet.
How do I get it into my planning or ERP system?
Export to Excel or CSV from the BOM dialog. The workbook has a BOM tables sheet (every line, with its spool, line number, class and coating as columns) and a Spools sheet (the register, with blank Work package and Price class columns for your planner). Every row also links back to its line on the drawing inside Aginera.
Can it build a BOM for an isometric that has no material list?
Not yet. The reader needs a printed bill of material or shop/field materials table on the sheet. On an isometric without one, Aginera's takeoff reads instruments, valves and pipe runs but does not derive elbows, tees, reducers, gaskets and bolt sets from the drawing geometry — so it is not a substitute for the material list.
How accurate is it?
On the two samples on this page every printed line was read: 14 of 14 on the single isometric and 15 of 15 across the six-spool package (checked against the sheets by hand). Pipe quantities come through as printed, so a 6' pipe line reads as 6 with the unit ft. Treat the output as a transcription to review, not as a redesign of the drawing.
Upload your drawing → get takeoff + BOM in minutes
Free 7-day trial. No credit card required.