A Free Rental Maintenance Spreadsheet Template

If you are starting out, a spreadsheet is the fastest way to get your repairs under control. Here are the exact columns to use, a layout you can copy in a couple of minutes, and the honest limits to keep in mind.

The columns that actually matter

Most maintenance spreadsheets fail because they track too little ("issue" and "done?") or too much (twenty columns nobody fills in). These are the ones that earn their place:

• Date reported — when the tenant first raised it.
• Property / unit — so you can filter by building later.
• Issue — a short, specific description.
• Priority — urgent, high, medium, low.
• Status — new, in progress, waiting on vendor, resolved.
• Assigned to — you, a manager, or a vendor.
• Cost — the actual amount once the job is done.
• Date closed — for response-time and history.
• Notes — what was done, parts used, anything to remember.

Copy this layout

Open a new sheet and paste these as your header row:

Date Reported | Property | Unit | Issue | Priority | Status | Assigned To | Cost | Date Closed | Notes

A few small touches make it far more usable: turn the header row into a filter, use a drop-down (data validation) for Priority and Status so they stay consistent, and add conditional formatting to highlight anything marked Urgent. That is genuinely all most landlords need to get organized.

Where the spreadsheet stops keeping up

A sheet cannot collect requests from tenants, so you will still be re-typing texts. It cannot hold the photo of the damage. It does not remind anyone, and it gets messy the moment a second person edits it. None of that matters at five units with one decision-maker — but it starts to bite as you grow. We cover the trade-offs in detail in spreadsheet vs. app, and the full intake-to-close system in how to track maintenance requests.