Excel workbook (.xlsx)
Instrument Index & I/O List – Excel Template (ISA Tag List, Tag Validation, I/O Count & Spare Capacity)
A clean, ISA-style instrument index that checks every tag as you type, plus an I/O summary with used, installed and spare channels per controller and card. No macros.

Description
One tag list. Every tag checked. This Excel template gives you a 1,000-row instrument index in the familiar ISA layout and an I/O summary that answers the question every client asks: *how much spare I/O do we have?*
Built by an independent instrumentation engineer who works with HART, DCS and SIS projects in the field.
What it does for you
- ISA-style index: tag, service, P&ID, instrument type, range and units, signal, I/O type, controller / card / channel, junction box, cable, location, vendor, model and remarks.
- Tag check on every row: LETTERS-NUMBER format with an optional suffix letter (PT-1001, LSHH-1102, FV-2105A). It flags missing separators, lower case, unknown letter codes (checked against an editable list of 85+ ISA codes), the wrong number of loop digits (set your own min / max) and duplicate tags.
- Channel check: flags a controller + card + channel that is used twice.
- I/O summary per controller: AI / AO / DI / DO used, installed and spare %, coloured against your spare target (default 20 %).
- Card table: used and spare channels per card, status OK / Below target / OVER-ALLOCATED, and a count of tags with the wrong I/O type on a card.
- Counts per signal type: 4-20 mA HART, NAMUR, 24 V DC, FOUNDATION Fieldbus, PROFIBUS PA and more.
- Dropdowns for instrument type, signal, I/O type and units. Frozen headers, filters, print areas (A4 landscape) and protected formulas (no password) are all set.
What's included
Instrument_Index_and_IO_List.xlsxwith:
- Instructions - Instrument Index and IO Summary: blank, ready to use - EXAMPLE Index and EXAMPLE IO Summary: a 44-tag sample project with three controllers (PLC, DCS, SIS). It includes deliberate errors so you can see the checks work. - Lists: editable dropdowns and ISA letter codes
Example_Instrument_Index_PREVIEW.pdf
Who it's for
- Instrument and control engineers on projects and revamps
- System integrators preparing I/O lists and cabinet I/O counts
- E&I contractors and maintenance engineers keeping the plant's instrument index up to date
- Students learning ISA-5.1 tagging
Compatibility
- Microsoft Excel 2016, 2019, 2021, Microsoft 365 (Windows / Mac)
- LibreOffice Calc 7+
- Google Sheets: data entry works, but protection is not imported
- No macros, no add-ins.
Licence
Single user / single company. Use and edit it for your own projects and customers. Reselling or redistributing the template is not allowed.
*The tag check is a format check based on common ISA-5.1 practice. It does not replace your project's tagging procedure.*
---
More in Excel templates
- Instrument Calibration Certificate & Log – Excel Template (4-20 mA / HART, As-Found / As-Left)
- Loop Check & Commissioning Pack – Excel Template (AI / AO Control Valve / DI / DO Loop Sheets, Punch List, Progress Dashboard)
- Instrument Datasheet Templates – Excel (Pressure, DP Flow, Temperature, Level, Control Valve, On/Off Valve)