Header row
Formatted, frozen, with set column widths so a loop index across hundreds of loops scrolls cleanly.
Loop sheet Excel template.
11 columns including function, loop diagram reference, and datasheet cross-reference. Signal-class dropdown. Auto-filter on every column. Frozen header. 48 blank rows ready to fill. Free download, no signup.
Format.xlsxColumns11Rows48 blankOpens inExcel · Sheets · LibreOffice
loop-sheet-template.xlsx·Loop Folder Index
Loop
Service
Tag
Function
Sig
LD Ref
101
FIT-101
Indicate
AI
LD-101
102
PIC-102
Control
AO
LD-102
103
TIC-103
Control
AO
LD-103
201
LSH-201
Alarm
DI
LD-201
301
PSHH-301
Trip
DI
LD-301
402
XV-402
Trip
DO
LD-402
6 / 48 rows shown·11 columns total+ 5 columns →
Every column, defined.
11 columns mapped to how a loop folder cover index is issued on a project. Signal class is enforced; loop function stays free text so non-standard functions fit.
#ColumnTypeDescription
01Loop NumberTextControl loop number (101, 201)
02ServiceTextWhat the loop controls or measures
03Tag NumberTextLead tag of the loop (FIT-101, TIC-201)
04Instrument TypeTextISA letter group (FIT, TIC, PSV)
05Signal ClassListAI, AO, DI, DO, or N/A
06FunctionTextIndicate, Control, Trip, Alarm, Interlock
07P&ID DrawingTextP&ID where the loop appears
08Loop Diagram RefTextReference to the loop wiring diagram
09Datasheet RefTextReference to the per-instrument datasheet
10DescriptionTextLoop description / commissioning notes
11NotesTextStatus, hold list, SIS designation
What ships in the file.
Signal-class dropdown
Enforced values: AI, AO, DI, DO, N/A. Keeps the loop count by signal class auditable.
Auto-filter
Enabled on every column. Filter by function (trips only, control only), by signal class, by P&ID drawing without a formula.
Worked example
One filled row (loop 101, FIT-101, Indicate) shows the format for Function, Loop Diagram Ref, and Datasheet Ref.
48 blank rows
Pre-formatted and ready to paste into. Extends without breaking the dropdown or filter range.
Loop folder structure
Loop Diagram Ref and Datasheet Ref sit next to the loop number. The index doubles as the loop folder cover.
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, groups instruments into loops by tag number, and returns the same 11-column schema this template defines. Loop function is inferred from instrument type (indicate, control, trip), and the P&ID page reference comes 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.