Free Lead Tracker Template: The 9-Column Spreadsheet That Books More Jobs

Home service contractors miss 27% of inbound calls, and the average lead response time across the industry exceeds 42 hours, according to CallRail’s analysis of home service businesses.

That means roughly 1 in 4 phone leads dies before anyone says hello. Then the survivors wait two days for a callback.

You do not need ServiceTitan to fix this. You need a spreadsheet with 9 columns, a follow-up rule, and the discipline to log every lead the second it comes in.

Why a spreadsheet works for your first 50-75 leads

Most contractors do not have a tracking problem because their software is bad. They have it because they have no system at all.

The phone rings, the call goes to voicemail, someone scribbles a name on a Post-it, three days later nobody remembers if they called back. HubSpot’s onboarding guidance says a sales lead tracker is built to help you organize prospects and improve conversion rates when managing your first 50-75 leads.

A spreadsheet costs $0. It works on your phone. Your office manager updates it from a job site. No implementation period, no training video.

The catch is discipline. A spreadsheet only works if every lead gets entered the same day. If your team logs leads “when they get to it,” you are back to Post-its inside a month.

What columns does a contractor lead tracker actually need?

Most templates online have 25+ columns. You will fill out 6 of them and abandon the rest.

Here is the 9-column setup that covers everything a small contractor needs without becoming busywork:

#	Column	What goes in it
1	Date Received	The day the lead came in, not the day you logged it
2	Name	First and last
3	Phone / Email	Pick one as primary, both ideal
4	Service Requested	”AC repair,” “panel upgrade,” “drain clear” - specific
5	Lead Source	Google Ads, Google Business Profile, referral, yard sign, Facebook
6	Status	New, Contacted, Estimate Sent, Won, Lost
7	Next Follow-Up Date	A specific date, not “next week”
8	Job Value	Estimate amount, then update with final invoice
9	Notes	Anything that helps the next call - “wife pays bills,” “needs financing,” “asked about Trane”

That is it. Nine columns. Anything more is a CRM masquerading as a spreadsheet.

The HubSpot Sales Lead Tracker template, available free in Excel, Google Sheets, or PDF, follows almost the same structure. So does Smartsheet’s free lead tracking template. The columns are the columns because they are the columns that matter.

How do you set up conditional formatting that actually helps?

Conditional formatting makes your eyes do the work your brain forgets to do. Three rules cover it.

Rule 1: Highlight overdue follow-ups in red. Set conditional formatting on the “Next Follow-Up Date” column. Anything before today, red background. Open the sheet, the red rows are the calls you owe.

Rule 2: Color-code by status. New = yellow. Contacted = blue. Estimate Sent = orange. Won = green. Lost = grey. Scan a 50-row sheet in 10 seconds and know exactly where your pipeline is.

Rule 3: Bold high-value jobs over $5,000. When you have 30 leads to chase and 2 hours to chase them, call the $8,000 panel upgrade before the $250 outlet swap.

A Lead Tracker Excel review on BusinessManagementBlog confirms that the most valuable feature in any sales tracker is a dashboard with conversion rates, monthly trend, lead age, and source analysis. Conditional formatting gets you 80% of that dashboard without a pivot table.

What lead source categories should a contractor use?

Vague categories are why customer-reported attribution is wrong 35-40% of the time. “Online” tells you nothing.

Use these specific categories:

• Google Ads (paid search)
• Google Business Profile (map pack)
• Google Organic
• Google Local Services Ads (LSA)
• Facebook / Instagram
• Referral - past customer
• Referral - contractor / realtor
• Yard sign / truck wrap
• Direct mail / postcard
• Nextdoor
• Repeat customer

Most contractors will only use 6 or 7 actively. Each category has to tie back to a specific marketing spend so you can calculate cost per lead.

How to track lead sources from click to closed job walks through the full attribution chain.

How fast do you actually need to follow up?

The data on response time is brutal.

Leads contacted within 5 minutes are 100 times more likely to convert than leads contacted after 30 minutes. Multiple studies put 21x faster conversion at the 5-minute mark vs the 30-minute mark.

78% of customers hire the first contractor who responds. Not the cheapest, not the most reviewed - the first to pick up.

85% of unanswered callers never call back. They are calling the next guy on the list.

The spreadsheet does not fix this alone. It turns “I think we got a call this morning” into “we got 4 leads today, 3 still in New, oldest is 47 minutes old, go call him.” The 5-minute speed-to-lead rule covers why this single number moves close rates more than any other lever.

How do you build this in Google Sheets in 15 minutes?

Open a new Google Sheet. Name it “Lead Tracker [Year].” Add the 9 columns from the table above. Row 1 is the header, row 2 is your first lead.

Date column: Select column A, Format > Number > Date.

Status dropdown: Select column F, Data > Data validation > Dropdown, add New, Contacted, Estimate Sent, Won, Lost.

Source dropdown: Select column E, Data > Data validation > Dropdown, paste your source list.

Overdue follow-up formatting: Select column G, Format > Conditional formatting > Custom formula: =AND(G2<TODAY(), F2<>"Won", F2<>"Lost"). Red fill.

Status formatting: Select column F, Conditional formatting > Single color > Text contains “Won,” green. Repeat for each status.

Summary tab formulas:

• Total leads MTD: =COUNTIF('Leads'!A:A, ">="&EOMONTH(TODAY(),-1)+1)
• Won MTD: =COUNTIFS('Leads'!F:F, "Won", 'Leads'!A:A, ">="&EOMONTH(TODAY(),-1)+1)
• Revenue MTD: =SUMIFS('Leads'!H:H, 'Leads'!F:F, "Won", 'Leads'!A:A, ">="&EOMONTH(TODAY(),-1)+1)

Share with your office manager. That is the template. For Excel, the same structure works - the free LMS Lite Ver 3.0 and OnePageCRM templates both follow this skeleton.

What does a real contractor’s tracker tell you that lead count never will?

Lead count tells you the phone is ringing. The spreadsheet tells you what is happening after.

A remodeling contractor on ContractorTalk shared his breakdown: $14,247 in marketing spend producing $334,299 in revenue from 38 closed jobs out of 132 leads. Home shows produced 81 of the 132 leads, but his 6 referral leads closed at nearly twice the rate.

Without source tracking he would have assumed home shows were his best channel. The spreadsheet showed referrals were the highest-margin dollar spent.

An HVAC contractor on r/sweatystartup ran the same exercise: his Nextdoor ads produced $180 CAC maintenance calls while his LSAs produced $220 CAC emergency replacements at 4x the ticket. He moved $800/month from Nextdoor to LSA and revenue climbed without adding spend.

Neither contractor needed ServiceTitan. They needed a spreadsheet they actually filled in. Cost per lead vs cost per booked job breaks down why a “cheap” channel can be your most expensive one.

When do you upgrade from spreadsheet to CRM?

The spreadsheet has a ceiling. Upgrade when:

• You miss calling back a lead more than once a month. Spreadsheets do not send reminders. A CRM does.
• You cannot answer “how many leads this month” or “what is my close rate” in under a minute.
• You have 3+ people taking calls. Leads get duplicated, lost, or ignored across systems.
• You are managing 50+ active leads at once. Storm season for roofers, summer for HVAC.
• You hit 5-10 employees. Owner-operator systems break at 15.

67% of large-scale contractors now integrate CRM into their workflows. The shift is industry-wide.

When that day comes, CRM for small contractors and the CRM showdown for home service cover which platform fits your size. The sales tracking software guide goes deeper on what to look for.

What does a CRM do that a spreadsheet cannot?

Six things a spreadsheet will never do for you:

• Automated follow-up reminders when a lead sits in “Estimate Sent” for 3 days
• Source tagging via built-in call tracking - no guessing Google Ads vs Google organic
• Pipeline automation - leads move stages on triggers, not 40 manual edits a week
• Customer history - every past job, estimate, and call in one view
• Multi-user access without versioning chaos across six months
• One-click reports on close rate by source and average ticket by service

When you can name 2 of those as a real problem today, upgrade. Until then, the spreadsheet wins on cost and simplicity.

The lead management system guide covers the upgrade decision. Tracking campaign performance is the next read on closing the leads-to-revenue loop.

What about the leads that never become leads?

The gap a spreadsheet cannot close: the 96% of website visitors who leave without calling or submitting a form.

Your tracker sees the ones who raised their hand. The homeowner who hit your AC repair page, read your reviews, and bounced is invisible.

Once your tracker is humming and you have squeezed the leads you do capture, the next jump comes from identifying anonymous website visitors and recovering form abandoners.

The parent guide to paid ads analytics tools for contractors covers the full stack from tracker to attribution to visitor ID.

Frequently Asked Questions

Is a free lead tracker spreadsheet enough for a small contractor?

Yes, for your first 50-75 leads or until you hit 5+ employees. HubSpot, OnePageCRM, and Smartsheet all publish free lead tracker templates designed exactly for this scale. The spreadsheet works as long as one person owns it and every lead gets logged the same day. Beyond that, the lack of automated follow-up reminders and multi-user reliability becomes a real cost.

What columns does a contractor lead tracker need?

Nine columns cover it: date received, name, phone/email, service requested, lead source, status, next follow-up date, job value, and notes. Anything more is a CRM in disguise. The most valuable feature in any sales tracker is conversion rate visibility by source, which these 9 columns plus a summary tab give you.

How is a lead tracker different from a CRM?

A lead tracker is a spreadsheet that logs leads and follow-ups. A CRM automates follow-ups, tags call sources, runs reports, and handles multi-user access without breaking. Research shows businesses using a CRM see a 29% increase in sales revenue and 34% boost in sales productivity per Salesforce data, but only if your team uses it. A spreadsheet your team uses beats a CRM your team ignores.

How fast should I follow up on a new lead?

Within 5 minutes if possible. Leads contacted within 5 minutes are 100x more likely to convert than leads contacted after 30 minutes, and 78% of customers hire the first contractor who responds. 85% of unanswered callers never call back. Your spreadsheet should make today’s untouched leads visually obvious - that is what conditional formatting on the follow-up column is for.

Should I use Excel or Google Sheets for my lead tracker?

Google Sheets unless your team already lives in Excel. Google Sheets handles multi-user editing without versioning headaches, works on every phone, and shares with one link. Excel works fine for a one-person operation. The free OnePageCRM lead tracker explicitly recommends Google Sheets for accessibility across devices.

---

Start with the 9-column setup, set up the conditional formatting, and log every lead the same day it comes in. That gets you 80% of what a $129/month CRM does at $0.

Once the spreadsheet is humming and you want to see the 96% of visitors who never become leads in the first place - PipelineOn identifies anonymous website visitors so the leads in your tracker are not the only leads you ever know about.