Header row
Formatted, frozen, with set column widths so the sheet scrolls cleanly on long registers.
Equipment list Excel template.
A master equipment list is the project register of every tagged equipment item on a process facility. Pumps, vessels, exchangers, columns, tanks, blowers, compressors, filters, and reactors. One row per tag carries equipment type, service description, rated capacity, design pressure and temperature, materials of construction, vendor and model number, weights, dimensions, and a reference to the per-equipment datasheet. The master equipment list is the handover document for procurement, commissioning, and the CMMS asset register.
What the template carries.
Master equipment list template with 14 columns covering tag, type, service, capacity, design pressure, design temperature, materials, vendor, model, weight, dimensions, and datasheet reference. Pre-formatted with frozen header, auto-filter, signal-class dropdown where applicable, and 48 blank rows.
By Tagsight Team·Published Jan 26, 2026·Reviewed Jun 4, 2026
- Format.xlsx
- Columns14
- Rows48 blank
- Opens inExcel · Sheets · LibreOffice
Every column, defined.
14 columns mapped to how a master equipment list is issued on a real project. Dropdown columns enforce values; free-text columns let house notation preserve as drawn.
| # | Column | Type | Description |
|---|---|---|---|
| 01 | Equipment Tag | Text | Equipment identifier, P-101, V-201, E-301. |
| 02 | Type | List | Pump, Vessel, Exchanger, Column, Tank, Blower, Compressor |
| 03 | Service, Description | Text | What the equipment does |
| 04 | Capacity | Text | Rated capacity with units |
| 05 | Design Pressure | Text | Design pressure with units |
| 06 | Design Temperature | Text | Design temperature with units |
| 07 | Materials | Text | Shell, tube, internals, gasket |
| 08 | Vendor | Text | Equipment manufacturer |
| 09 | Model, Part No. | Text | Vendor model number |
| 10 | Serial No. | Text | Vendor serial number |
| 11 | Empty Weight | Text | Empty weight with units |
| 12 | Operating Weight | Text | Operating weight with units |
| 13 | Datasheet Ref | Text | Per-equipment datasheet reference |
| 14 | Notes | Text | Additional context |
What ships in the file.
Worked example
One filled row shows the format for every column so the schema is clear before the engineer starts typing.
Auto-filter
Enabled on every column. Pivot by any field without a single formula.
48 blank rows
Pre-formatted and ready to paste into. Extends without breaking the dropdown or filter range.
Enforced dropdowns
Categorical columns (priority, signal class, status, type) enforce values so the register stays clean.
Cross-tool
Plain .xlsx. Opens cleanly in Excel, Google Sheets, and LibreOffice. No macros, no add-ins.
No tracking
No macros, no add-ins, no telemetry inside the file. Edit and ship.
Quiet signoff
A single mint-italic line at the bottom: Drag a source document at tagsight.io to fill this automatically. Easy to delete.
Extract from a source document instead.
Upload the source document instead and the same 14-column schema this template defines comes back populated. Type, tag, vendor, model, and per-row metadata come from the document itself.
Scanned binders, CAD-exported PDFs, and image scans all work. House conventions, vendor-specific forms, and dialect-specific tag schemes read as drawn.
Common questions
What is a master equipment list.
The master equipment list is the project register of every tagged equipment item, pumps, vessels, exchangers, columns, tanks, blowers, compressors. One row per tag with type, service, capacity, design conditions, materials, vendor, model, weight, and datasheet reference. It is the document handed to procurement, commissioning, and the operations CMMS at end of job.
What columns are in this template.
Fourteen columns. Equipment Tag, Type, Service, Description, Capacity, Design Pressure, Design Temperature, Materials, Vendor, Model, Part No. Serial No. Empty Weight, Operating Weight, Datasheet Ref, Notes. The Type column is a dropdown with the seven canonical types. Everything else stays free text so vendor-specific notation preserves as the datasheet wrote it.
Can the same template handle skid-mounted package equipment.
Yes. Add a Parent Skid column, the template's Notes column commonly carries this and the sub-equipment rows roll up to the package skid.
Related.
Run it on your drawings.
The template is a manual starting point you fill yourself. Upload the source document instead and the same schema comes back populated.