Section structure
Eight ISA-20 sections, each opening on a mono header row. The form scans top to bottom.
ISA-20 datasheet Excel template.
27 fields across eight ISA-20 sections. Five enforced dropdowns. Worked example included. Seven sheets per workbook. Free download, no signup.
Format.xlsxFields27Sheets7Opens inExcel · Sheets · LibreOffice
instrument-datasheet-template.xlsx·Worked example
— Identification —
Tag No.
FIT-101
Service / Description
Feed flow to reactor
P&ID Sheet
100-001
Drawing Reference
P-100-001-R0
— Process —
Process Variable
Flow
Measurement Range
0-500 GPM
Service Medium
Process water
Communication Protocol
4-20mA + HART
Sections 1 / 2 of 7 shown·27 fields total+ 5 sections ↓
Every field, by section.
Eight ISA-20 sections. 27 fields. Five dropdowns enforce signal class, system, fail position, actuator type, and valve action; the rest stay free text so vendor specifics fit.
— Identification — 4 fields
Tag No.Texte.g. FIT-101
Service / DescriptionTexte.g. Feed flow to reactor
P&ID SheetTexte.g. 100-001
Drawing ReferenceTexte.g. P-100-001-R0
— Process — 4 fields
Process VariableTexte.g. Flow
Measurement RangeTexte.g. 0-500 GPM
Service MediumTexte.g. Process water
Communication ProtocolTexte.g. 4-20mA + HART
— Signal — 4 fields
Signal ClassListe.g. AI
Signal TypeTexte.g. 4-20mA
SystemListe.g. BPCS
Loop No.Texte.g. 101
— Mounting — 4 fields
LocationTexte.g. Field
Parent PanelTexte.g. JB-101
Process ConnectionTexte.g. 1" 150# RF
Wetted MaterialsTexte.g. 316SS
— Final Element — 4 fields
Valve TypeText—
Fail PositionList—
Actuator TypeList—
Valve ActionList—
— Vendor to be filled — 3 fields
ManufacturerTexte.g. Rosemount
Model / Part No.Texte.g. 8732EM
Serial No.Texte.g. TBD
— References & Notes — 4 fields
SetpointTexte.g. 250 GPM
Safety FunctionTexte.g. None
Connected EquipmentTexte.g. P-101
NotesTexte.g. Primary flow indicator
What ships in the file.
Five dropdowns
Signal class, system, fail position, actuator type, valve action. ISA-standard values enforced on every dropdown.
Worked example
Sheet 2 is a filled FIT-101 datasheet. Every field shows what it expects.
Seven sheets
One blank, one worked example, five blank duplicates. Right-click any tab to add more.
Vendor block
Manufacturer, Model, and Serial No. live in their own block. Spec and vendor return stay separated.
Final element
Valve type, fail position, actuator type, valve action. One form covers transmitters and control valves.
Cross-tool
Plain .xlsx. Opens cleanly in Excel, Google Sheets, and LibreOffice. No macros.
Quiet signoff
A single mint-italic line at the bottom of every sheet: Drag a P&ID at tagsight.io to fill this automatically. Easy to delete.
Tagsight reads a P&ID set, classifies every instrument, and returns ISA-20 datasheets prefilled with Tag, Service, P&ID Sheet, Signal Class, Signal Type, System, Loop No., and Location. Vendor fields (Manufacturer, Model, Range, Process Connection, Wetted Materials, Setpoint) stay open for the instrument engineer to fill from the specification.
Scanned drawings, CAD-exported PDFs, and image scans all work. ISA 5.1, KKS, IEC 81346, DIN, NORSOK, JIS, GOST, and in-house tag conventions read as drawn.