Tools

How to use a spreadsheet for basic real estate lead grading

You can use a basic spreadsheet to grade your real estate leads, even if you don't have a sophisticated CRM. A simple setup helps you quickly categorize and prioritize motivated seller replies based on key criteria.

October 12, 2026 · 4 min read

Why grade your leads in the first place?

Lead grading helps you focus your limited time and resources on the opportunities most likely to close. Not all leads are created equal; some sellers are more motivated, their properties are in better condition for your model, or their timelines align better with your needs. Without a grading system, you might spend too much effort on leads that have a low probability of converting.

A simple grade allows you to quickly sort and identify your hottest leads, ensuring you prioritize follow-up and offer generation for those. It brings structure to your outreach and prevents good opportunities from falling through the cracks.

Setting up your spreadsheet columns

Start with essential columns. You will need: Seller Name, Property Address, Contact Number, Lead Source (e.g., Speed to Seller, direct mail), Date Received, Initial Reply (a brief summary of the text reply), and your 'Grade' column. Add columns for 'Motivation Level', 'Property Condition Estimate', and 'Timeline'.

You might also include 'Notes' for call summaries or specific seller details, and 'Next Follow-up Date' to keep track of your outreach. The goal is to capture enough information to make grading decisions without making the spreadsheet overly complex.

Defining your grading criteria (A, B, C leads)

Establish clear definitions for your lead grades. For example:

A-leads: High motivation (e.g., 'need to sell fast due to job relocation'), decent property condition (e.g., cosmetic repairs only), short timeline (e.g., 'within 30 days'). These get immediate, intense focus.

B-leads: Moderate motivation (e.g., 'just exploring options'), needs more significant repairs but still viable, flexible timeline (e.g., 'next 3-6 months'). These require consistent follow-up.

C-leads: Low motivation (e.g., 'just curious'), extensive repairs needed (e.g., structural issues), long or undefined timeline. These get periodic, less urgent follow-up, or are set aside for later consideration.

Your criteria will depend on your specific investing strategy. Be consistent with these definitions.

Inputting initial lead data

When you receive a new lead, enter all the basic information into your spreadsheet right away. For Speed to Seller leads, you will have the property address and the homeowner's direct reply, which gives you immediate clues for initial grading. Based on the initial text, you can already make a preliminary grade.

For example, a text reply like 'Yes, I need to sell my house in the next month, it's inherited and I live out of state' immediately suggests an A-lead. A reply like 'maybe, what's your offer' might start as a B or C lead, pending further conversation.

Updating lead grades after contact

The initial grade is just a starting point. As you have conversations with sellers, you will gather more information that allows you to refine the grade. If an A-lead turns out to have unrealistic expectations, he or she might drop to a B or C. Conversely, a C-lead who reveals a hidden motivation might jump to an A.

Always update the grade immediately after a significant interaction. This ensures your spreadsheet reflects the most current understanding of the lead's potential. Your 'Notes' column should support why a grade was changed.

Filtering and sorting your graded leads

The power of a spreadsheet for lead grading comes from its sorting and filtering capabilities. You can quickly filter to show only your A-leads, allowing you to prioritize your daily calls. You can sort by 'Next Follow-up Date' to ensure no lead is forgotten. This is how you manage your workflow.

You can also filter by 'Lead Source' to see which sources are providing your best leads, or by 'Timeline' to identify properties that are nearing critical decision points. This flexibility is what makes even a simple spreadsheet a powerful organizational tool for investors.

Transitioning from spreadsheet to CRM (when ready)

A spreadsheet is a great starting point for basic lead grading and management. However, as your volume of leads grows, or you start building a team, you will likely outgrow its capabilities. CRMs offer automation, integration with dialers, more robust reporting, and better team collaboration. When you find yourself constantly battling formulas or struggling to share updates, it is time to consider a dedicated CRM solution.

The principles you learn from grading in a spreadsheet—defining criteria, consistent input, regular updates—are directly transferable to a CRM. You will simply be doing it with more powerful tools. For options on CRMs, or alternatives to lead management software, check out our related resources.

Questions people ask

What's the difference between lead grading and lead scoring?

Lead grading is typically a manual, qualitative assessment (e.g., A, B, C) based on your judgment and specific criteria. Lead scoring often involves assigning points based on various data points and actions (e.g., website visits, email opens), resulting in a quantitative score, which is usually automated by a CRM.

Should I use colors in my spreadsheet for grading?

Yes, using conditional formatting to color-code your grades (e.g., red for C, yellow for B, green for A) can provide a quick visual overview of your lead pipeline. It helps you instantly identify which leads need your attention most.

How often should I update the grades?

Update grades immediately after any significant interaction with a seller or if new information about the property or motivation comes to light. At a minimum, review and update all active lead grades weekly to ensure your priorities are always current.

Can I track more than just grades in a spreadsheet?

Yes, you can track almost anything: follow-up dates, property details, repair estimates, offer amounts, disposition status, and more. However, keep it focused and simple to avoid overwhelming yourself. For extensive tracking, a CRM becomes more practical.