# Equipment Inspection Log Template Excel

> A free Excel equipment inspection log: register assets, keep checklists per type, log inspections, spot overdue ones, track downtime and MTBF.

Source: https://softwiro.com/templates/equipment-inspection-log
Language: English
Softwiro, softwiro.com

---

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.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-equipment-inspection-log.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-equipment-inspection-log-blank.xlsx)

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

| As of | 46346 | Period start | 46296 |  |  |
| --- | --- | --- | --- | --- | --- |
| Assets registered | 11 |  |  | Breakdowns in the period | 10 |
| Inspections overdue | 3 |  |  | Downtime hours | 87.0 |
| Inspections due soon | 5 |  |  | Availability (all assets) | 99.0% |
| Inspections OK | 3 |  |  | MTBF (hours) | 888.9 |
| High-criticality assets overdue | 1 |  |  | MTTR (hours per breakdown) | 8.7 |
| Inspections in the period | 17 |  |  | Repair cost in the period | 5,940.00 |
| Failed inspections in the period | 7 |  |  | Top cause (hours lost) | Electrical fault |
| Inspection pass rate | 58.8% |  |  | Scheduled hours per asset | 816 |
| Inspection status | Assets |  |  |  |  |
| OK | 3 |  |  |  |  |
| Due soon | 5 |  |  |  |  |
| Overdue | 3 |  |  |  |  |
| Month | Breakdowns | Hours lost | Repair cost |  |  |
| Jun 2026 | 0 | 0.0 | 0.00 |  |  |
| Jul 2026 | 0 | 0.0 | 0.00 |  |  |
| Aug 2026 | 0 | 0.0 | 0.00 |  |  |
| Sep 2026 | 1 | 6.0 | 500.00 |  |  |
| Oct 2026 | 5 | 35.5 | 3,095.00 |  |  |
| Nov 2026 | 5 | 51.5 | 2,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](https://softwiro.com/templates/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.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-equipment-inspection-log.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-equipment-inspection-log-blank.xlsx)

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 sheet | In 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](https://softwiro.com/product/meswiro) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person updates | Every inspector and technician logs their own work with a login |
| You type each breakdown after the fact | Stops are captured on the line, with the reason chosen by the operator |
| An overdue list you open yourself | Reminders and escalation when an inspection is missed |
| Checklists in a sheet | Checklists per machine, with photos and sign-off |
| Charts inside the workbook | A live dashboard for the plant manager |

### Extra features in the app

- Inspectors complete the checklist on a phone or tablet, with photos of defects
- Reminders sent to the right person before an inspection is due
- A work order opened automatically when an item fails
- Downtime captured from the machine itself instead of typed in afterwards
- Spare parts and technician time linked to each repair
- Reports by line, area, shift or month without building formulas

[Ask for your custom system](https://softwiro.com/contact)

## 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](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](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

All the templates in this group: [Factory management sheets: production, cost and quality](https://softwiro.com/templates/for-factories)

More free templates for: Factories and production

## More free templates

- Production Tracking Spreadsheet for Excel
- Coffee Roasting Log and Costing Spreadsheet for Excel
- Electronics factory sheet: BOM, production and quality
- Food factory sheet in Excel: recipes, batches, cost and shelf life
- Biscuit factory sheet: dough, lines, packing and scrap
- Detergent factory sheet: formulas, batches, cost and filling
- Detergent ingredients and their names: function, chemical name and use
- Pharma factory sheet: batch records, materials, QC and release
- Industrial waste management sheet: quantities, classification, recycling and cost
- Hotel Guest Folio Template for Excel (Rooms, Reservations, Billing)
- Auto Parts Inventory and Sales Spreadsheet for Excel
- Clothing Store Inventory Spreadsheet (Size and Color) for Excel
- Multi-Location Inventory Spreadsheet for Excel
- Quran Hifz Tracker Template for Excel (Sabaq, Sabqi, Manzil)
- Rotating Savings Club Tracker for Excel (Susu, Tanda, ROSCA)
- College Application Tracker Spreadsheet for Excel (Deadlines, Checklist, Aid)
- Weighted Grade Calculator for Excel (Gradebook with Categories)

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
