Cold Call Tracking Spreadsheet for Cleaning Companies and Janitorial Providers (Free Template)
This cold call tracking spreadsheet is a free template for cleaning companies that call local businesses for commercial accounts. You log every call, email and drop-in, see each morning who to call back today, and count how many dials it takes to book one walkthrough. It’s a cold call tracking sheet template with 3 tabs,
This cold call tracking spreadsheet is a free template for cleaning companies that call local businesses for commercial accounts. You log every call, email and drop-in, see each morning who to call back today, and count how many dials it takes to book one walkthrough. It’s a cold call tracking sheet template with 3 tabs, built to sit next to your calendar during a calling block.
Download it here, no email required: Google Sheets template and Excel template. The calling process itself, with scripts and which status to pick after each call, is in How to Cold Call for Commercial Cleaning Contracts. This post covers the sheet.
What’s in the template
The cold calling spreadsheet template has 3 tabs, and each has one job. The Leads tab holds one row per business: who they are and where things stand right now. The Call log tab holds one row per attempt, so nothing you learn gets overwritten. The Summary tab holds nothing you type; it counts from the log and calculates the rates between each step. Leads and Call log each come with one grey example row showing the format; delete both before your first call, or the example shows up in your counts.
There are two versions and one format left out on purpose. The Google Sheets copy needs a Google account; if you don’t have one, use the .xlsx, which keeps the dropdowns and formulas. There’s no CSV version, because a CSV stores plain values only, so the dropdowns, formulas and highlighting would be gone the moment you opened it.
Leads tab: one row per business
One row per business, 18 columns:
| Column | What goes in it | Why |
|---|---|---|
| Business name | Name as listed on Google Maps. Add the street if 2 locations share a name. | The Call log dropdown pulls from this column, so each name has to be unique. |
| Phone | Main number from the listing | You won’t know who answers it until you call (see “Who answers”). |
| Business email, if one is listed | For the email step of your follow-up. Often a general inbox. | |
| Website | URL | Opening hours, number of locations, photos of the space. |
| Category | Category as Google Maps lists it | One search can mix business types with different hours and needs. |
| Address | Street, city, ZIP | Grouping drop-ins by neighborhood. |
| Google rating | For example 4.6 | Context only. It says nothing about their current cleaner. |
| Review count | A number | A rough signal of size and foot traffic. |
| Status | Dropdown: Not called, Called, Callback, Won | Where the lead stands now. Your filters run on it. |
| Notes | Short free text | Reasons, objections, anything without its own column. |
| Date found | The date the lead went on your list | Shows how long a lead has sat untouched. |
| Contact name + role | For example “Maria, office manager” | The first thing your second call needs. |
| Who answers | Dropdown: front desk, answering service, owner | Tells you how the next call will start. |
| Current cleaner | Company name, or “in-house” | Context when you hear “we already have a cleaning company”. |
| Contract renewal date | Month and year, if that’s all you get | Call a month or so before it. |
| Next step | One action: call, email, walk-in, walkthrough | One action, not a plan. |
| Next follow-up date | A date | The filter you start every calling block with. |
| Do not call | Y or N | Keeps the row out of your dial list. |
The first 11 columns are what a listing and your first call give you. The last 7 are things only a conversation can tell you, so most of them stay empty for most rows.
The Status dropdown has 4 values: Not called, Called, Callback, Won. There’s no Lost or Not interested. A business that says no stays at Called with the reason in Notes, the same rule as the status table in the cold calling guide. “Called” plus “Not interested: has cleaner, renews March” tells you more next spring than a Lost label would.
If someone asks you not to call again, set Do not call to Y before your next dial, and stop calling that number. Write the date and who asked in Notes. The sheet can’t stop you from dialing, so every filter you dial from has to exclude Y rows.
Typing statuses by hand is the mistake that breaks the sheet. “call back”, “CB” and “Callback” look the same to you, but a filter for Callback finds only the last one, and the Summary counts miss the others. The dropdown accepts only the 4 values. One gap: pasting data in can overwrite the dropdown rule in both Google Sheets and Excel, so check the Status column after every paste.
Call log tab: one row per call, email or visit
The Call log works as a cold call log template: one row every time you try to reach a business, by any channel. Columns:
- Date
- Time (when you dialed; the Summary uses it for time-of-day buckets)
- Business name (dropdown pulled from the Leads tab)
- Channel: call, email or walk-in
- Who you reached: name and role, “front desk”, “voicemail” or “nobody”
- Reached decision-maker: Y or N
- Outcome (dropdown): voicemail, got a name, callback set, walkthrough booked, not interested, asked not to be called
- Next step
Why not update the Leads row each time? Because the follow-up cadence in the cold calling guide has 5 touches per business: a call, an email, a second call, a drop-in and a last call. If you overwrite one row each time, the history is gone, and you can’t count how many dials turned into conversations. The Leads row holds the current state; the log holds what happened, in order.
Log emails and visits here, not just calls. When you send one of the cold email templates for cleaning contracts, add a row with Channel = email. After a walk-in visit, add a row with Channel = walk-in before you drive to the next stop. The Summary counts dials from call rows only, so emails and visits don’t inflate your dial count.
When you call and nobody picks up and there’s no voicemail, log it anyway. Write “nobody” under Who you reached, N under Reached decision-maker, and leave Outcome empty. It’s still a dial, and skipping it makes your dials-per-walkthrough rate look better than it is. Those rows also show you which times of day nobody answers.
Summary tab: your own numbers
The Summary tab calculates everything from the other two tabs; you never type into it. The first table counts:
- Dials: call rows in the log
- Decision-maker conversations: call rows with Reached decision-maker = Y
- Walkthroughs booked: log rows with Outcome = walkthrough booked
- Contracts won: Leads rows with Status = Won
It then shows the rate between each step: conversations per dial, walkthroughs per conversation, and contracts per walkthrough. Walkthroughs booked counts every channel, so if you book some on a walk-in or by email, the walkthroughs-per-conversation rate will look higher than your calls earn on their own. The second table splits dials and decision-maker conversations into 2-hour blocks across the day, which is how you test call times instead of guessing. You can change the blocks to fit your day. A call only lands in a block if you typed a real time, like 10:30 AM; calls with no time are counted on a separate “No time logged” line.
The tab is empty until you log calls, and it shows no benchmark numbers, only yours. The funnel math in the cold calling guide uses a hypothetical example; this tab replaces it with your own rates. Under about 100 dials, the rates move too much from one call to the next to tell you anything.
How to use it during a calling block
- Before the block, filter the Leads tab to Status = Callback and Next follow-up date on or before today. Call those first: these are people who told you when to call.
- Then filter to Status = Not called and Do not call = N, sorted however you qualified the list (review count, category or neighborhood).
- After each call, before the next dial, add a Call log row. Then update the Leads row: status, next step and next follow-up date.
- At the end of the block, filter to Status = Callback and look for empty Next follow-up dates. Fill in every one.
Two highlighting rules are built in. A row whose Next follow-up date is today or earlier turns amber, so overdue callbacks stand out even without a filter. Rows marked Won or Do not call = Y stay white, even with an old date in them. A business name that appears twice on the Leads tab turns red, which catches the same office pasted in from two lists.
Common mistakes:
- Logging at the end of the day from memory. By the 15th call, the first ones blur, and the times you write down are guesses, which makes the time-of-day table useless.
- Leaving Next follow-up date empty on a Callback. The row never turns amber and never shows up in step 1, so the lead goes cold without you noticing.
- Leaving Do not call rows inside the filter you dial from. Add Do not call = N to step 1 as well as step 2.
After a few blocks, most rows sit at Called: voicemails, front desks that took a message, people who said no. The Callback list stays short. That short list is where the work is, because each row on it has a name, a reason or a date. If your Callback list is long and half of it has no date, step 4 is being skipped.
Getting your list into the sheet
The manual way is free. Search Google Maps for one business type in one city, open each listing, and copy name, phone, website, category, address, rating and review count into the Leads tab. It’s workable for 20 to 30 businesses. The common mistakes are duplicates (the highlight catches exact repeats, not “Smile Dental” next to “Smile Dental Care”), places that have closed, and phone numbers you missed because they sit in a website footer instead of the listing.
Leads for Cleaners builds the same kind of list from live Google Maps results at search time, and you can export it as CSV. The export has the same 11 fields as the first 11 Leads columns, so you paste it in and fill the other 7 as you learn them. Permanently closed places and places with neither a phone nor a website are removed before you get the list. Email comes only on US searches, and only when the business lists one on its website, so expect blanks in that column. There are no decision-maker names, and the tool can’t tell whether a listed number is a mobile, so Contact name and Who answers stay empty until you call.
Watch the Phone column when you open the CSV. If you double-click the file and let Excel open it, Excel can treat a phone number as a plain number, and a number stored as +15551234567 can lose its “+”. Import it instead: in Excel, use Data > From Text/CSV and set the Phone column to Text before loading; in Google Sheets, use File > Import and turn off the option that converts text to numbers. Then copy the rows into the Leads tab.
The trip only goes one way. The app has no CSV import, so statuses and notes you change in the sheet don’t go back into the app. Pick one place as the record for statuses: either work the list in the app and use the sheet only for follow-up dates and the call log, or move everything to the sheet after the export and stop updating the app. Updating both by hand is how they drift apart.
Spreadsheet, the app, or a CRM
How the three options compare as a sales call tracking spreadsheet replacement:
| This spreadsheet | Leads for Cleaners | A CRM | |
|---|---|---|---|
| Builds the list | No. You paste or type it in. | Yes, from live Google Maps results. Leads that appear in overlapping searches are marked “already saved”. | Depends on the product |
| Statuses | 4, via dropdown | 4 (Not called, Called, Callback, Won), with status filters | Usually configurable stages |
| Notes | Notes column, plus the Call log | Free-text notes per lead | Yes |
| Follow-up dates | Next follow-up date column | No | Usually |
| Reminders | No. The amber highlight shows only when you open the sheet. | No | Usually |
| Per-call history | Call log tab | No. Status and notes per lead. | Usually |
| Works for a team | A shared Google Sheet works for a few people | Yes | Built for it |
| Moves data to other tools | Copy and paste | CSV export. No CRM integration. | Imports, exports and integrations vary |
| Cost | Free | Free plan: 2 searches, 10 leads each. Starter $29/month, Pro $49/month, or a $19 one-time pack of 150 credits. | Varies by product and number of users |
A spreadsheet stops working in two situations. The first is several people calling from the same list: two callers can dial the same office an hour apart, and when both edit the same row, the last edit wins. The second is when your follow-ups outgrow what you can scan by eye, because nothing in a sheet reminds you on a day you don’t open it. At that point, a CRM’s reminders and shared history are what you’re paying for. Until then, the sheet plus a calendar entry for every follow-up date covers it.
Start with the free plan: 2 searches with 10 leads each, no card needed. Build a list for one business type in your city and track status and notes in the app. Then export it to this sheet, or put the dates in your calendar, for follow-up dates, because the app has none.
Comments are closed.