Free Sales Pipeline Tracker Template for Excel and Sheets

What is a sales pipeline template?

A sales pipeline template is a ready made sheet that records every lead you are working, with the stage it is in, who owns it, when you last spoke and when you will speak next. Good ones also carry formulas that warn you about stale deals and add up the money sitting in each stage.

Teams without a CRM usually start with a sheet built in a hurry. Someone adds a column for "status", another adds "remarks", and six months later nobody can say what a lead in "Pending" means.

This generator removes that first mess. You pick your industry, and it builds a tracker with the right columns and stage names for how that industry sells. You can preview the table, copy it as TSV (tab separated values) to paste into Google Sheets, or download a CSV file for Excel.

A few terms, defined once:

• Pipeline is the list of all open deals, arranged by stage.
• Stage is a fixed step a deal passes through, such as Qualified or Negotiation.
• Stale means a deal has not been touched for more than a set number of days. The default here is 7.
• Next follow up date is the date a human has promised to act on the lead again.

A sheet is a starting structure, not something that scales forever. A checklist near the end tells you when to move on.

Why does pipeline tracking matter for Indian sales teams?

Pipeline tracking matters because Indian sales teams lose deals mostly through silence, not through rejection. A lead that nobody is tracking quietly dies between two reps, two WhatsApp chats and one forgotten notebook.

Leads arrive through a Meta lead ad form, an IndiaMART or Justdial enquiry, a missed call, a WhatsApp message or a walk in. Each is logged somewhere different. Without one tracker, the owner is whoever picked it up first.

Specific things go wrong.

• A rep goes on leave and nobody knows which of their leads need a call today.
• A manager asks "how much is in negotiation?" and gets three different answers from three reps.
• A promised callback slips by a week because the date lived only in a diary.

A tracker with agreed stages and dates makes the owner, the age of each lead and the money visible. That is enough to run a weekly meeting on facts.

Stage definitions matter as much as columns. When "Qualified" means different things to two reps, your stage counts lie. Write one line per stage first. The Sales Pipeline Health Grader asks twelve questions about exactly these habits, and it is a good check once your sheet has been running for a month.

How to use the Sales Pipeline Tracker Template

You can have a working tracker in about five minutes. Here is the path.

1. Pick your industry. Choose real estate, education, manufacturing, healthcare, automotive, insurance, or services and SMB. The columns and stages change to match.
2. Check the stages. Rename any stage that does not match how you talk. Keep the list short, and keep Lost as the last stage so closed deals never hide in the open list.
3. Preview the table. Check the headers and layout before you copy anything.
4. Copy as TSV or download CSV. Copy as TSV and paste into cell A1 of a new Google Sheet. Or download the CSV and open it in Excel.
5. Paste in your existing leads. Export from your old sheet, ad platform or portal, and give each lead one stage and one owner.
6. Add the formulas. Use the stale flag, stage count, conversion and pipeline value formulas given below, and fill them down the column.
7. Set a weekly review. Block thirty minutes every Monday. Sort by Stale flag, then by Next follow up date, and fix every row that is out of date.

After setup, keep one rule: no lead exists without an owner, a stage and a next follow up date. Run the Stuck Deals Finder on an exported CSV whenever you want a second opinion on which deals are at risk.

How do the template formulas work?

The template uses four formulas: a stale flag, a stage count, a stage conversion and a pipeline value. Each reads the Stage and date columns, so the sheet updates itself.

The real estate template uses these default columns.

The formulas below assume the Stage column is H and the Last contact date column is I, as above.

Stale flag (column M, filled down from row 2):

=IF(AND(H2<>"Won",H2<>"Lost",TODAY()-I2>7),"STALE","OK")

It marks a lead STALE when the stage is not closed and the last contact is more than 7 days ago. Replace "Won" with your own winning stage name. In the real estate template that is "Booked". Change the 7 to suit your sales cycle.

Stage count:

=COUNTIF(H:H,"Qualified")

It counts how many rows currently sit in that stage. Write one line per stage.

Stage conversion:

=COUNTIF(H:H,"Site visit done")/COUNTIF(H:H,"Site visit scheduled")

This gives a rough ratio between two stages. Be aware of one limit. A sheet that stores only the current stage cannot see leads that already moved past a stage. So this ratio is a snapshot, not a true conversion rate. For real conversion you need a stage history, which a CRM keeps and a sheet does not.

Pipeline value:

=SUMIFS(L:L,H:H,"Negotiation")

It adds the Value column for deals in a stage. For total open value, sum all stages except closed ones, for example =SUMIFS(L:L,H:H,"<>Booked",H:H,"<>Lost").

Assumptions:

• Dates must be real dates, not text. A date typed as "5th Oct" breaks the stale flag.
• Value is your own estimate in rupees, such as ₹60,00,000 for a flat.
• The 7 day stale limit is a default. A long manufacturing cycle may use 14.

Worked example: a five lead real estate tracker

This example is illustrative. The tool loads with the real estate template and blank rows, so the five leads below are made up to show how the formulas behave. The values and days are assumptions.

Here is what the formulas return for this sheet.

• Total value across all five leads: ₹3,90,00,000 (₹3.9 crore).
• Open pipeline, which excludes the Booked deal: ₹3,00,00,000 (₹3 crore).
• Stale value, which is L003 plus L004: ₹1,15,00,000 (₹1.15 crore).
• Stale share of open pipeline: about 38.3% by value, because 1.15 crore divided by 3 crore is 0.383.
• Stage counts: one lead each in Site visit done, Negotiation, Qualified, New and Booked.

Now read it like a manager. Two of four open deals are stale, and between them they hold more than a third of open value. L003 is a walk in left at Qualified for 9 days. L004 is a portal lead still marked New after 12 days, so first contact may never have happened. Sneha and Imran each have one named fix to make today.

No formula fixed anything. The sheet only made the problem visible, and a person still has to call.

How do you read your result?

Read the tracker in this order: stale flags first, then missing dates, then stage counts, then value. The most urgent problem is always a live deal that nobody has touched.

A few reading rules.

• The stale share of open pipeline value (about 38.3% in the example above) is a better alarm than the count of stale leads, because one large stale deal can hold more money than ten small ones.
• A stage with many leads is not always a bottleneck. Deals may naturally wait there, like waiting for a loan sanction.
• Zero stale leads can be a warning too. Reps may touch deals only to reset the date.
• Benchmarks for healthy stage ratios vary by industry and ticket size. Use your own history rather than a number from someone else's sales cycle.

If your sheet shows large value in the late stages, put weights on the stages to see what you are likely to close. The Weighted Sales Forecast Calculator does this with stage probabilities.

Sales pipeline template by industry

Each industry gets its own stage list and a few extra columns.

Real estate

Add a project column and a site visit date, since the visit is the real turning point. Split "visit scheduled" from "visit done" so no shows are visible. Track budget next to the unit value. The Site Visit to Booking Calculator helps you work out what a better show up rate is worth.

Education

Use Counselled as a stage of its own, because a counselling session is where admissions are won. Add a column for the programme or course and one for the parent's name. Record campus visit or demo class date separately from the application date. For study abroad, add intake month and country.

Manufacturing and B2B

Sales cycles are long, so raise the stale limit to 14 days or more. Capture the requirement in a column, such as product, quantity and delivery date. Quote sent and Sample or trial are your two stage gates. Add a column for the buyer's decision maker name, and one for GST registered company name so quotes and invoices match later.

Healthcare and clinics

Keep the tracker free of medical detail. Record the service sought and the appointment date, not diagnosis or reports, because health data is sensitive personal data under the DPDP Act. Appointment booked and Visited are the two stages to watch. Add a column for the referring source, such as a doctor, an online listing or a camp.

Automotive

Track the vehicle model, variant and colour interest. Split Test drive booked from Test drive done. Add an exchange vehicle column and a finance required flag, since both slow a booking. Delivered follows Booked, so you can see deals paid but not yet handed over.

Insurance and financial services

Documents is the stage where most policies stall, so give it its own column for what is pending, such as ID proof or medical form. Record the product type and the renewal date for existing customers. Use the next follow up date for premium due dates as well. Collect personal and financial data with clear consent and a stated purpose.

SMBs and services

Keep the sheet short. Six stages and ten columns are enough for a team of three. The key fields are Proposal sent date, Value and Next follow up date. Avoid inventing new stages every month.

What mistakes do teams make with a pipeline tracker?

Most tracker failures come from habit, not from formulas. Watch for these.

• Too many columns. If a rep needs two minutes to log a call, they will not log it. Keep the sheet to what you act on.
• Free text stages. Typing "Hot", "hot lead" and "Hot!" creates three stages. Use a dropdown list with data validation.
• No owner column. A lead with no named owner is owned by nobody.
• Dates typed as text. The stale formula needs real dates, or it returns errors or wrong answers.
• Open edit access for everyone. Anyone can delete a row. Use protected ranges and version history.
• Never closing Lost. Dead leads inflate pipeline value.
• Counting current stage as conversion. A sheet cannot see where a deal has been, so stage ratios from it are rough.
• Storing sensitive data casually. Phone numbers and personal details in a widely shared sheet are a DPDP Act risk. Limit access by role.

How can you improve your result?

You improve a tracker by making it quicker to update and harder to ignore. These tactics are grouped by owner and time.

Make the sheet easy to keep current (owner: sales manager, week 1)

• Add dropdowns for Stage, Owner and Source.
• Freeze the header row and the first two columns.
• Colour the Stale flag red with conditional formatting.
• Put a data validation rule on date columns so only dates are accepted.

Build a weekly pipeline review (owner: team lead, every Monday)

• Filter for STALE and ask each owner for a next step on every row.
• Filter for blank Next follow up date and fix them in the meeting.
• Close any lead with no reply after your full follow up sequence and mark it Lost with a reason. The Follow Up Cadence Planner gives a sequence you can adopt.

Add a few control columns (owner: operations, week 2)

• Lost reason, with a short list of choices.
• Source, so you can see which channels give deals, not only leads.

Protect the data (owner: founder or admin, week 1)

• Share the sheet with named people, not "anyone with the link".
• Remove access when a rep leaves, and take a backup monthly.

To score which open leads deserve the first call, pair the sheet with the Lead Scoring Calculator.

Sales pipeline template: spreadsheet, CRM or Erino?

A spreadsheet is the right tool for the first few weeks. A CRM becomes the right tool when updating the sheet takes more time than selling, or when different people see different versions.

Here is a plain comparison. Many CRMs, including LeadSquared, Zoho CRM, Kylas, TeleCRM, HubSpot, Pipedrive and Freshsales, offer pipeline views. What each plan includes changes, so check each vendor's current plans.

Have you outgrown the sheet?

Move to a CRM when three or more of these are true.

• You have more than one person editing the same file every day.
• You cannot say who spoke to a lead last without asking around.
• You want call recordings and WhatsApp chats linked to the lead.
• You need field staff to log visits from their phones.
• You want alerts when a follow up is due, not a Monday filter.
• You handle personal data and need audit trails and role based access.

Erino is an AI first sales CRM for high velocity teams in India. It gives every lead an owner on arrival, creates the next follow up at every stage and flags stuck deals in real time, which are exactly the jobs the formulas above do by hand. See the Erino platform, or industry pages for real estate and manufacturing. Smaller teams can start with the SMB page. Technical Guftgu saved 28 hours every week and went live in seven days, as described in its success story. Pricing is quoted after a free 15 minute demo.

Frequently asked questions

Written by the Erino team

Erino Tech Ventures Pvt. Ltd. builds Erino, an AI first sales CRM for high velocity sales teams in India. Last reviewed 26 Oct 2026. This tool runs in your browser; the numbers you type are not sent anywhere.

Customer results mentioned here come from Erino's published success stories.