Free template

Master gage list template

The master gage list is the register your quality system points to: every gage, instrument and standard you calibrate, one row each, with what it is, where it lives, who owns it and when it is due.

Download it as Excel or CSV. No email, no sign-up. It is the same template CalibrationOS offers inside the app, so it imports with every column mapped.

Download Excel (.xlsx) Download CSVFile names: calibrationos-gage-list-template.xlsx and calibrationos-gage-list-template.csv

Free. No email or sign-up needed to download.

Use it if

  • You are building the register for ISO 9001, AS9100 or IATF 16949 and want the usual columns from the start.
  • You are pulling gages from several sheets or a desk drawer into one list.
  • You are moving to calibration software and want a clean list to import.

What is in it

18 columns on the first sheet, 2 example rows to replace, and a How to use sheet in the Excel file.

ColumnWhat goes in it
Asset TagYour ID for the instrument, as written on its sticker.
DescriptionWhat it is, for example “Digital caliper”. The one column every row needs.
ManufacturerWho made it.
ModelModel or part number.
Serial NumberThe maker's serial number.
Categorydimensional, electrical, pressure, temperature, torque, optical, mass or force. Leave it blank and we work it out from the description.
StatusActive, Out for cal, Out of service, Retired or Lost.
Cal Interval (months)Months between calibrations, for example 12. Blank means 12.
Last Cal DateWhen it was last calibrated.
Next Cal DueWhen it is next due. Leave it blank and we work it out from the last calibration date plus the interval.
Cal Typeexternal (sent to a lab), in_house, or reference_only (no calibration needed).
Calibrated ByThe lab's name, or the person who calibrated it in house.
CustodianThe person responsible for it.
DepartmentThe department that owns it.
LocationWhere it lives: bench, cell, crib or room.
RangeIts measuring range, for example 0-150 mm.
ToleranceIts tolerance, for example ±0.02 mm.
NotesAnything else: the certificate number, the result as found, a reminder.

The example rows

Asset TagDescriptionManufacturerModelSerial NumberCategoryStatusCal Interval (months)Last Cal DateNext Cal DueCal TypeCalibrated ByCustodianDepartmentLocationRangeToleranceNotes
QA-0001Digital caliperMitutoyo500-196-30A12345678dimensionalActive122026-03-152027-03-15externalExample Calibration LabJ. RiveraQualityInspection bench 20-150 mm±0.02 mmExample row. Replace with your own instruments.
QA-0002Digital multimeterFluke87V98760012electricalActive122026-01-08externalExample Calibration LabMaintenanceMaintenanceTool crib0-1000 V±0.05 %Example row. Next Cal Due left blank: we work it out from Last Cal Date + interval.

How to use it

  1. Download the template

    Excel (.xlsx) or CSV. The Excel file explains each column on its How to use sheet.

  2. One row per gage

    Asset tag and description first. Add the maker, model and serial so the gage can be traced to its certificate.

  3. Add range and tolerance

    Write them as on the sticker, for example 0-150 mm and ±0.02 mm.

  4. Add ownership and dates

    Custodian, department, location, the last calibration date and the interval. Leave Next Cal Due blank to have it worked out.

  5. Import it into CalibrationOS

    Sign up free, open Import and choose the file. Every column maps on its own, you see each row and its due date before anything is saved, and reminders start from there.

Imports as it is

The column names are the ones the CalibrationOS importer reads. Upload the filled-in file and every column maps on its own: no renaming, no mapping to fix. Next Cal Due left blank is worked out from the last calibration date and the interval. You see every row and its due date before anything is saved.

Download Excel (.xlsx) Download CSVFile names: calibrationos-gage-list-template.xlsx and calibrationos-gage-list-template.csv

Questions

What is a master gage list?

The controlled register of every measuring instrument that needs calibration: its ID, description, serial number, range, tolerance, owner, location, interval and due date. Auditors use it to pick instruments to trace.

Which columns are required?

Only Description is needed for a row to import. The rest are what an auditor usually asks about, so fill in what you have.

Do I need to give my email to download it?

No. The download links on this page go straight to the file.

Will it import into CalibrationOS without changes?

Yes. It is the template the app itself offers, and every column maps automatically. Keep the header row as it is.

When the spreadsheet should remind you

Import your gage list and see what is due, past due and out for cal in one place, with reminders before each date. Free for 25 instruments, no card.

More free templates