Skip to content
Maintenance Request Log cover: a sample sheet with requests logged, still open and urgent and open and a column chart, beside the Dashboard and Requests tabs

Maintenance Request Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Building managers, housing associations, schools and facilities teams that handle repairs in shared spaces can run their queue from this workbook. The Dashboard counts all requests, the jobs still open, the urgent jobs still open and average days to close, with breakdowns by location and by team. The Requests tab records the date reported, a reference, location, issue, priority, assigned team, state and closed date, and calculates the days each job has been open.

Give every request a reference number when you log it, so the person reporting the fault can quote it on a follow-up call. Reserve the Urgent priority for safety, water and power faults, since a list full of urgent items stops telling anyone what to do first. A Done job with its closed date keeps the average days to close honest, and urgent work that is still open turns red.

Useful for

  • Log repairs reported by tenants or staff
  • Show which team has the most jobs still waiting
  • Track how long urgent faults take to fix

What's included

  • 3 tabs: Dashboard, Requests, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Requests: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Requests tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How are the days open worked out?

For an open request, days open counts from the date reported until today, so the number grows each day you open the file. For a finished job it runs from the reported date to the closed date. Enter the closed date as soon as the work is signed off.

What changes when a new building or crew is added?

Put the new name in the Location or Assigned to dropdown on the Requests tab, using Data, then Data validation. Duplicate a line of the matching breakdown in the Dashboard, rename it, and the new name gets counted too.

Can this replace a dedicated facilities system?

It suits a small team working from one spreadsheet. Once you need photos, notifications, tenant log-ins or a large volume of requests each day, a dedicated facilities system is the better fit. Check your building's own policy before sharing tenant details.

  • #tracker
  • #maintenance-request-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…