PFD to Excel.
A process flow diagram (PFD) is the engineering document that shows the major equipment and stream paths of a process, with stream conditions tabulated at each point: mass flow, temperature, pressure, density, vapor fraction, composition by component, and heat duty. PFDs sit between block flow diagrams (which show only equipment groups) and piping and instrumentation diagrams (which show every line, instrument, and valve). The PFD is the working document of the process engineer through FEED and detailed engineering, and the stream summary it carries is the foundation for the heat and material balance, the energy integration study, and the process simulation.
Upload a process flow diagram (PFD) and extract every stream into a structured spreadsheet. Stream tag, source equipment, destination equipment, mass flow, temperature, pressure, density, vapor fraction, heat duty, and composition all read into the columns process engineers use to populate heat and material balances.
| Field | On the PFD | In the extracted workbook |
|---|---|---|
| Stream tag | Numbered circle or labeled arrow | One row per stream, sortable |
| Source / destination | Drawn as connection | Resolved to equipment tag columns |
| Composition | Tabular block in the corner | One column per component, mole or mass fraction preserved |
| Heat duty | Annotated at the equipment | Tied to source equipment row |
| Phase + vapor fraction | Annotated with mole fraction | Columns extracted as drawn |
| Stream conditions | T / P / flow per point | Per-column with units preserved |
Fields extracted.
Every column the process flow diagram typically carries is read and shaped into a structured row. Missing fields stay blank, never invented.
- Stream tag
- Source equipment
- Destination equipment
- Phasevapor / liquid / two-phase
- Mass flowkg/h or lb/h
- Volumetric flowm3/h or actual conditions
- Temperature
- Pressure
- Density
- Viscosity
- Vapor fraction
- Compositionmole or mass fraction by component
- Heat dutyfor heat-exchanger and heater streams
- Notes
Export targets.
The extracted data ships in the format your team picks up and uses directly.
- .xlsxExcel workbook (stream summary)
- .csvCSV
- .xlsxHeat and material balance worksheet
From legacy file to clean register.
Common questions.
What formats are accepted?
PDF (CAD-exported or scanned), PNG, JPG, TIFF. Hand-drawn legacy PFDs scan and process the same as clean CAD exports; lower-confidence stream rows are flagged for review before export.
Does this read stream composition tables off the PFD?
Yes. PFD composition tables (typically rendered as a tabular block in the corner of the drawing) extract into per-component columns. The composition basis (mole vs mass fraction) carries through to the export so the heat-material balance worksheet stays interpretable.
Can the export feed a process simulator (Aspen Plus, HYSYS, ProMax)?
The structured Excel export is the input shape these simulators read for stream summary import. Component IDs and unit conventions stay as drawn; the simulator's own component database does the final mapping.
Does it handle multiple-train PFDs that share a stream table?
Yes. Multi-train PFDs (overhead, side stream, bottoms in a single sheet) extract every train's streams into the same export. Stream tags carry the train designation as drawn.
What about utility-PFD documents?
Utility PFDs (cooling water, steam, instrument air, plant air, nitrogen) extract the same way as process PFDs. The utility scope filters into a separate sheet so the controls integrator can hand it to the BMS scope owner.
Convert your file.
Upload a process flow diagram in any format, get every row read, every column shaped, every reference preserved, then export the workbook your team uses next.