Free templatesTest and tag register
Free template · CSV for Excel or Google Sheets
Test and tag register template
A test and tag register records every electrical item you inspected and tested: what it is, where it is, who tested it, the result and when it is due again.
The columns
- Asset ID
- The number on the tag.
- Description
- Make, model and type of item.
- Site
- Client or site name.
- Location
- Where on site the item lives.
- Test date
- Date of this inspection and test.
- Tester
- Name of the person who tested it.
- Visual
- Visual inspection pass or fail.
- Earth (ohm)
- Earth continuity reading, where applicable.
- Insulation (Mohm)
- Insulation resistance reading.
- RCD trip (ms)
- Trip time, for RCDs.
- Result
- Pass, fail or out of service.
- Next due
- Retest date written on the tag.
- Action
- What happened to a failed item.
Example rows
Sample data, included in the download so you can see the format. Delete these rows and add your own.
| Asset ID | Description | Site | Location | Test date | Tester | Visual | Earth (ohm) | Insulation (Mohm) | RCD trip (ms) | Result | Next due | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TT-0001 | Makita 18V charger | Example Builders | Site shed | 2026-11-03 | A. Tester | Pass | 0.12 | >200 | Pass | 2027-02-03 | ||
| TT-0002 | Extension lead 15m | Example Builders | Level 2 | 2026-11-03 | A. Tester | Fail | Fail | Tagged out, removed from site |
Using it well
- Set the next due date from the environment the item is used in. Check the current edition of AS/NZS 3760 for the intervals that apply.
- Keep failed items in the register with the action taken, so the history shows why an item left the site.
- One register per client makes the report easy to send to the site manager.
Outgrowing the spreadsheet?
Taskr's test and tag workflow records results against each item on the client's site from the phone, keeps next-due dates, and sends the report from the job. Import this spreadsheet to start.
Paperwork and compliance: how Taskr helpsFAQ
Frequently asked questions
Can I use this register in Excel or Google Sheets?
Yes. The download is a CSV file, which opens in Excel, Google Sheets and Numbers.
How often do items need retesting?
It depends on the environment the item is used in. AS/NZS 3760 sets the intervals, and some workplaces have stricter rules from their state regulator.