Real estate lead tracking spreadsheet: a template and the warning signs

Yes, a spreadsheet can work at first

If you are a small brokerage with a few agents and a modest flow of enquiries, a well-built spreadsheet is a perfectly sensible lead tracker. It costs nothing, everyone already knows how to use it, and it forces you to decide what you actually need to know about a lead. Many brokerages that buy a big system too early end up using it as a spreadsheet anyway.

The trick is to build the sheet around action, not storage. A list of names is not a tracker. A tracker tells each person, every morning, who to contact and what to say.

The columns that matter

Use one sheet, one row per lead. Do not split by agent into separate files.

• Lead ID. A simple running number, so duplicates are easy to spot.
• Date received and Time received. You need the time to measure how fast you reply.
• Source. Property Finder and Bayut (the two largest UAE property portals), Dubizzle (a UAE classifieds site with property adverts), Instagram, WhatsApp (the messaging app most Dubai clients use), referral, walk-in, event. Use a dropdown so spelling stays consistent.
• Name and Phone. Store phone numbers in one format, with the country code.
• Language. English, Arabic, other. Useful for assigning the right agent.
• Interest. Buy to live, buy to invest, rent, sell, off-plan (property sold before it is built).
• Property or project enquired about.
• Budget and Timeline. Even rough ones.
• Owner. The agent responsible. Exactly one name.
• Status. New, contacted, viewing booked, viewing done, offer, won, lost, nurture.
• First reply time. When someone first answered.
• Last contacted and Next action with Next action date.
• Notes. One line, dated.
• Lost reason. A dropdown. You will learn more from this column than any other.

Portals such as Property Finder and Bayut send you enquiries by email or in their own agent dashboards. A person copies them into the sheet, or you use a forwarding tool. Note that Property Finder says its API connections (the official way for software to exchange data with it) are for approved partners, so do not assume you can pull enquiries in automatically.

Make the sheet tell you what to do

A few simple features turn the list into a tool:

1. A filter view per agent. Each agent opens their own view, filtered by Owner, sorted by Next action date.
2. Conditional formatting on overdue actions. Highlight any row where the next action date is before today and the status is not won or lost. In Excel or Google Sheets, a rule such as =AND($N2<TODAY(),$J2<>"Won",$J2<>"Lost") turns the row red.
3. A new-lead rule. Any row with status New and no first reply turns amber after, say, ten minutes. Pick your own limit.
4. A summary tab. Counts by source and status using COUNTIFS (a spreadsheet formula that counts rows matching conditions), so you can see which portal produces viewings, not just enquiries.

A filled example row

Lead 0187. Received today at 10:12 from Bayut. Name: sample client. Interest: buy to invest. Project: a downtown apartment. Budget: a range. Timeline: within three months. Owner: Sara. Status: contacted. First reply 10:19. Next action: send two comparable listings. Next action date: tomorrow. Note: prefers WhatsApp. Everything an agent needs to continue is in one row. This is an invented example to show the level of detail, not a real lead.

Warning signs the sheet is costing you deals

Look for these:

• Two people edit at once and someone's change is overwritten or sits in a copy called "final v3".
• A lead has no owner, or two owners, and both assume the other called.
• You cannot answer "how many leads came from Bayut last month and how many became viewings" without an afternoon of counting.
• Follow-ups depend on memory. Agents keep their own notes on their phones.
• When an agent leaves, half their leads go quiet because nobody knows where they stood.
• Replies are slow and you cannot see how slow, because the sheet has no time stamps.
• The file is slow, hard to filter on a phone, or has formulas nobody dares touch.
• Private data sits in a shared file that is emailed around. Treat phone numbers and ID details with care and limit who has access.

If three or more are true, the sheet is no longer saving you money.

What software and AI can add to a lead sheet

You do not have to throw away your columns. The same columns become the fields of a simple web app, which is what I do in an Excel to web app project. What changes is behaviour:

• Enquiries arrive by themselves, where a connection is available, or through a simple forwarding rule, with the time stamped.
• The lead is assigned by your rules, such as language, area or round robin (taking turns).
• The agent is notified on their phone, and the lead flags itself if nobody replies in time.
• Follow-up reminders are generated from the next action date.
• The summary tab becomes a live view. No one recounts.

AI has a small, honest role. It can read a messy enquiry ("looking for 2br near the metro, budget 1.5m, urgent") and fill in the interest, budget and timeline fields, and it can draft a first reply. A person checks both. It is not a magic filter: it will sometimes misread a vague message, which is why the agent reads the row.

Try it with Claude: Claude is an AI assistant you can use in a browser. Paste ten recent enquiry messages (names and numbers removed) and ask: "For each, extract interest, project, budget, timeline and language into a table, and flag which look urgent." Compare the table to what an agent would have written. If it is close, extraction is worth automating.

Habits that keep a lead sheet honest

Even a good layout decays without habits. Three are worth the effort.

1. A ten-minute morning review. Each agent opens their filtered view and clears every overdue row before doing anything else: contact it, reschedule it with a real date, or close it with a reason. Managers glance at the overdue count, not at every lead.
2. A weekly clean-up. Merge duplicates, fix phone formats, and move leads with no response after your chosen number of attempts to the nurture status (a list of cold leads you keep in touch with) with a revisit date. Cold leads should leave the active view, not clutter it.
3. A monthly look at source. Count enquiries, viewings and closed deals by source. If one portal or campaign brings plenty of enquiries and almost no viewings, that is a conversation to have with whoever manages your listings, and possibly a reason to change what you advertise or how you reply.

Protect the file as well. A lead sheet holds personal data, so limit who can open it, avoid emailing copies, and remove access when an agent leaves. Dubai businesses should follow UAE data protection requirements, which are something to confirm with a qualified adviser rather than guess at.

Excel or Google Sheets

If several agents will use the sheet, choose a cloud version (Google Sheets, or Excel stored online) over a file passed around, because several people can edit the same copy at once and the "final v3" problem goes away. A desktop file on one person's laptop is the weakest option. Whichever you pick, turn on version history so a bad edit can be undone, and keep one person responsible for the structure.

Keeping the data clean from day one

• Dropdowns for source, status, owner and lost reason using data validation, so you do not end up with "Bayut", "bayut" and "Bayut.com" counted as three sources.
• One phone format. Country code, no spaces. Matching phone numbers is the simplest way to find duplicates.
• A duplicate flag. A helper column with =COUNTIF(phone_column, phone_cell)>1 marks repeat enquiries, so you can merge them into one row and one owner.
• Protect the formula columns so an agent cannot overwrite a calculation by accident.

Which source is worth the money

The sheet becomes much more useful when it can say what a lead costs. Add a second tab listing your monthly spend per source: portal subscription, boosted listings, social ads. Then on the summary tab compute enquiries, viewings and closed deals per source, and divide spend by viewings and by deals. Lead source tracking for Dubai brokerages takes this from cost per lead to cost per deal. Do not decide on enquiries alone. A cheap source that produces many unreachable numbers can be worse than an expensive one that produces viewings. Pivot tables (Excel and Sheets can summarise rows by two columns) compare source against status in a few clicks.

Spreadsheet, CRM or custom app: a decision rule

Vendor guides, including one from a real estate CRM company, give the same list of spreadsheet limits: leads from some channels never get entered, nothing alerts you when a lead goes cold, calls and WhatsApp messages are not logged, you cannot see cost per lead, and several editors overwrite each other. Treat that advice with the usual caution, since they sell the alternative. My rule of thumb:

• Stay on the sheet if you have a handful of agents, under a few dozen new leads a week, and the monthly count shows few missed replies.
• Move to a ready-made CRM if your process is standard and you want portal and WhatsApp connections without building anything. See lead management software.
• Move your sheet into a small custom app if you have a process that ready-made tools do not fit, or you want to keep your own columns and rules, and have two or more of the warning signs above.

New brokerage or established

A new brokerage should start on the sheet, because you do not yet know what you need to track, and the sheet teaches you. An established one usually has lead data scattered across agent phones, portal dashboards and old files. Your first job is a one-off gather and clean-up, not a tool purchase: collect it all into the sheet, remove duplicates, assign owners, then decide. Running a boutique brokerage in Dubai covers what else a small firm needs early on.

How I would approach this

Run the sheet properly for a month with the columns above and the overdue highlight. Then count: how many leads had no first reply within your target, and how many went quiet with no next action? That number is the cost of the current process, and it tells you how much a better tool is worth. If the number is small, keep the sheet. If it is not, move the same columns into a simple app so assignment, reminders and the summary happen without anyone remembering.