Real Estate & Landlords
Property Comparison Spreadsheet
Compare price, condition, estimated return and key details across multiple listings side by side.
- Delivery
- Instant download
- Purchase
- One-time payment
- Format
- Google Sheets
- Excel
- Updated
- August 2026
Best on your weights
77 Cedar Row
Cheapest listing ranks
4th
- 1 — 77 Cedar Row0.95
- 2 — 48 Oak Ave0.87
- 3 — 123 Maple St0.86
- 6 — 5 Willow Gate0.0 — ruled out
Sample data preview of the Property Comparison Spreadsheet spreadsheet, shown for illustration only.
What this spreadsheet does
After touring several properties, details from each listing blur together without a consistent way to compare them.
What you can do with it
- Compare listings after a weekend of viewings
- Rank properties by estimated return
- Keep notes on condition and concerns per property
What's included
Sheet tabs
- Instructions
- Scoring
- Comparison Grid
- Viewing Notes
Features
- Comparison grid with gross yield, price per sq ft and monthly cashflow worked out for you
- A weighted score across yield, price per sq ft, condition and location — weights you set
- Automatic ranking, so changing a weight re-orders the shortlist
- Ruled-out properties kept on the sheet, scored zero, as the record of what you compared against
- A property with no rent estimate still scores on everything else
- Viewing notes per property: what was good, what was wrong, what to follow up
How it works
- 1Enter each property's price, size, and your condition and location marks out of five
- 2Set your four weights on the Scoring tab — they must total 100%
- 3Read the ranked shortlist, and mark anything gone as Ruled out rather than deleting it
Who it's for
Buyers and investors comparing multiple properties before making an offer.
Frequently asked questions
How many properties can I compare?
The grid ships with room for twelve. Add rows inside the block and the scoring and ranking pick them up.
Does it calculate return automatically?
Gross yield, price per square foot and monthly cashflow before finance, yes. It deliberately stops there — mortgage, amortisation and tax belong to the Rental Property ROI Calculator, and having two workbooks model the same finance is how they end up disagreeing.
How does the score work?
You set four weights — yield, price per sq ft, condition, location — and they must total 100%. Yield and your marks score higher when larger; price per square foot scores higher when smaller, so it's inverted. Each part is worked out separately, so a property with no rent estimate yet loses its yield points and keeps the rest.
Complete the setup
The rest of the tools this one was built to sit beside.
Rental Property ROI Calculator
Enter price, rent and costs to see cap rate and cash-on-cash return.
- Google Sheets
- Excel
Rental Property Income & Expense Tracker
Log rent collected and expenses paid across your properties.
- Google Sheets
- Excel
Landlord Maintenance Tracker
Log repair requests, status and cost for every unit.
- Google Sheets
- Excel
Similar tools
The same kind of tool, for a different job.