Heat exchanger datasheet to Excel.
A TEMA heat exchanger datasheet is the rotating-equipment specification document for a process heat exchanger, structured per the Tubular Exchanger Manufacturers Association standard. One datasheet per exchanger tag carries the TEMA type code (BEM, AEL, NEN, AKT, and other 3-letter combinations of front-head / shell / rear-head designations), shell-side and tube-side fluids, design pressures and temperatures, heat duty, log mean temperature difference (LMTD), UA, materials of construction for shell and tubes, tube count and length, empty and hydrotest weights, and the vendor's design data. The TEMA datasheet is the bid document and the lifetime asset record.
Upload a TEMA heat exchanger datasheet binder and extract every exchanger into a structured spreadsheet. Tag, TEMA type, shell-side and tube-side fluids, design pressures and temperatures, duty, LMTD, UA, materials, weights, and connection schedule all read into the columns the rotating-equipment reviewer and the asset register expect.
| Family | TEMA designation | Typical service |
|---|---|---|
| Shell and tube (fixed) | BEM, BKM, BFM | Clean process / utility duty |
| Shell and tube (floating) | AES, AET, AEW, AKT | Fouling service, frequent cleaning |
| U-tube | AEU, BEU, CEU | High pressure tube side, thermal expansion accommodated |
| Kettle reboiler | AKT, BKT, CKT | Tower bottom vaporization |
| Plate and frame | (non-TEMA) | Compact, high-fouling clean-in-place |
| Plate-fin / brazed | (non-TEMA) | Cryogenic, cold-box service |
Fields extracted.
Every column the tema heat exchanger datasheet typically carries is read and shaped into a structured row. Missing fields stay blank, never invented.
- Equipment tag
- TEMA typeBEM, AEL, NEN, AKT, etc.
- Service
- Shell side fluid
- Tube side fluid
- Shell design pressure
- Tube design pressure
- Shell design temperature
- Tube design temperature
- Duty
- LMTD
- UA
- Shell material
- Tube material
- Tube count
- Tube length
- Empty weight
- Hydrotest weight
- Vendor
- Model
- Notes
Export targets.
The extracted data ships in the format your team picks up and uses directly.
- .xlsxExcel workbook (heat exchanger register)
- .csvCSV
- .xlsxPer-vendor comparison workbook
From legacy file to clean register.
Common questions.
Does this work with vendor-specific datasheet forms?
Yes. Vendor forms (Alfa Laval, Kelvion, API, Tranter, SPX) read as drawn. Vendor-specific field labels map to the canonical TEMA datasheet column shape; the source-form column preserves the original notation for review.
Can this handle plate-and-frame exchangers alongside shell-and-tube?
Yes. Plate-and-frame, plate-fin, double-pipe (hairpin), and air-cooled exchangers extract into the same register with the equipment-type column distinguishing them. TEMA-only fields are blank on non-TEMA forms; type-specific fields (plate count, plate pattern, fan count) extract into a type-specific sub-block.
Does the per-vendor comparison workbook surface bid disagreements?
Yes. Run each vendor's datasheet binder as a separate workspace, then export a side-by-side comparison on duty, LMTD, UA, materials, and weights. Where vendors interpreted the duty spec differently - over-surfaced, smaller area, different materials - the comparison surfaces the engineering decision.
Convert your file.
Upload a tema heat exchanger datasheet in any format, get every row read, every column shaped, every reference preserved, then export the workbook your team uses next.