Equipment list Excel template.
The project register of every tagged equipment item, one row per tag, with its service, capacity, design conditions, materials, vendor and datasheet reference.
- AEquipment Tag
- BTypePumpVesselExchangerColumnTankBlowerCompressorFilterReactorOther
- CService / Description
- DCapacity
- EDesign Pressure
- FDesign Temperature
- GMaterials
- HVendor
- IModel / Part No.
- JSerial No.
- KEmpty Weight
- LOperating Weight
- MDatasheet Ref
- NNotes
Frozen header, auto-filter on every column, 48 blank rows ready to fill. No macros.
Every column, defined.
14 columns, in the order the sheet carries them. Type is a dropdown; the rest stay free text, so house notation fits.
| Col | Column | What goes in it |
|---|---|---|
| A | Equipment Tag | Equipment identifier, P-101, V-201, E-301. |
| B | Type | Pump, Vessel, Exchanger, Column, Tank, Blower, Compressor |
| C | Service / Description | What the equipment does |
| D | Capacity | Rated capacity with units |
| E | Design Pressure | Design pressure with units |
| F | Design Temperature | Design temperature with units |
| G | Materials | Shell, tube, internals, gasket |
| H | Vendor | Equipment manufacturer |
| I | Model / Part No. | Vendor model number |
| J | Serial No. | Vendor serial number |
| K | Empty Weight | Empty weight with units |
| L | Operating Weight | Operating weight with units |
| M | Datasheet Ref | Per-equipment datasheet reference |
| N | Notes | Additional context |
What each equipment list column group is for
| Column group | What it carries | Who needs it |
|---|---|---|
| Identity | Equipment tag, description, type, and the P&ID it appears on. | Everyone. The tag is the join key into every other register. |
| Process duty | Capacity, design pressure and temperature, materials of construction. | Process and mechanical engineers sizing and specifying. |
| Mechanical | Driver type, power, speed, and the datasheet reference. | Rotating equipment and electrical, feeding the motor list and load schedule. |
| Commercial | Vendor, purchase order, delivery status. | Project controls and expediting. |
| Handover | Location, area classification, maintenance strategy. | Operations and the maintenance system. |
Where each line of the list comes from.
“An Equipment List Is Only as Useful as Its Source”, by our founder Muaawia Jannat, published in Data Center POST on October 14, 2026, sets out why each line of an equipment list should name the drawing it came from and say whether it has been verified, and what a drawing can and cannot establish before the equipment is installed.
Common questions
What is a master equipment list.
What columns are in this template.
Can the same template handle skid-mounted package equipment.
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.