Header row
Formatted, frozen, with set column widths so the sheet scrolls cleanly on long registers.
Instrument index Excel template.
14 columns including vendor, model, range, and datasheet ref. Signal-class dropdown. Auto-filter on every column. Frozen header. 48 blank rows ready to fill. Free download, no signup.
Format.xlsxColumns14Rows48 blankOpens inExcel · Sheets · LibreOffice
instrument-index-template.xlsx·Instrument Index
Tag
Service
Type
Sig
Vendor
Loc
FIT-101
FIT
AI
Rosemount
Field
PT-102
PT
AI
Endress+Hauser
Field
TIT-103
TIT
AI
Rosemount
Field
LSH-201
LSH
DI
Magnetrol
Field
PSHH-301
PSHH
DI
Ashcroft
Field
XV-402
XV
DO
Fisher
Field
6 / 48 rows shown·14 columns total+ 8 columns →
Every column, defined.
14 columns mapped to how a master instrument index is issued on a real project. Signal class is enforced; everything else stays free text so non-ISA dialects fit.
#ColumnTypeDescription
01Tag NumberTextISA tag (FIT-101, PT-102, XV-401)
02Service / DescriptionTextWhat the instrument measures or controls
03TypeTextISA letter group (FIT, PT, LSH, XV)
04Signal ClassListAI, AO, DI, DO, or N/A
05Loop NumberTextControl loop the tag belongs to
06P&ID DrawingTextDrawing number where the tag appears
07PageNumPage within the drawing set
08ManufacturerTextVendor (Rosemount, Endress+Hauser, ...)
09ModelTextModel or part number from the datasheet
10RangeTextMeasurement range (0-500 GPM)
11Process ConnectionTextConnection class (1" 150# RF, 1/2 NPT)
12LocationTextMounting (Field, Panel, JB-101)
13Datasheet RefTextCross-reference to the ISA-20 datasheet
14NotesTextAdditional context or flags
What ships in the file.
Signal-class dropdown
Enforced values: AI, AO, DI, DO, N/A. Stops drift before it reaches the PLC.
Auto-filter
Enabled on every column. Pivot by loop, by vendor, by location without a single formula.
Worked example
One filled row (FIT-101) shows the format for vendor, model, range, and datasheet reference.
48 blank rows
Pre-formatted and ready to paste into. Extends without breaking the dropdown or filter range.
Datasheet linking
A dedicated Datasheet Ref column points to the matching ISA-20 datasheet. The index doubles as a lookup.
Cross-tool
Plain .xlsx. Opens cleanly in Excel, Google Sheets, and LibreOffice. No macros, no add-ins.
Quiet signoff
A single mint-italic line at the bottom: Drag a P&ID at tagsight.io to fill this automatically. Easy to delete.
Tagsight reads the drawings, extracts every instrument, classifies it, and returns the same 14-column schema this template defines. Loop numbers and P&ID references are populated from the drawing itself.
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.