Line list Excel template.
The project register of every numbered line on the P&IDs, one row per line, with its size, pipe class, service, design conditions and the equipment at each end.
- ALine Number
- BNominal Size
- CSchedule
- DPipe Spec
- EMaterial
- FService
- GDesign Pressure
- HDesign Temperature
- IInsulation
- JTracing
- KFrom Equipment
- LTo Equipment
- MNotes
Frozen header, auto-filter on every column, 48 blank rows ready to fill. No macros.
Every column, defined.
13 columns, in the order the sheet carries them.
| Col | Column | What goes in it |
|---|---|---|
| A | Line Number | Pipe spec line number, 4"-CS-101-A1A. |
| B | Nominal Size | Nominal pipe size with units |
| C | Schedule | Pipe schedule, Sch 40, Sch 80, XS. |
| D | Pipe Spec | Pipe class designation, A1A, B2C. |
| E | Material | Pipe material, CS, 316SS, Hastelloy C, etc. |
| F | Service | Process service |
| G | Design Pressure | Design pressure with units |
| H | Design Temperature | Design temperature with units |
| I | Insulation | Insulation type and thickness |
| J | Tracing | Steam and electric tracing notation |
| K | From Equipment | Origin equipment tag |
| L | To Equipment | Destination equipment tag |
| M | Notes | Additional context, pipe-class breaks |
Reading a line number.
Most of a line list is already printed on the P&ID, folded into the line number. The list unfolds it into columns that sort, filter and join.
8"Nominal sizeInches or DN, as the project writes it.CSService or material codeWhat the legend says the code means.301Sequence numberUnique within the unit or area.A1APipe classThe specification the line is built to.HSuffixInsulation or tracing, where the project uses one.
What the line list adds over the P&ID
| Field | On the P&ID | In the line list |
|---|---|---|
| Line number | Printed alongside the line, often broken across the sheet | One complete row, sortable |
| Service | Implied by a segment of the line number, or by the legend | An explicit column |
| Pipe spec | Encoded inside the line number | Resolved to a column the pipe class library can be joined against |
| Size | Printed at the line | A numeric column that filters and sums |
| From, to | Drawn as a connection | Resolved to equipment and line tag columns |
| Design conditions | In the notes or the spec break table | Per-line columns |
| Insulation, tracing | A symbol on the line | Explicit columns for the material takeoff |
Common questions
What is a pipe line list.
The pipe line list is the project register of every named pipe spec on the P&ID. One row per line number with size, schedule, pipe spec, material, service, design conditions, insulation, tracing, and the connected-equipment references at each end. It is the document handed to the piping detailer, the stress engineer, and the field-fabrication contractor.
What columns are in this template.
Thirteen columns. Line Number, Nominal Size, Schedule, Pipe Spec, Material, Service, Design Pressure, Design Temperature, Insulation, Tracing, From Equipment, To Equipment, Notes. All columns stay free text so house pipe-class notation, A1A, B2C, D3E in the worked example preserves as drawn.
How are pipe-class breaks handled.
Each line carries one pipe spec. Pipe-class breaks, a service change from carbon steel to stainless across an isolation valve, for example are typically recorded as two adjacent line numbers with a note on the break location. The Notes column carries the break reference and the pipe-class transition documentation.
Run it on your drawings.
The template is a manual starting point you fill yourself. Upload the source document instead and review the register Tagsight reads from it.