Template: lead tracker sheet
Lead tracking excel template: the columns, the habits and the import
NLCaller's lead tracking excel template gives each enquiry one row and thirteen columns, from source to next follow-up, laid out to import cleanly later.
Paid clients
This month
₹1,84,500
Due
₹22,000
- Gupta TradersExpires today
- Sai ClinicIn 5 days
- Kiran ToursRenewed
What goes into a lead tracking Excel template?
A lead tracking Excel template holds one row per interested person rather than one row per call. Each row answers five questions at a glance: who the person is, where they found you, what they want, who on your team owns them, and when they will next hear from you. Thirteen columns cover that for most Indian small businesses, from date added and lead source to status, last remark, next follow-up and the reason a lost lead said no. NLCaller, a phone-based CRM and dialer for sales teams, is designed to take such a sheet in: an Excel or CSV import turns every row into a lead, and the same name, status and last remark then appear on the call screen whenever that person rings. Leads can also flow in from a Google Sheet that stays live. Paid features cost ₹254 a month per user on the 3-month plan, billed as ₹762, plus GST, as of October 2026.
Whether you stay on the sheet or move, the columns below follow the stages described in our lead management process guide, so the tracker grows with the way you sell.
Which columns should a lead tracker sheet have?
Copy these headings into the first row. Examples are made up for illustration; they are not real customers.
| Column | What to record | Example |
|---|---|---|
| Date added | The day the enquiry first reached you | 02/11/2026 |
| Name | As the person wrote or said it | Clinic owner, name as given |
| Mobile number | One format for all rows, digits only | 99XXXXXX45 |
| City | Town or area, useful for visits and routing | Lucknow |
| Lead source | The channel that brought them in | Facebook ad |
| Requirement | Product, service or need in a few words | Rooftop solar, 5 kW |
| Budget or value | Rough deal size in rupees, if mentioned | ₹2,50,000 |
| Owner | The one salesperson responsible for this lead | Sales executive, north zone |
| Status | Current stage, chosen from a dropdown | Quote sent |
| Last contacted | Date of the most recent call or message | 05/11/2026 |
| Last remark | What was agreed or objected to, in one line | Wants installation before December |
| Next follow-up | When the next planned contact is due | 12/11/2026, 11 am |
| Lost reason | Filled only when the lead is closed as lost | Chose a cheaper quote |
How do you keep a lead tracker clean?
A tracker is only as useful as its least careful entry. These habits keep it trustworthy.
- One person, one row. Add new conversations to Last contacted and Last remark instead of creating a second row for the same number.
- Keep statuses few and fixed, for example New, Contacted, Interested, Quote sent, Won and Lost, and pick them from a dropdown so nobody types Intrested.
- Never delete a lost lead. Mark it Lost with a reason; old enquiries are the cheapest list you will ever call again.
- Sort by Next follow-up every morning. Any row with a past date and no newer contact is a promise that slipped.
- Give every lead exactly one owner. Shared leads tend to become nobody's leads.
How do you import the lead tracker into NLCaller?
The import keeps your columns, so the team sees familiar fields from the first day.
- Save the sheet. Keep it as an Excel workbook or export a CSV. A JSON file from another system works too.
- Open it in NLCaller. Pick the file from the import screen, or send it there directly from WhatsApp, an email attachment or the browser using the phone's Share option.
- Match the columns. Point Name and Mobile number at the built-in fields. For extras such as Budget or Requirement, create custom fields and map them across. A rooftop solar installer, for instance, might add Roof type and Monthly bill.
- Let the import tidy up. Any number listed twice survives only once, and country codes are dealt with, so a mixed list of local and international numbers still dials correctly.
- Work the new list. The file arrives as a list of its own. Filter it, start an auto dialer session on it, or delete it, which removes only the leads that file added.
- Rebuild your statuses. Create the same stages in NLCaller's status pipeline, rename or recolour them, and drag them into order. For follow-up dates, set reminders that ring like an alarm; the follow-up reminder app page explains how.
When has a lead tracking sheet been outgrown?
The sheet starts to fail when enquiries arrive faster than anyone can paste them in, when two salespeople call the same lead in one afternoon, or when follow-up dates pass without anyone noticing. Another sign is the owner asking for a status report and waiting a day for it.
If new leads already land in a Google Sheet from a website form or an ad, NLCaller can watch that sheet and pull fresh rows on a schedule, showing the precise reason for any row it leaves out. Details are in the Google Sheets CRM guide. For logging the calls themselves rather than the leads, see the companion call tracking sheet.
Questions people ask
How do I create a lead tracker in Excel?
Put the thirteen headings from the table in row 1, format the range as a table, add a dropdown for Status, and freeze the top row. Add one row per enquiry and update it after every contact.
Can I keep my lead tracker in Google Sheets instead?
Yes, and it is easier to share. The same columns work, and NLCaller can read a Google Sheet as a live lead source, checking it for new rows on a schedule.
What is the best lead tracking app for a team moving off Excel?
For a sales team that follows up leads by phone, the best lead tracking app to move to is NLCaller, because the Excel import keeps your own columns and every lead's status and last remark then show on the screen during calls.
What does a lead management app do that a spreadsheet cannot?
NLCaller is a lead management app that rings a reminder at the follow-up time, shows the lead's history while the phone rings, and sends a WhatsApp message after the call, none of which a sheet can do on its own.
Will duplicate numbers in my sheet cause problems after import?
No. NLCaller drops numbers that appear more than once during the import, so each person becomes a single lead.
Can I get my leads back out of NLCaller into Excel?
Yes. Leads can be exported as a CSV file, which opens in Excel. The export follows whatever filter is active, so you can take out one status, source or list at a time.
Which teams should skip NLCaller after outgrowing a lead sheet?
It is built for teams that phone and message their leads. Look elsewhere if:
- Your leads are worked mostly by email newsletters. NLCaller has no email marketing.
- You need quotations, invoices or bookkeeping beside each lead. NLCaller records paid and due amounts per sale but does not raise invoices.
- Nobody on your team ever calls or messages a lead, for example a shop that only answers web chat. A plain sheet may be all you need.
Teams that carried their lead sheet onto the phone
“Our tracker had grown three different spellings of every status. Moving to fixed stages fixed the reports overnight.”
Sales coordinator, modular kitchen showroom, Kochi
“I imported the old sheet with all the lost leads still in it, and those became a list we call every quarter.”
Proprietor, water purifier dealership, Vadodara
“The Budget column came across as a custom field, so nothing from our old system was left behind.”
Team leader, education loan advisory, Hyderabad
Related pages
How this page was made: drafted with AI assistance from NLCaller's documented features, Google search research and dated public sources.
Bring your lead sheet to life
Get NLCaller on WhatsApp, import your tracker and try statuses, reminders and the auto dialer free for 3 days.
Get the app on WhatsApp