Softwiro
Free Excel template

Real Estate Lead Tracking Spreadsheet (Excel)

A free Excel lead tracker for a solo agent or a small brokerage. Each lead is one row: name, phone, email, source, buyer, seller or renter, budget or asking price, areas of interest, the property they like and the stage they are at. Type the next follow-up date and the sheet flags what is overdue, lists who to call first, estimates your commission from a rate and split you set, and shows which lead sources actually close. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

Excel file (.xlsx) · 237 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Leads” tab, with the numbers and formulas that are in the file.
Lead IDNameSourceTypeBudget / priceStageWeighted valueYour commission
L-001Emily CarterReferralBuyer485,000.00Closed10,185.00
L-002Daniel BrooksOnline portalBuyer620,000.00Closed13,020.00
L-003Sofia RamirezOpen houseSeller750,000.00Closed15,750.00
L-004Grant HollowaySign callBuyer380,000.00Closed6,650.00
L-005Hannah LeeWebsiteRenter2,400.00Closed840.00
L-006Victor NashReferralBuyer540,000.00Lost
L-007Priya DesaiOnline portalBuyer450,000.00Lost
L-008Marcus WebbSocial mediaSeller690,000.00Lost
L-009Olivia GrantWebsiteBuyer300,000.00Lost
L-010Ethan ColeReferralBuyer575,000.00Under contract517,500.0012,075.00
L-011Nadia IbrahimOnline portalSeller810,000.00Under contract729,000.0017,010.00

Example from the “Leads” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: Open leads, open pipeline value, weighted pipeline value, deals closed and closed volume this year, your commission earned, expected commission on open leads, lead-to-close rate, overdue follow-ups, leads with no follow-up, new leads and showings this month. Four charts: pipeline value by stage, new leads and closed deals by month, leads and closed deals by source, and open leads by type. Tables below give the numbers by stage, month, source and lead type.
  • Leads: The tracker: one row per lead with source, type, budget or price, areas, property, stage, next follow-up and next step. It adds the status, closing chance, weighted value, commission, your share, expected commission, a follow-up flag (Overdue, Due soon or No follow-up) and the number of touches. Room for 1,000 leads.
  • Follow-ups: Open leads whose follow-up date is overdue or falls inside your window, earliest first, with phone, type, stage, budget, next step and days overdue. It is the call list for the day.
  • Activity: A log of calls, texts, emails, showings, meetings, offers and notes by lead ID. The Leads sheet counts the touches for each lead and the dashboard counts showings this month. Room for 1,500 entries.
  • Properties: The homes your leads are interested in or that you are selling: address, area, type, beds, status and list price, with the number of leads and open lead budgets attached to each. Room for 200 properties.
  • Lists: Your stages with a closing chance and a type (Open, Won or Lost), and your lead sources. They feed the dropdowns and the dashboard.
  • Settings: Business name, currency symbol, the as-of date, the report year, the follow-up window in days, your default commission rate and your split.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most free real estate lead sheets are a contact list with a status column. This one also tells you who to call today, what your open pipeline is worth after allowing for the stage it is at, what commission to expect from it, and which lead sources turn into closed deals. The sample is a small brokerage with leads added from September to November 2026, so every sheet shows real numbers before you replace them with yours.

What should a real estate lead tracking spreadsheet include?

At minimum: name, phone, email, where the lead came from, whether they are a buyer, a seller or a renter, a budget or asking price, the areas they care about, their stage and the date you next need to contact them. The sample has 24 leads across seven stages: New, Contacted, Showing booked, Offer, Under contract, Closed and Lost.

Two more columns pay for themselves: the property a lead is interested in, and a log of every call and showing. Both are here, so you can see how many people are chasing one listing and what was said last.

How do I track follow-ups on real estate leads?

Give every open lead a next follow-up date. The sheet compares it with the as-of date: before it is Overdue, inside the window you set is Due soon, and an open lead with no date is flagged as No follow-up. The Follow-ups sheet lists the first two groups, earliest first.

In the sample, on 2026-11-16 three leads are overdue, nine more are due within seven days and one open lead has no follow-up date. Set the as-of date to =TODAY() and the list updates each day.

How do I estimate real estate commission in Excel?

Multiply the price by your commission rate, then by your split. Set the default rate and split on the Settings sheet (the sample uses 3% and a 70% split), and type a rate override on any lead that is on different terms. Check your own agreements; the sheet only does the multiplication.

On the sample, the five closed leads add up to 2,237,400 of volume and 46,445 of commission to you. The 15 open leads are worth 7,233,950 in total, and after weighting each by the closing chance of its stage the expected commission is 53,032.

Which lead source is worth paying for?

The dashboard counts leads, closed deals and lost deals for each source on your list, with the lead-to-close rate and the commission each source produced. Many sources look busy in the lead column and fall away at closing, so read the last two columns before you spend more on one.

If your leads mostly come from paid ads, the lead quality tracker goes deeper on cost per lead. If several agents need to share one live list with reminders, see custom software.

How to use it

  1. On the Settings sheet type your business name, currency symbol, the as-of date (type =TODAY() to update it daily), the report year, the follow-up window in days, your default commission rate and your split.
  2. On the Lists sheet check the stages and their chance of closing, and add your lead sources. Add the homes you are showing on the Properties sheet.
  3. On the Leads sheet add one row per lead: name, phone, email, source, buyer, seller or renter, budget or price, areas, property, stage and the next follow-up date. Use the dropdowns for source, type, property and stage.
  4. Move the stage as the lead progresses. When a lead closes or is lost, type the closed date. For a deal with a different rate, type it in the rate override column.
  5. Log calls, texts, showings and notes on the Activity sheet with the lead ID.
  6. Open Follow-ups for the leads to call today and overdue, and Dashboard for pipeline value, commission, source results and charts.

Before you start:

  • Capacity: 1,000 leads, 1,500 activities, 200 properties, 8 stages and 10 lead sources.
  • Budget / price is the budget of a buyer or renter, or the asking price of a seller. Commission = that amount x the rate (the default on Settings, or the override on the lead). Your share = commission x your split.
  • For a renter, type the monthly rent and a rate override such as 50% if you earn half a month. Check your own commission arrangements; the sheet only multiplies.
  • Expected commission = your share on open leads x the closing chance of the stage. Edit the chances on the Lists sheet to match how your leads really close.
  • Follow-ups flags open leads whose follow-up date is past the as-of date (Overdue), inside the window (Due soon), or missing (No follow-up).
  • The source and stage charts show the first 6 sources and all stages on your lists. Use one currency in one workbook.

Excel file (.xlsx) · 237 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

Is this real estate lead tracking spreadsheet free?

Yes. Download it, use it for your business and change anything you like. There is nothing to sign up for to open the file.

Does it work in Google Sheets and LibreOffice?

Yes. It uses only ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

Can I change the stages and the commission rate?

Yes. Rename the stages and change their closing chance on the Lists sheet, and set the commission rate and your split on Settings. A single lead can carry its own rate in the override column.

Can I track renters and sellers as well as buyers?

Yes. Every lead has a type: buyer, seller or renter. For a renter, type the monthly rent as the amount and a rate override such as 50% if you earn half a month. The dashboard shows leads and open value by type.

How many leads can it hold?

1,000 leads, 1,500 logged activities and 200 properties. When it fills up, save a copy and start a fresh file with the open leads.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Real estate

More free templates

All templates · Free tools