The Home Inspection Checklist Template That Survived 1,200 Inspections (and Counting)
A working home inspection checklist template in Google Sheets — with photo tracking, report management, and a system that doesn't fall apart after 50 properties.
Last Tuesday I pulled into a driveway in Pflugerville, opened my laptop to write up the inspection, and realized the photos from the attic were sitting in my phone's camera roll, the client's contract was somewhere in Gmail, and the previous inspector's notes from the recall were in a PDF I downloaded three weeks ago but never filed. The buyer's agent was texting me asking for the report. I had done everything right inside the house — and still felt like I was drowning in my truck.
That was the day that finally broke me on my old system. I'd been duct-taping together a mix of inspection software exports, Google Drive folders named things like 'Smith - maybe Elm St?', and a master spreadsheet that had about 400 rows and zero attached files. Sound familiar? If you're an inspector running more than a handful of jobs a week, the inspection itself isn't the hard part. The hard part is everything that happens to the paperwork after you leave the property.
This post walks through the home inspection checklist template system I built in Google Sheets — one that actually keeps reports, photos, and client info attached to each inspection row. It's not a replacement for your report-writing software (I still use Spectora for the actual report). It's the layer on top that tracks every job, every file, and every dollar so nothing gets lost between the crawlspace and the closing table.
Why Most Home Inspection Report Templates Break After 50 Jobs
I've downloaded every free home inspection report template I could find. The problem isn't that they're bad — it's that they're designed for one inspection at a time. You fill in the address, check some boxes, save it as a PDF, and move on. That works great on day one. By month three, you have 60 PDFs scattered across three folders and no way to quickly pull up 'that inspection on Burnet Road where the HVAC was undersized.'
What inspectors actually need isn't a single report template — it's a tracking system that holds every inspection in one view with the report, photos, agreement, and invoice linked to each row. Think of it less like a form and more like a database. One row per inspection. Every file that matters, attached right there.
The other thing that kills most templates: they don't account for the workflow around the inspection. Who ordered it? Has the agent been sent the report? Did the client pay? Is there a re-inspection scheduled? Those questions eat more of my time than actually crawling under a pier-and-beam foundation. A checklist template that ignores them is just a prettier version of a sticky note.
The Core Spreadsheet: One Row Per Inspection, Everything Attached
Here's the basic structure I use. Each row is one inspection. The columns cover the full lifecycle of a job, not just the property details. I'll walk through the column groups and then show you the template I built off this structure.
- **Inspection ID** — I use a simple format: year-month-sequential number (2025-06-047). This makes sorting and searching dead simple.
- **Date / Time** — Scheduled inspection date plus start time. I use data validation to keep the format consistent.
- **Property Address** — Full street address. I keep city and zip in separate columns so I can filter by area when I'm routing my week.
- **Client Name / Email / Phone** — The buyer, not the agent. Agent gets their own column.
- **Ordering Agent** — Name, brokerage, phone. This is who's going to call you at 7 PM asking for the report.
- **Inspection Type** — Dropdown: Buyer, Seller Pre-Listing, New Construction, 11-Month Warranty, Re-Inspection, Commercial, WDI Only.
- **Status** — Dropdown: Scheduled → In Progress → Report Writing → Delivered → Paid → Closed. This is the column that runs my entire workflow.
- **Fee / Payment Status** — What I quoted, what I've collected, and whether the invoice is outstanding.
- **Report PDF** — The actual report file, attached to the row.
- **Photos** — Key photos (foundation cracks, HVAC data plates, panel close-ups) attached directly to the row.
- **Inspection Agreement** — Signed pre-inspection agreement, attached.
- **Invoice** — Sent invoice PDF or link.
- **Notes** — Free text. 'Seller was present and hostile' is a real entry in my sheet.
The magic isn't in any one column — it's in having all of them on the same row. When an agent calls me four months later asking about the water heater at 1205 Elm, I filter by address, click the row, and I'm looking at the report, the photos, and my notes in under ten seconds. No digging through Drive. No searching Gmail.
Attaching Reports and Photos Without Losing Your Mind
This is where most Google Sheets setups fall apart for inspectors. You can paste a Google Drive link into a cell, sure. But after 200 inspections, you've got 200 links pointing to files that may or may not still be in the folder you think they're in. Someone renames a folder, someone moves a file, and suddenly half your links are dead.
I use FileFox to drag report PDFs and key photos directly into the cells on each row. The files live in the spreadsheet context — I don't have to maintain a parallel folder structure in Drive and hope the two stay in sync. When I finish writing a report in Spectora, I export the PDF and drop it straight into the Report column for that row. Same with the signed inspection agreement and any reference photos I want to keep handy.
The other file that's worth attaching: the signed pre-inspection agreement. If you've ever had a client dispute a limitation of your inspection, you know why. Having that signed PIA one click away — not buried in a DocuSign archive — has saved me real stress at least three times this year.
A Sample Home Inspection Checklist That Actually Tracks the Business
Most sample home inspection checklists you find online are property checklists — roof, electrical, plumbing, HVAC, foundation, etc. Those are useful inside the inspection, but your report software already handles that. What's missing is the business checklist: the tasks around each inspection that determine whether you get paid, whether the agent refers you again, and whether you have a liability gap.
I keep a separate tab called 'Job Checklist' that I duplicate for each week. It has a row for every scheduled inspection and columns for each task that needs to happen before, during, and after:
- **Pre-Inspection:** Agreement signed? Lockbox code confirmed? Utilities on? Agent contact confirmed?
- **Day-Of:** Photos backed up? Report started in software? Client walked through findings?
- **Post-Inspection:** Report delivered within 24 hours? Invoice sent? Agent thanked? (Yes, I track this. Referrals are the business.)
- **Follow-Up:** Payment received? Re-inspection needed? Review requested from client?
Each of those gets a simple checkbox (Insert → Checkbox in Google Sheets). At a glance, I can see which inspections from this week still have open items. The status column on my main tracker tab only moves to 'Closed' when every checkbox is done. That one rule has eliminated more dropped balls than any app I've tried.
The Status Column That Runs Your Inspection Pipeline
I stole this idea from a contractor friend who runs his plumbing business out of Google Sheets (we're both too stubborn for CRMs). The status column is the single most important column in the spreadsheet. It turns a static list of inspections into a live pipeline.
Here's my dropdown sequence: **Scheduled → In Progress → Report Writing → Delivered → Paid → Closed**. I use conditional formatting so each status gets a color — blue for Scheduled, yellow for Report Writing, orange for Delivered (meaning the agent has it but I haven't been paid), green for Paid, gray for Closed.
The orange rows are the ones that matter most. 'Delivered but not Paid' is where money dies in this business. I filter for orange every Friday afternoon and send follow-up invoices. Before I had this system, I was losing $200–$400 a month in inspections I simply forgot to collect on. At $400/inspection average, that's one free inspection a month I was donating to the universe.
Those two formulas live at the top of my sheet. When that SUMIF number crosses $1,500, I stop what I'm doing and send invoices. It's a simple trigger, but it works better than any reminder app I've tried because the number is always staring at me.
Routing, Scheduling, and Not Double-Booking Yourself
Here's something the software guys never think about: inspectors drive. A lot. I cover a 60-mile radius around Austin, and if I'm not careful I'll book a 9 AM in Round Rock and a 1 PM in San Marcos with no way to make both without breaking several traffic laws.
I added a 'Zone' column to my tracker — just a simple dropdown with the areas I cover (North, South, East, West, Central). When I'm looking at tomorrow's schedule, I sort by Zone first. If I see a North and a South on the same morning, I know I need to move something. It's not GPS routing software, but it's caught conflicts that my calendar alone would have missed.
I also keep a 'Drive Time Buffer' note in my scheduling tab: 'Never book inspections less than 2 hours apart unless same zip code.' That rule is taped to the bottom of my monitor. My wife — who handles most of the scheduling — has it memorized. The spreadsheet enforces it with conditional formatting: if two inspections on the same date are in different zones and less than 2 hours apart, the cells turn red.
Handling Re-Inspections and Recall Items Without a Separate System
Re-inspections are the loose thread that unravels most inspectors' filing systems. The original inspection is in one row. The re-inspection is... where? A new row? The same row with a note? A different tab?
I use the same row. When a re-inspection is requested, I add 'Re-Inspect' to the status dropdown, change the status, and add a 'Re-Inspection Date' in a dedicated column. The re-inspection report PDF gets attached alongside the original — so now that row has two reports, and I can see the full history without flipping between tabs or folders.
For recall items (when a manufacturer issues a recall on an appliance I flagged), I keep a simple 'Recall Flag' checkbox column. If I get a recall notice that applies to something I've inspected, I can filter for that appliance type and check which past clients might be affected. This has come up twice in three years, and both times I looked like a hero for proactively notifying the buyer's agent.
What This System Doesn't Replace (and Shouldn't Try To)
Let me be honest about what stays outside the spreadsheet. Your actual inspection report — the one that goes to the client — should still live in purpose-built software. Spectora, HomeGauge, InspectIT, whatever you use. Those tools generate narratives, handle photo annotations, and produce client-facing PDFs that no spreadsheet can replicate. Don't try to build your report in Google Sheets. That way lies madness.
What the spreadsheet does is give you the 30,000-foot view your report software can't. It answers questions like: How many inspections did I do last quarter? What's my average fee? Which agents send me the most work? How much money is outstanding right now? How fast am I delivering reports? Your report software knows what's wrong with the house. Your spreadsheet knows what's happening with your business.
Start Here: The One Thing to Set Up Today
If you're reading this in your truck between inspections (I know you are), here's what I'd do first: open a new Google Sheet, create the columns from the list above, and enter your last five inspections. Just five. Attach the report PDFs if you have them handy. Set up the status dropdown. Add conditional formatting for 'Delivered' rows in orange.
That's it for today. Don't try to build the whole system in one sitting — you'll burn out and abandon it. Five rows, status column, attached reports. Once you see how fast you can pull up a past inspection with everything right there, you'll want to backfill the rest. The template below will save you the setup time, but honestly, even a blank sheet with the right columns beats the chaos most of us are working with.
The crawlspace will always be there. The foundation crack isn't going anywhere. But the $400 invoice you forgot to follow up on? That one's got a shelf life. Fix the system, and the inspections take care of themselves.
Frequently Asked Questions
Is there a home inspection report template free for Google Sheets?
Yes. The FileFox home inspection template is free and set up specifically for tracking inspections, attaching report PDFs and photos, and managing payment status. It won't replace your report-writing software (Spectora, HomeGauge, etc.), but it handles the business tracking layer those tools miss.
What should a sample home inspection checklist include?
A property-level checklist covers roof, electrical, plumbing, HVAC, foundation, exterior, interior, and appliances — but your report software already handles that. The checklist most inspectors are missing is the business checklist: agreement signed, utilities confirmed, report delivered, invoice sent, payment collected, and review requested. Tracking those tasks per inspection prevents dropped revenue and missed follow-ups.
How do I organize home inspection photos in Google Sheets?
Don't try to put every photo in your spreadsheet — keep 3–5 key reference photos per inspection (data plates, major defects, exterior shot) attached to the row using a tool like FileFox. Store the full photo set in your report software or a Google Drive folder. The spreadsheet photos are for quick reference when an agent calls six months later, not for complete documentation.
Can I use Google Sheets as a home inspection list template for scheduling?
Absolutely. Add columns for date, time, property address, zone, and inspection type. Use conditional formatting to flag scheduling conflicts — for example, two inspections in different zones with less than two hours between them. It's not as fancy as dedicated scheduling software, but it's free, flexible, and you can see your whole week in one view.
How do I track unpaid home inspection invoices in a spreadsheet?
Use a status column with a 'Delivered' stage that means 'report sent, payment not yet received.' Apply orange conditional formatting to those rows so they stand out. Add a SUMIF formula at the top of your sheet to total the dollar amount of all unpaid inspections. Check that number every Friday and send follow-ups for anything over 7 days old.