Equipment list to Excel.
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 the equipment type, service description, rated capacity, design pressure and temperature, materials of construction (shell, tube, internals, gasket), vendor and model number, weights (empty and operating), dimensions, and a reference to the per-equipment datasheet. The master equipment list is the handover document for procurement, commissioning, and the operations asset register; it is also the source the maintenance system (CMMS / EAM) imports into the asset hierarchy.
Upload a vendor datasheet binder, an equipment list PDF, or a scanned register and extract every equipment tag into the master register. Type, service, capacity, design conditions, materials, vendor, model, and datasheet reference all read into the columns the project asset register expects.
| Aspect | Vendor binder | Master register |
|---|---|---|
| Format | Per-vendor datasheet form | Canonical 14-column schema |
| Tag uniqueness | Vendor-internal numbering | Project tag enforced |
| Vendor-specific notation | Form-dependent labels | Mapped + source label preserved |
| Multi-vendor comparison | Manual cross-reference | Side-by-side workbook on duty fields |
| Datasheet linkage | PDF binder lookup | Per-row datasheet reference |
| CMMS / asset register handoff | Manual re-keying | Direct import in canonical shape |
Fields extracted.
Every column the master equipment list typically carries is read and shaped into a structured row. Missing fields stay blank, never invented.
- Equipment tag
- Typepump / vessel / exchanger / column / tank / blower
- Service / Description
- Capacitywith units as drawn
- Design pressure
- Design temperature
- Materialsshell, tube, internals, gasket
- Vendor
- Model / Part No.
- Serial No.
- Weightempty / operating / hydrotest
- Dimensions
- Datasheet Ref
- Notes
Export targets.
The extracted data ships in the format your team picks up and uses directly.
- .xlsxExcel workbook (master equipment list)
- .csvCSV
- .xlsxPer-vendor comparison workbook
From legacy file to clean register.
Common questions.
Does this work on a 240-page vendor datasheet binder?
Yes. Binders process as a single workspace; per-equipment datasheets extract into individual rows. Vendor-specific datasheet form layouts (Flowserve, Sulzer, John Crane, Aerzen) read as drawn into the canonical equipment-list column schema.
What if two vendors use different field names for the same property?
Vendor-specific notation is preserved in a source-form column; the canonical column shape maps both vendors' fields into the same master register column. Disagreements between the two vendor mappings surface in the comparison workbook for review.
Can the master register feed a CMMS or asset register (Maximo, SAP PM, Infor EAM)?
The Excel export carries the canonical column shape these systems import. Tag, type, vendor, model, and per-equipment metadata land in the right CMMS field on import; the asset-hierarchy parent (parent skid, parent unit) carries through as the asset-tree relation.
Does this handle skid-mounted package equipment?
Yes. Package skid drawings extract every sub-component with parent-skid attribution. The equipment list carries the skid as the parent so the receiving inspection can group sub-components under the package they belong to.
What about handwritten or scanned legacy registers?
Scanned and photographed registers process the same way as CAD exports. OCR confidence per row drives a review queue; rows below the auto-accept threshold flag for human verification before they reach the master register.
Convert your file.
Upload a master equipment list in any format, get every row read, every column shaped, every reference preserved, then export the workbook your team uses next.