Real estate lead follow-up sheet in Excel
One row per lead: source, what the buyer wants, one caller, the last outcome and the next call date. A lead not called or a missed follow-up turns red.
What the file looks like
The heading row and the five example rows, as they open in Excel. Under them the file has empty rows that are ready: the lists, the formulas and the colours are already set.
| Lead date | Name | Mobile | Source | Looking for | Budget | Caller | First call | Last outcome | Next follow-up | Calls made | Site visit | Days since lead | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16 Oct 2026 | Rohit Malhotra | 98xxx 41207 | Portal | 3 BHK, ready to move, near the metro | Up to 1.4 crore | Simran | 0 | fills itself | Lead came at 9 pm | ||||
| 11 Oct 2026 | Kavita Arora | 97xxx 20518 | Facebook or Instagram ad | 2 BHK, under construction is fine | Up to 85 lakh | Aman | 11 Oct 2026 | Call back | 15 Oct 2026 | 3 | fills itself | Wants to discuss with her husband | |
| 13 Oct 2026 | Neeraj Bansal | 99xxx 63014 | Reference | Plot or builder floor, east side | Up to 1.1 crore | Simran | 13 Oct 2026 | Site visit fixed | 17 Oct 2026 | 2 | 18 Oct 2026 | fills itself | Confirm the visit today, send the location pin |
| 5 Oct 2026 | Ankit Jain | 88xxx 57190 | Website | 3 BHK, park facing | Up to 1.6 crore | Aman | 5 Oct 2026 | Visited | 19 Oct 2026 | 5 | 14 Oct 2026 | fills itself | Liked tower B, asked for the payment plan |
| 27 Sept 2026 | Sunita Gupta | 96xxx 11842 | Walk-in | 2 BHK, ready to move | Up to 75 lakh | Simran | 27 Sept 2026 | Booked | 7 | 3 Oct 2026 | fills itself | Token paid, papers with the builder |
- Red row: A lead not called since an earlier day, or a follow-up date that has passed.
- Amber row: A new lead or a follow-up due today.
- Green row: Booked.
The columns, and what to write in each
- Lead date
The day the lead came in.
- Name
The buyer, as they gave it.
- Mobile
The number to call.
- Source
Where the lead came from. Pick from the list, so that sources can be counted.
PortalFacebook or Instagram adWebsiteReferenceWalk-inHoarding or bannerOther - Looking for
Type, size, area, ready or under construction, in the buyer's words.
- Budget
The budget the buyer said.
- Caller
One name. Two callers on one lead means none.
- First call
The day of the first call. Empty means not called yet.
- Last outcome
What happened on the last call. Pick from the list.
Not answeredCall backInterestedSite visit fixedVisitedNegotiatingBookedNot interestedWrong number - Next follow-up
The day of the next call. Never empty for an open lead.
- Calls made
Add 1 after every call, answered or not.
- Site visit
The day of the site visit, once fixed.
- Days since lead
Fills itself: days since the lead came in.
- Notes
What the buyer said last, in one line.
How to keep it
- Every new lead gets a row the moment it comes, with its source and one caller. The first call is due the same day.
- After every call, the caller sets the outcome from the list, adds 1 to "Calls made" and writes the next follow-up date. A lead without a next date is a lead dropped.
- When a site visit is fixed, write its date. The call after the visit is the one most often missed.
- Morning: each caller filters by their name and calls the red rows first, then the amber ones, using the scripts on the second sheet.
- Evening: the team leader counts red rows by caller. Leads closed as "Not interested" stay in the sheet for a later campaign.
Also in the file: call scripts
Hello (name), this is (your name) from (firm). You asked about (what they asked for) on (source). Is this a good time for two minutes? ... Are you looking to buy for yourself, or as an investment? ... Which area works for you, and by when do you want to move? ... I will send you two options that fit on WhatsApp now. When can I call you to hear what you think?
Hello (name), this is (your name) from (firm). I called about the (type) you asked for in (area). When is a good time to call you? You can also reply here.
Hello (name), a reminder of your visit to (project) tomorrow at (time). Here is the location pin. (Caller name) will meet you at the gate. Please tell me if the time changes.
Hello (name), thank you for visiting (project) today. You liked (what they liked). I am sending the payment plan and the floor plan of (unit). When can we speak tomorrow to answer your questions?
Fix the day before you end the call: "Shall I call you on (day) at (time)?" Write that date in "Next follow-up" before you dial the next lead.
Free to use and to change. No macros, nothing to install.
Lead follow-up script for property callers
A lead follow-up script for property callers: the first call, the call after no answer, before and after a site visit, and a call sheet in Excel to keep dates.
People also look for this as: real estate lead follow-up sheet in Excel · property lead follow-up script · telecaller script for real estate · real estate call sheet format
