How to Track Leasing Leads in a Spreadsheet

Leasing offices lose leads in sticky notes and inbox threads — then wonder why Zillow spend feels high and occupancy still dips. A free leasing lead tracker spreadsheet tracks prospects, source, stage, desired unit, and move date from first contact to signed lease.

Pipeline stages that match your desk

1. New lead — inquiry received
2. Contacted — responded, tour offered
3. Toured — visited property
4. Application — paperwork in progress
5. Approved / declined / lost

Filter toured but not applied weekly — that bucket is where follow-up wins leases before competitors reply faster.

Source column justifies marketing spend

Tag every lead Zillow, walk-in, referral, social — count conversions by source monthly. Cut spend on channels that generate tours that never apply.

Hand off to availability and renewals

Before touring, confirm the unit is truly vacant on the availability board. Approved applicants should align with units coming off renewal notice — double-booking a “maybe available” unit wastes everyone’s time.

Score applicants consistently with a screening scorecard once applications arrive.

When leasing CRM software wins

PMS-integrated lead routing, auto follow-up, and e-sign applications justify tools at high tour volume. Small offices often close faster with a shared lead sheet and same-day callbacks than with an unused CRM.

These templates are lead tracking tools, not fair housing compliance systems. Apply consistent screening criteria and follow applicable housing laws.