Softwiro
Free Excel template

Equipment Inspection Log Template for Excel

A free Excel workbook for a plant, workshop or facilities team that wants one place for equipment inspections and breakdowns. You register each asset with a tag, type, area, criticality and how often it should be inspected. Every inspection you log moves that asset's next due date, and the status changes from OK to Due soon to Overdue on its own. A second log records breakdowns with start and end times, cause and repair cost, so the sheet can show hours lost, availability, mean time between failures (MTBF) and the causes that cost you the most. It opens in Excel, LibreOffice and Google Sheets.

Excel file (.xlsx) · 207 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
As of46346Period start46296
Assets registered11Breakdowns in the period10
Inspections overdue3Downtime hours87.0
Inspections due soon5Availability (all assets)99.0%
Inspections OK3MTBF (hours)888.9
High-criticality assets overdue1MTTR (hours per breakdown)8.7
Inspections in the period17Repair cost in the period5,940.00
Failed inspections in the period7Top cause (hours lost)Electrical fault
Inspection pass rate58.8%Scheduled hours per asset816
Inspection statusAssets
OK3
Due soon5
Overdue3
MonthBreakdownsHours lostRepair cost
Jun 202600.00.00
Jul 202600.00.00
Aug 202600.00.00
Sep 202616.0500.00
Oct 2026535.53,095.00
Nov 2026551.52,845.00

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: Asset count, how many inspections are overdue, due soon or OK, inspections and failures in the period, pass rate, breakdowns, downtime hours, availability, MTBF, MTTR, repair cost and the top cause. Four charts: inspection status, hours lost by cause, downtime hours by month and repair cost by month.
  • Overdue List: The assets that are overdue or due soon, most overdue first, with area, criticality, last inspection, next due date, days to due and last result. Shows up to 40 assets.
  • Equipment: The register: one row per asset with tag, name, type, area, install date, criticality and inspection interval in days. It calculates last inspection, last result, next due date, status, breakdowns, hours lost, repair cost, availability and MTBF for each asset. Room for 200 assets.
  • Inspections: The inspection log: date, asset tag, inspector, items passed, items failed and notes. It adds the asset name, type and result, and flags a count that does not match the checklist. Room for 1,000 inspections.
  • Breakdowns: The downtime log: start and end date and time, asset tag, cause category, repair cost and a note. Hours lost are calculated. Room for 500 breakdowns.
  • Checklists: One editable checklist per equipment type (up to 10 items each), with the item count for each type. The type names feed the Type dropdown on Equipment.
  • Lists: Criticality levels, breakdown cause categories and inspector names for the dropdowns.
  • Settings: Today's date, the due-soon window, the date the reporting period starts, scheduled hours per asset per day, currency symbol and site name.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

A paper checklist tells you what was checked; it does not tell you what is due next or what keeps stopping the line. This workbook ties the two together: the same asset tag links inspections, due dates and breakdowns, so you can see whether the assets that fail inspections are also the ones that break down. The sample is a small plant with 11 assets, 17 inspections and 11 breakdowns logged in autumn 2026.

How do I make an equipment inspection log in Excel?

Start with a register of your equipment: a unique asset tag, a name, the type, where it is, and how often it should be inspected. Then keep one row per inspection with the date, the tag, who did it and how many checklist items passed and failed. The next due date is the last inspection date plus the interval, so it moves forward each time you log an inspection.

Write a checklist for each type of equipment on the Checklists sheet and use it on your rounds. The Inspections sheet checks that passed and failed add up to the number of items on that checklist. In the sample, 17 inspections are logged and 7 of them had at least one failed item, a pass rate of 58.8%.

How do I track overdue equipment inspections?

Set the As of date and the due-soon window on Settings. Each asset is Overdue when its next due date is before the As of date, and Due soon when it falls inside the window. The Overdue List collects those assets with the most overdue first. In the sample, 3 assets are overdue, 5 are due soon and 3 are OK, and one of the overdue assets is a new compressor that has not had its first inspection yet.

The sheet cannot send a reminder by itself, so type today's date or enter =TODAY() in the As of cell and open the Overdue List at the start of each shift or week. Highest-criticality assets are counted separately on the Dashboard.

How do I calculate equipment availability and MTBF in a spreadsheet?

Log every stoppage with its start and end time. Availability is 1 minus the hours lost divided by the hours the asset was scheduled to run in the period. MTBF is the scheduled hours minus the hours lost, divided by the number of breakdowns. In the sample, 10 breakdowns in the period cost 87.0 hours, which gives availability of 99.0% across 11 assets, an MTBF of 888.9 hours and a mean time to repair of 8.7 hours.

These are simple measures to compare assets and months. Pick one reporting period and one number of scheduled hours per day, and keep using them. The top failure causes table ranks causes by hours lost: in the sample, electrical faults account for 40.0 of the 87.0 hours. For a related sheet, see the spare parts inventory.

How to use it

  1. On the Settings sheet type the As of date (today), the due-soon window in days, the date your reporting period starts, and the hours each asset is meant to run per day.
  2. On the Checklists sheet name your equipment types in the top row and list the items to check for each type. Edit them to match your own procedures.
  3. On the Equipment sheet add one row per asset: tag, name, type, area, install date, criticality and how often it is inspected (in days).
  4. On the Inspections sheet add a row each time an asset is inspected: date, asset tag, inspector, items passed, items failed and notes.
  5. On the Breakdowns sheet log every stoppage: start and end date and time, asset tag, cause category and repair cost. Hours lost are calculated.
  6. Equipment shows the last inspection, next due date and status (OK, Due soon, Overdue), availability and MTBF for each asset. Open Overdue List for what needs attention and Dashboard for totals and charts.

Before you start:

  • Capacity: 200 assets, 1,000 inspections and 500 breakdowns. The Overdue List shows the first 40 assets that are overdue or due soon.
  • Next due = last inspection date + the inspection interval in days. An asset with no inspection yet is due one interval after its install date.
  • Status: Overdue (next due date is before the As of date), Due soon (within the due-soon window), OK.
  • Reporting period: from the Period start date to the As of date. Scheduled hours per asset = days in the period x hours per day. Breakdowns that start inside the period are counted.
  • Availability = 1 - hours lost / scheduled hours. MTBF (mean time between failures) = (scheduled hours - hours lost) / number of breakdowns. MTTR = hours lost / breakdowns. They are simple measures: use them to compare assets and months, not as a formal reliability study.
  • Items passed and items failed should add up to the number of items on that type's checklist; the Check column on Inspections tells you when they do not. Follow your own safety rules and local requirements: this sheet only records what you enter.

Excel file (.xlsx) · 207 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet calculates requirements for the orders you type in yourself. In MESwiro, material requirements planning (MRP) breaks planned production orders down into their components and works out shortages against stock.

In this sheetIn MESwiro
You type in every order and every balance by hand.Material requirements planning (MRP) breaks planned production orders down into their components and calculates shortages against stock.
You ask suppliers for quotes by phone.It requests quotes from several suppliers and compares price, lead time and minimum order side by side.
Line scheduling in a sheet hides conflicts.It assigns work orders to lines and shifts by drag and drop, with a Gantt chart and a panel for unscheduled orders.
Efficiency and order cost are guesswork.It calculates OEE for each line automatically and shows the material, labor and machine cost of each order.

See MESwiro · Ask for a demo

Frequently asked questions

Is this equipment inspection log really free?

Yes. Download it, use it for your site and change anything you like. There is nothing to sign up for to open the file.

Can I change the checklists?

Yes. The Checklists sheet has one column per equipment type with up to 10 items each. Rename the types, replace the items and add your own. Follow your own safety rules and local requirements when you decide what to check and how often.

How many assets and inspections can it hold?

200 assets, 1,000 inspections and 500 breakdowns. The Overdue List shows the first 40 assets that need attention. As the number of assets and people entering data grows, a spreadsheet gets harder to keep accurate.

How is the next inspection date worked out?

From the last inspection logged for that asset plus the interval in days you set for it. An asset with no inspection yet is due one interval after its install date.

Does it work in Google Sheets and LibreOffice?

Yes. It uses only ordinary formulas such as SUMIFS, COUNTIFS, INDEX, MATCH and IF, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

All the templates in this group: Factory management sheets: production, cost and quality

More free templates for: Factories and production

More free templates

All templates · Free tools