Property maintenance spreadsheet template. Free, and ready to become an app.
One workbook for the people who keep buildings running: properties with their manager and unit count, maintenance requests with a category, priority and description, work orders that assign a request to a technician with a start and due date, the maintenance team and their availability, a notification log, a report log and a small dashboard. Download it free. When tenants should submit requests themselves, technicians should see only their own jobs and a finished job should close the request, describe that structure to Tadabase AI and it builds the maintenance app.
Excel · Google Sheets · Numbers · 7 sheets
Rather have it as an app? Describe it — we’ll build it now.
Same structure as the spreadsheet, plus logins, roles and workflows. Free to start.
7 sheets, already linked by ID.
Each sheet is one kind of record. The ID columns are how the sheets point at each other, and they are the same links the app version turns into real relationships.
-
Properties
Each building with its address, the manager responsible, the total number of units and a status (Active or Inactive).
Property ID · Property Name · Address · Manager · Total Units · Status
-
Maintenance Requests
Every request with the property and unit, who reported it, a category (Plumbing, Electrical), a priority (High, Medium or Low), the description, the date it came in and a status (Pending or In Progress).
Request ID · Property ID · Unit · Submitted By · Category · Priority · Description · Date Submitted · Status
-
Work Orders
The job that answers a request: which request it belongs to, who it is assigned to, the start date, the due date, a status (Pending or In Progress) and notes such as "parts ordered".
Work Order ID · Request ID · Assigned To · Start Date · Due Date · Status · Notes
-
Team Members
Technicians and contractors with their role, email, phone and whether they are available.
Team Member ID · Name · Role · Email · Phone · Availability
-
Notifications
A log of the updates that went out: a work order update to the tenant, a task assignment to a technician, with the message and the date sent.
Notification ID · Type · Recipient · Message · Date Sent
-
Reports
A record of the summaries you produce, such as work orders completed this month or team performance, with who produced each one and when.
Report ID · Type · Generated By · Generated On · Details
-
Dashboard
Three headline numbers: total properties, open maintenance requests and work orders completed this month, each with a one-line description.
Metric · Value · Description
Fine for one person. Hard for a team.
Where the spreadsheet starts to cost you time once more people depend on it.
-
Nothing is counted, so the dashboard is a guess
The file has no formulas. The Dashboard's 10 properties, 25 open requests and 100 completed work orders are typed numbers (the sample has two rows on each sheet), so every new request and every finished job means someone updating the dashboard by hand, and nothing shows how long a request has been open.
-
A job can never be marked done
The status dropdowns offer only Pending or In Progress, on both requests and work orders, and they cover only the two sample rows: rows you add below accept any text. There is no Completed value, even though the Dashboard counts completed work orders. A work order points to its request by a typed ID, so closing one does not touch the other, and nothing flags a work order whose due date has passed.
-
Tenants cannot report, and nobody is told
A request reaches the sheet only when someone in the office types in the call or the email. The Notifications sheet records updates after someone has sent them by hand; the file itself sends nothing. And sharing the file shares every tenant's name and every technician's phone and email with everyone who opens it, so a technician cannot be given only their own jobs.
Same structure, with logins and automations.
Start from a real prompt, change anything that doesn’t fit, then build it.
Loads this prompt into the prompt box- Property maintenance app A property maintenance app for a small property management company. Properties have an address, a manager and units. Maintenance requests have a property, a unit, a category (plumbing, electrical, HVAC, appliance, other), a priority (high, medium, low), a description, photos and a status (new, scheduled, in progress, completed). A manager turns a request into a work order assigned to a technician, with a start date and a due date. Technicians see only the work orders assigned to them and mark them completed with notes; completing the work order completes its request. Each morning the manager gets an email listing work orders past their due date. Show a dashboard that counts open requests by priority, work orders completed this month and the average days from request to completion, from the data.
- Tenant maintenance request portal A maintenance request portal for tenants — tenants log in and submit a request for their own unit with a category, a description and photos, then see only their own requests and each one's status; the property manager reviews new requests, sets the priority and assigns a technician; and the tenant gets an email when their request is scheduled and again when it is completed.
- Preventive maintenance schedule A preventive maintenance schedule for a portfolio of buildings — each property has recurring tasks (replace HVAC filters, test smoke detectors, service the boiler, clean gutters) with how often each repeats in days and the date it was last done; a scheduled workflow creates a work order for the assigned technician when a task comes due; completing the work order records the date and sets the next due date; and the manager sees a calendar of upcoming tasks and a list of overdue ones.
Starting from Property maintenance app
Opens the builder with your prompt. Free for 14 days, no card needed.
Questions about this template.
Is the spreadsheet template really free?
Yes. It is a normal .xlsx file that opens in Excel, Google Sheets or Numbers. No sign-up is needed to download it.
Does it work as a property maintenance template in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets, or use File, then Import, in a blank sheet. Every sheet comes across with its columns and sample rows.
Can tenants submit maintenance requests themselves?
Not in the spreadsheet: someone has to type each request in. In the app, yes: the AI sets up a tenant role that can submit requests with photos for their own unit and see only their own requests, and a technician role that sees only the work orders assigned to them. That rule is enforced on the server for every record, not by hiding rows.
How is this different from the property management spreadsheet?
The property management template is about leasing: units, tenants, lease applications and lease end dates, with a simple work order list. This one is about the maintenance itself: requests with a priority, work orders with a technician and a due date, and the maintenance team.
Can I bring the data I already have in the spreadsheet?
Yes. Once the app is built, import each sheet into the matching table from a CSV or Excel file. The importer maps your columns to the fields and shows any row it could not bring in, and why.
When should I move from the spreadsheet to an app?
When more than one person edits it, when someone outside your team needs to see part of it, or when you start copying rows between tabs by hand. Those are the points where a spreadsheet starts losing data quietly.
Keep the structure. Lose the copy-paste.
Describe the app the spreadsheet was trying to be. Tadabase AI builds it with real logins, roles and workflows, and you can try it free for 14 days.
- 14-day free trial, no card
- Unlimited app users
- Live on your own domain