Pump datasheet to Excel.
An API 610 pump datasheet is the rotating-equipment specification document for a centrifugal process pump. One datasheet per pump tag carries the pump type per API 610 12th edition (OH overhung, BB between-bearings, VS vertical-suspended, SP submersible), service, capacity in GPM or m3/h, total dynamic head (TDH), best efficiency point (BEP), net positive suction head required (NPSHr), suction and discharge sizes, design temperature, materials of construction for casing, impeller, shaft, and wear-rings, the API 682 seal plan number (Plan 11, 13, 23, 32, 52, 53A/B/C, 54, 66, 72-76), driver type, and the matching motor reference. ISO 5199 is the equivalent international standard.
Upload an API 610 or ISO 5199 pump datasheet binder and extract every pump into a structured spreadsheet. Tag, service, capacity, total dynamic head, BEP efficiency, NPSH required, suction and discharge sizes, materials, seal arrangement, driver type, and motor reference all read into the columns the rotating-equipment specialist and the bidder use.
| Designation | Configuration | Typical service |
|---|---|---|
| OH1 / OH2 | Overhung, foot-mounted / centerline | General process duty |
| OH3 | Overhung, vertical inline | In-line piping integration |
| BB1 / BB2 | Between-bearings, axially split | Higher head, higher temperature |
| BB3 / BB4 / BB5 | Multi-stage between-bearings | Boiler feed, high-pressure injection |
| VS1-VS7 | Vertical suspended in barrel or sump | Sump service, low-NPSHa applications |
| SP | Submersible, motor below process | Tank evacuation, lift-station service |
Fields extracted.
Every column the api 610 / iso 5199 pump datasheet typically carries is read and shaped into a structured row. Missing fields stay blank, never invented.
- Pump tag
- Service
- Pump typeOH, BB, VS, SP per API 610
- CapacityGPM or m3/h
- Total dynamic head
- BEP efficiency
- NPSH required
- Suction size
- Discharge size
- Suction pressure
- Discharge pressure
- Design temperature
- Materialscasing, impeller, shaft, wear-rings
- Seal arrangementAPI 682 plan number
- Driver typemotor / steam turbine / engine
- Motor tag
- Vendor
- Model
- Notes
Export targets.
The extracted data ships in the format your team picks up and uses directly.
- .xlsxExcel workbook (pump register)
- .csvCSV
- .xlsxPer-vendor bid comparison workbook
From legacy file to clean register.
Common questions.
Does this read API 610 11th and 12th edition forms correctly?
Yes. Both editions of API 610 read as drawn. Edition-specific changes (revised NPSH margin recommendations, expanded seal-plan options, added vibration acceptance criteria) extract into the same column shape; edition number preserves in a metadata column.
Does it preserve API 682 seal plan numbers?
Yes. API 682 seal plans (Plan 11, 13, 23, 32, 52, 53A/B/C, 54, 66, 72-76) extract into the seal-arrangement column with the plan number preserved as drawn. Dual-seal arrangements with two plans note both.
Can the bid comparison workbook flag vendors who under-margined NPSH?
Yes. The comparison workbook calculates the NPSH margin (NPSHa - NPSHr) per vendor against the same hydraulic condition. Vendors who returned an NPSHr above the design margin flag for review; the engineering decision about the margin itself stays with the rotating-equipment specialist.
Convert your file.
Upload a api 610 / iso 5199 pump datasheet in any format, get every row read, every column shaped, every reference preserved, then export the workbook your team uses next.