Header row
Formatted, frozen, with set column widths so termination lists across many JBs scroll cleanly.
Junction box schedule Excel template.
11 columns including terminal strip, terminal number, wire number, and wire colour. 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
junction-box-schedule-template.xlsx·JB Schedule
JB
Strip
Term
Color
Tag
Sig
JB-101
TS-1
1
FIT-101
AI
JB-101
TS-1
2
FIT-101
AI
JB-101
TS-1
3
PT-102
AI
JB-101
TS-1
4
PT-102
AI
JB-301
TS-1
1
PSHH-301
DI
JB-401
TS-2
12
XV-402
DO
6 / 48 rows shown·11 columns total+ 4 columns →
Every column, defined.
11 columns mapped to how a JB termination schedule is issued for wiring. Signal class is enforced; wire colour stays free text so IEC and North American codes both fit.
#ColumnTypeDescription
01JB TagTextJunction box tag (JB-101, MJB-3)
02Terminal StripTextStrip identifier (TS-1, TB-A)
03Terminal NumberTextTerminal position (1, 2, 17)
04Wire NumberTextWire tag (1+, 1-, S)
05Wire ColorTextIEC 60757 or project colour code
06Cable NumberTextCable landing on the terminal (C-101-001)
07Instrument TagTextInstrument the wire serves
08Signal ClassListAI, AO, DI, DO, or N/A
09FromTextOrigin (instrument terminal or upstream JB)
10ToTextDestination (DCS, MCC, downstream device)
11NotesTextSpare, shield, intrinsic safety, IS barrier
What ships in the file.
Signal-class dropdown
Enforced values: AI, AO, DI, DO, N/A. Stops mismatch between the JB schedule and the I/O list.
Auto-filter
Enabled on every column. Filter to a single JB or strip to print just that page for the wireman.
Worked example
One filled row (JB-101, terminal TS-1 / 1, wire 1+) shows the format for terminal, wire, and cable mapping.
48 blank rows
Pre-formatted and ready to paste into. Extends without breaking the dropdown or filter range.
Terminal numbering
Separate Terminal Strip and Terminal Number columns. TS-1 / 1 stays distinct from TS-2 / 1.
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 and returns the JB tag, instrument tag, cable number, and signal class derived from each loop. Terminal strip, terminal number, and wire colour are usually drawn from JB drawings rather than P&IDs, so those columns stay open for the wiring engineer.
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.