Api 610 12th Edition Data Sheet Excel Review
API sells a standard package that includes an Excel template. Cost is around $250–$350 for members. This is the most accurate but often too generic for project-specific needs.
The 12th edition introduces clearer distinctions between oil mist, splash, and forced-feed lubrication. Your datasheet must now include specific columns for:
API 610 12th Edition (released January 2021) introduced a revised, official Excel-based data sheet template
to streamline the specification process for centrifugal pumps . This digital transition, detailed in
, replaces manual forms with a color-coded system to clarify responsibilities between purchasers and suppliers. Amarinth Pumps UK Key Features of the 12th Edition Excel Data Sheet
The new template is designed to improve data accuracy and support Electronic Data Interchange (EDI)
, allowing information to be transmitted digitally across engineering systems. Color-Coded Responsibility
: The Excel sheets use specific cell colors to indicate who must complete each field: Black Text : Data to be completed by the (e.g., operating conditions). : Data to be completed by the supplier/vendor (e.g., technical pump specs). : Fields that can be filled by Green Cells drop-down menus to ensure consistent nomenclature and reduce entry errors. Annex N Structure Figure N.1 & N.2 : Typical pump data sheets in both US Customary (USC) SI (Metric) Figure N.3 (Data Element List)
: A tabular alternative to the conventional layout, intended to compile all data into a neutral format for machine-to-machine exchange. Figure N.4 (Project Design Data Sheet)
: A summary sheet for recording site-specific design conditions and utilities (e.g., power supply, cooling water). Critical Data Entry Changes
The 12th Edition data sheet requires more granular information than previous versions to ensure better pump selection. Amarinth Pumps UK Rated (Normal) Data
: Purchasers must now provide process conditions and liquid characteristics for rated/normal
operation, in addition to minimum and maximum conditions. This is crucial for selecting the most efficient pump. Specific Gravity Requirements
: Maximum specific gravity must be clearly stated, as it is now the base for calculating Maximum Allowable Working Pressure (MAWP). Finite Life Notification
: While the 11th edition had a 20-year design life, the 12th edition requires manufacturers to explicitly list any components designed for a finite life on the data sheet. Parallel Operation
: For pumps with discharge nozzles larger than 3 inches operating in parallel, the data sheet must reflect head values within 3% of each other in the preferred operating region. Amarinth Pumps UK Availability and Access
The official Excel data sheets are typically sold as a companion to the standard. You can find the full specification and associated files through standard bodies: Accuris Standards Store API Standards Store
: Official source for the API 610 12th Edition and its data sheets. Accuris Standards Store
: Provides the standalone January 2021 data sheet files for purchase. Amarinth Technical Guides
: Offer white papers and detailed summaries of how to fill out these sheets correctly. Accuris Standards Store Annex G material class updates that need to be reflected in your data sheet entries? API 610 12th Edition - Amarinth Pumps
API 610 12th Edition (published January 2021) standardizes centrifugal pumps for the petroleum, petrochemical, and natural gas industries. A cornerstone of this update is the Excel-based data sheet
, designed to enhance clarity and support Electronic Data Exchange (EDE) between purchasers and suppliers Key Features of the API 610 12th Edition Data Sheet
The new data sheet introduces a color-coded system to clearly define responsibilities: Green Cells
: Contain standardized drop-down menus for consistent data entry. Black Text : Data to be completed by the : Data to be completed by the : Can be filled by either party. Major Updates and Changes in the 12th Edition Expanded Operating Points
: Beyond normal and rated conditions, the data sheet now includes fields for three additional operating points
. This helps ensure the driver (e.g., electric motor) can handle varying specific gravities, such as during maintenance flushes. Rated Data Requirement : Process and liquid characteristics are now required for rated (normal) data
, eliminating previous misunderstandings that hindered efficient pump selection. Performance Test Points : The performance test now requires 9 data points
(up from 6 in the 11th edition) to better map the pump curve within the allowable operating range. Parallel Operation
: For pumps with discharge nozzles larger than 3 inches (80 mm), head values must now be within 3% of each other in the preferred operating region. NPSH Datum Point
: For vertical pumps (VS4 and vertical in-line), the NPSH3 reference point has shifted to the impeller suction eye to maintain consistency with horizontal pumps. Technical Sections in the Data Sheet
The data sheet typically covers the following critical engineering domains: Operating Conditions
: Flow rates, pressures, and temperatures for all specified points. Liquid Properties : Specific gravity, viscosity, and vapor pressure. Materials of Construction
: Updated classes (e.g., removing I-1 and I-2 cast iron groups) and specific material designations like for duplex pressure castings. Testing and Inspection
: Communicating expected test dates 30 days in advance and providing 5 days' notice for witnessed tests. Where to Find the Official Data Sheet The official API 610 12th Edition Data Sheets Api 610 12th Edition Data Sheet Excel
are available for purchase through authorized distributors like Accuris Standards Store
API 610 12th Edition Data Sheet Excel: A Comprehensive Guide
The American Petroleum Institute (API) Standard 610, 12th Edition, provides specifications for centrifugal pumps, including their design, materials, testing, and documentation. A data sheet is a critical document that outlines the pump's performance, design, and operating parameters.
Why Create an API 610 Data Sheet in Excel?
Excel is a widely used and versatile tool for creating data sheets, offering several benefits:
Key Components of an API 610 12th Edition Data Sheet
A comprehensive data sheet for API 610 12th Edition centrifugal pumps should include:
Creating an API 610 12th Edition Data Sheet in Excel
To create a data sheet in Excel, follow these steps:
Here's a sample API 610 12th Edition data sheet template in Excel:
| Section | Parameter | Value | Unit | | --- | --- | --- | --- | | Pump Configuration | Pump Type | | | | | Pump Size | | | | Performance Parameters | Flow Rate (Q) | | m³/h | | | Head (H) | | m | | | Power (P) | | kW | | Design and Materials | Casing Material | | | | | Impeller Material | | | | Operating Conditions | Temperature Range | | °C | | | Pressure Range | | barg |
Best Practices and Tips
When creating an API 610 12th Edition data sheet in Excel, keep the following best practices and tips in mind:
By following these guidelines and best practices, you'll be able to create a comprehensive and accurate API 610 12th Edition data sheet in Excel, ensuring that your centrifugal pump design meets the required standards and specifications.
The API 610 12th Edition Data Sheet in Excel format is more than just a document; it’s the primary interface for digital technical procurement in the oil and gas industry. Released in January 2021, the 12th edition updates critical parameters for centrifugal pumps to align with modern reliability and safety standards. Key Features of the 12th Edition Excel Data Sheet
The transition to Excel allows for Electronic Data Exchange (EDE), enabling purchasers and vendors to import/export pump specifications directly into bid tab programs and asset management systems.
Expanded Performance Test Points: The data sheet now tracks 9 performance test points (up from 6 in the 11th edition) to better define the pump's allowable and preferred operating regions.
"Field Proven" Verification: Replacing the previous 20-year service life requirement, the data sheet now includes fields for vendors to provide evidence of "field proven" reliability for specific models.
Parallel Operation Precision: For pumps operating in parallel, the data sheet requires head values at rated flow to be within 3% of each other, ensuring balanced load sharing.
Enhanced Instrumentation & Safety: New dedicated sections or "data lists" capture details for shaft guards, updated baseplate numbers (2.5 to 12), and VFD (Variable Frequency Drive) considerations.
Material Designations: The 12th edition features a streamlined set of material columns and improved designations for non-metallic components. Typical Structure of the Excel Template
The standard Microsoft Excel spreadsheets provided by API are typically organized into several core tabs or sections: Key Changes in API 610 12th Edition | PDF | Pump - Scribd
The API 610 12th Edition (released January 2021) introduced a revised Excel-based data sheet template designed to improve consistency and support Electronic Data Exchange (EDE). Key Features of the Excel Template
The 12th Edition Excel template uses a color-coding system to clarify responsibilities between the purchaser and vendor:
Green Cells: Contain drop-down menus for consistent data entry. Black Text: Fields for the purchaser to complete initially.
Blue Text: Information provided by the vendor during the proposal phase. Critical Review of Data Sheet Changes
While the format is more user-friendly, there are several significant technical shifts reflected in these new sheets compared to the 11th Edition:
Field Proven Requirements: Data sheets now require confirmation that the pump model is "field proven." If it is not, the vendor must provide an explanation of how it meets reliability standards.
Parallel Operation: For pumps with a discharge larger than 3 inches (80 mm) intended for parallel operation, the head values must be within 3% of each other.
Shaft Guards: The 12th Edition mandates shaft guards for all pumps, with specific data points for venting to prevent liquid or vapor accumulation.
Performance Testing: New data fields were added for mandatory performance test points, including a requirement that no two test points in the allowable operating range be more than 35% apart in flow.
Service Life: The explicit "20-year design life" was removed; instead, manufacturers must now list any finite-life components on the data sheet. Where to Find the Official Sheet Highlights of Draft API 610 12th Edition - OAKTrust
API 610 12th Edition data sheet, found in , is a standardized template used to specify centrifugal pumps for the petroleum and gas industries. Unlike previous versions, the 12th Edition (released January 2021) emphasizes Electronic Data Exchange (EDE) API sells a standard package that includes an Excel template
and introduces a more interactive Excel format to reduce communication errors between purchasers and vendors. Key Features of the Excel Data Sheet Color-Coded Responsibilities
: Cells are color-coded to clearly define who completes each section: Black Text : Completed by the (e.g., process conditions, site data). : Completed by the (e.g., pump performance, construction details). : Can be completed by either party Green Cells drop-down menus
for standardized options (e.g., material grades, pump types) to ensure consistency. Expanded Data Requirements
: Process conditions and liquid characteristics are now required for rated (normal) data
, not just minimum and maximum values, to ensure the most efficient pump selection. Data Element List
: Annex N also includes a "data element list" in a neutral tabular format to support digital transmission rather than just manual document sharing. Major Changes in the 12th Edition (vs. 11th) Pump Classification
: Detailed updates to classifications for overhung (OH), between-bearings (BB), and vertically suspended (VS) pumps. Material Grades : Informative
has been updated; for example, cast iron groups I-1 and I-2 were removed and replaced with Performance Testing : New requirements for NPSH3 (NPSHR)
testing at multiple test points and revised notification timelines (30 days advance for test dates). Safety & Reliability
: Enhanced requirements for shaft guards and baseplate design, and a clearer hierarchy where the purchase order governs in case of conflict with the standard. Amarinth Pumps UK Where to Find It
The official Excel templates are typically bundled with the purchase of the API 610 12th Edition Standard
through authorized distributors. While unofficial previews are available on platforms like
The release of the API 610 12th Edition in January 2021 brought significant updates to the centrifugal pump standards used in the petroleum and natural gas industries. One of the most practical changes for engineers and procurement teams is the introduction of a new Excel-based data sheet template designed to streamline pump specification and reduce misunderstandings between purchasers and suppliers. Key Features of the API 610 12th Edition Excel Data Sheet
The new Excel format is more than just a digital version of the old paper forms; it includes several functional improvements:
Color-Coded Responsibilities: The template uses color coding to clearly identify who is responsible for each cell:
Green: Cells with drop-down menus for consistent data entry. Black: Fields to be completed by the purchaser. Blue: Fields for the supplier (vendor) to complete. Red: Fields that can be filled by either party.
Detailed Operating Data: Unlike previous editions, the 12th Edition requires "rated" (normal) data for process conditions and fluid properties, in addition to the standard minimum and maximum values. This helps ensure the most efficient pump is selected for actual operating conditions.
Electronic Data Exchange (EDE): A new "data list" in a neutral tabular format has been introduced alongside the data sheets to support EDE between contractors and manufacturers, minimizing errors from manual data transcription.
Unit of Measure: U.S. Customary Units are now the primary measure, with metric units typically provided in parentheses. Major Standards Changes to Note on Your Data Sheet
When filling out your next data sheet, be aware of these critical technical shifts in the 12th Edition:
Shaft Guards: Venting is now mandatory for guards to prevent the accumulation of emissions, and visual inspection of the seal must be possible without removing the guard.
Parallel Operation: For pumps with discharge nozzles larger than 3 inches (80mm), head values must be within 3% of each other in the preferred operating region to ensure stability.
Baseplates: The 12th Edition provides more specific requirements for single-piece baseplates for horizontal pumps, including mandatory grout holes and specific slope requirements for drainage.
NPSH Datum: For vertically suspended (VS) and vertical in-line pumps, the NPSH datum point has shifted from the foundation/nozzle centerline to the impeller suction eye for consistency with horizontal pumps. Accessing the Data Sheet
The official API 610 12th Edition data sheets are available for purchase and download through standards retailers like the Accuris Standards Store. For specialized procurement, the IOGP S-615 specification offers additional supplementary guidance for applying these standards in international projects. API 610 12th Edition - Amarinth
The API 610 12th Edition represents the latest evolution in the design and manufacture of centrifugal pumps for the petroleum, petrochemical, and natural gas industries. For engineers and procurement specialists, the Data Sheet is the most critical document in this standard, serving as the "birth certificate" and technical blueprint for every pump on a project.
Transitioning to an Excel-based data sheet for the 12th Edition isn't just about convenience—it’s about data integrity and engineering efficiency. Understanding the API 610 12th Edition Data Sheet
The API 610 standard provides a standardized format (Annex N) for recording pump requirements. The 12th Edition introduced several nuances in performance testing, materials selection, and mechanical seal piping plans (aligning with API 682).
A comprehensive Excel data sheet for the 12th Edition typically includes several key tabs:
Process Data: Flow rates (rated/normal), NPSH available, fluid properties (viscosity, vapor pressure), and operating temperatures.
Construction Details: Pump type (e.g., OH2, BB3, VS4), casing mounting, nozzle ratings, and rotation direction.
Materials of Construction: API material classes (S-1, S-6, C-6, etc.) for the casing, impeller, and shaft.
Mechanical Seals: Detailed specifications for API 682 seal plans, flush arrangements, and barrier fluids. Key Components of an API 610 12th Edition
Motor & Drive Data: Power ratings, voltage, enclosure types, and hazardous area classifications. Why Use Excel for API 610 Data Sheets?
While PDFs are the standard for final "Issued for Construction" (IFC) documents, Excel is the workhorse of the engineering phase for several reasons:
Calculations & Automation: Excel allows for live calculations of NPSH Margin, Specific Speed ( Nscap N sub s ), and Suction Specific Speed ( Nsscap N sub s s end-sub ).
Bulk Data Management: When managing 50+ pumps on a large refinery project, Excel allows for "Master Lists" where data can be pushed to individual sheets via VLOOKUP or Macros.
Software Integration: Most modern Engineering, Procurement, and Construction (EPC) firms use Excel as an intermediary to upload data into larger Asset Management systems or simulation software.
Version Control: Tracking changes between the "Preliminary" and "As-Built" stages is significantly easier using Excel's comparison tools. Key Changes in the 12th Edition to Reflect in Your Template
If you are building or updating an Excel template for the 12th Edition, ensure you account for these updates:
Updated Material Tables: Ensure your dropdown menus reflect the updated metallurgy requirements.
Vibration Limits: The 12th edition maintains strict vibration limits, but your data sheet should clearly define the testing requirements for "Standard" vs. "Special" applications.
Energy Efficiency: There is a greater emphasis on documenting pump efficiency at the Best Efficiency Point (BEP) to align with modern ESG and energy-saving initiatives. Best Practices for Your Excel Template
To make your API 610 12th Edition Data Sheet truly "engineering-grade," consider these features:
Input Validation: Use dropdown menus for "Pump Type" and "Material Class" to prevent typos.
Conditional Formatting: Highlight cells where NPSHa < NPSHr in red to immediately alert the engineer to cavitation risks.
Standardized Units: Include a toggle for Metric (SI) vs. US Customary units to avoid conversion errors during international procurement.
Electronic Signatures: Include a dedicated area for digital approval stamps to maintain a clear audit trail. Conclusion
The API 610 12th Edition Data Sheet in Excel is more than just a form; it is a calculation engine and a communication tool. By leveraging the flexibility of Excel, engineering teams can ensure that their centrifugal pumps are not only compliant with the latest industry standards but are also optimized for long-term reliability and performance.
The fluorescent lights of the engineering office hummed at 2:00 AM, a stark contrast to the silence of the rest of the refinery project floor. Mark, a senior mechanical engineer, stared at a flickering cursor on his monitor. He wasn't designing a new turbine or calculating thermal expansion; he was wrestling with a legacy spreadsheet that looked like it had been designed in the era of dial-up internet.
The project—a critical hydrocarbon processing unit—demanded pumps compliant with API 610 12th Edition. The jump from the 11th edition wasn't just a number change; it introduced tighter vibration limits, updated material classes, and more rigorous testing protocols.
"One wrong cell," Mark muttered, rubbing his eyes, "and we’re ordering a $200,000 pump that doesn't fit the nozzle load requirements."
He opened his "Master API 610 12th Edition Data Sheet" in Excel. It was a masterpiece of conditional formatting and hidden VLOOKUPs. As he toggled the pump type to OH2 (centerline-mounted overhung), the spreadsheet reacted. The "Minimum Continuous Stable Flow" cells turned amber, signaling a conflict with the process fluid’s specific gravity.
Mark adjusted the suction pressure. Suddenly, the NPSH (Net Positive Suction Head) margin flashed red. In the 12th Edition, the margin requirements for high-energy pumps had shifted. The Excel sheet, programmed with the new standard's logic, was doing exactly what it was designed for: acting as a digital safety net.
He spent the next hour meticulously filling out the 'Operating Conditions' tab. Every time he entered a value, the sheet calculated the Pressure-Temperature rating against the selected material class (S-6, C-6, or A-8). He didn't have to flip through the paper standard's Annexes; the formulas did the heavy lifting.
By 4:00 AM, the data sheet was complete. He hit "Export to PDF," the final 12th Edition-compliant document ready for the vendor's bid. It wasn't just a file; it was the bridge between a theoretical design and a massive piece of rotating machinery that would run for the next twenty years.
Mark saved the file, backed it up, and finally turned off his monitor. The pump would be reliable, the project would be safe, and—thanks to a well-built Excel sheet—he could finally go home.
✅ Use it – but only if:
❌ Avoid if:
To successfully execute a pump procurement using the API 610 12th edition, follow this workflow:
The pump might be made of stainless steel or duplex, but the foundation of a successful project is stainless data. Do not rely on memory or loose paper notes. Download the latest API 610 12th edition datasheet template today, and ensure your centrifugal pumps run reliably for the next 20 years.
Do you have a specific API 610 Excel template you need help validating? Or are you looking for a blank copy of the 12th edition datasheet in XLSX format? Leave your request in the comments below.
The data sheet now aligns more closely with API 682 (Pumps—Shaft Sealing Systems).
You have three options:
Corrosion management is a moving target. The 12th Edition data sheet incorporates updates referencing ISO 15156 / NACE MR0175 for sour service.