# Sales Tracking Spreadsheet: Build a Free Pipeline in Sheets or Excel

> Build a sales tracking spreadsheet in Google Sheets or Excel: the columns, stage drop-downs, overdue alerts, a weighted pipeline, and when to move to a CRM.

_Source: https://professionalstoolkit.com/articles/sales-tracking-spreadsheet — The Professional's Toolkit · updated November 2026_

---

A **sales tracking spreadsheet** is one table where every open deal gets a row: who it is with, which stage it has reached, what it is worth, and the next step with a date. Built in Google Sheets or Excel, it works as a free pipeline for a founder or a small sales team. The method is short. Lock the stage column to a drop-down list, color any row whose next-step date has passed, and total the value by stage with a pivot table. It holds up well for one or two sellers. It starts to fail when several people edit it every day.


**1 row = 1 deal** — Every open deal gets one row with a stage, a value and a dated next step



- **5-6 stages** — Named for what the buyer has done
- **14 columns** — Enough to run a pipeline, no more
- **Weekly** — Review sorted by next-step date


## What a sales tracking spreadsheet needs to hold

Start with the columns, not the colors. Each row is one deal, not one contact, because a customer can buy twice and each purchase moves through the pipeline on its own. Keep a single header row and no merged cells. Google says each column of a pivot table's source data needs a header [1], and summaries break quickly on messy layouts. Then use the fourteen columns below and add more only when a real question needs one.

1. **A to D:** Deal, Company, Contact, Owner (the person responsible for the next move).
2. **E to H:** Stage, Value, Probability, Weighted value.
3. **I to L:** Next step, Next step date, Last contact, Expected close date.
4. **M and N:** Source (referral, website, event) and Lost reason.

Define five or six stages that describe what the buyer has done, not what you hope will happen. A simple set is Lead, Qualified, Proposal sent, Negotiation, Won and Lost. Put them on a second tab called Stages, with a win probability next to each one. If you are unsure where one stage ends and the next begins, our guide to the [sales pipeline and its stages](/articles/sales-pipeline) covers the definitions and how a pipeline differs from a funnel.


> 💡 **Keep stages on their own tab:** Point the drop-down and the probability lookup at one Stages tab, so renaming a stage or changing a probability happens in one place.


## How to set up sales tracking in Google Sheets

Everything here uses features built into Google Sheets. Column letters follow the layout above, with headers in row 1 and the first deal in row 2.

1. **Build the Stages tab.** Type the stage names in column A and their probabilities in column B.
2. **Add the stage drop-down.** Select the cells in column E, then click Insert, then Dropdown (or Data, then Data validation, then Add rule). Under Criteria, choose Dropdown from a range and select the stage names on the Stages tab [2]. Anything typed that is not on the list is rejected, unless you switch the rule to Show a warning under Advanced options.
3. **Fill the probability.** In G2, enter `=VLOOKUP(E2,Stages!A:B,2,FALSE)` and copy it down. In H2, enter `=F2*G2` for the weighted value.
4. **Flag overdue next steps.** Select A2:N200, click Format, then Conditional formatting. Under Format cells if, choose Custom formula is, enter `=AND(ISNUMBER($J2),$J2<TODAY())`, pick a red fill and click Done [3]. The whole row turns red once its next-step date has passed.
5. **Summarize by stage.** Select the data, click Insert, then Pivot table. In the side panel, add Stage under Rows and Value and Weighted value under Values.

Write the conditional formatting formula for the first row of the range. Sheets applies it to every row below, and the dollar sign keeps the check pinned to column J.

## Building a sales tracking Excel template

Excel gets you to the same place with slightly different menus.

1. **Make the deals list a table.** Type the headers, click any cell in the range and press Ctrl+T.
2. **Make the stage list a table too.** Microsoft notes that when a drop-down's source sits in a table, the drop-down updates by itself as you add or remove items [4].
3. **Add the drop-down.** Select the Stage cells, go to the Data tab, then Data Validation. On the Settings tab, set Allow to List, click in Source and select the stage names without the header. Keep In-cell dropdown checked. The Error Alert tab sets the message people see when they type something that is not on the list.
4. **Reuse the formulas.** The same VLOOKUP and multiplication work in Excel without changes.
5. **Add the summary.** Select the data, choose Insert, then PivotTable, pick New Worksheet and click OK. Then place Stage in rows and Value in values from the field list.

One quirk worth knowing. If Data Validation is grayed out, Microsoft says the worksheet might be protected or shared. Unprotect it or stop sharing, add the rule, then share it again.


> 💡 **Track the next step, not the last:** A dated next step tells you what to do today; a last-contact date only tells you what already happened.


## A worked example: a 20-deal sales pipeline template

Here is an illustration with round, invented numbers. A consultant has 20 open deals spread across four stages, with probabilities set on the Stages tab.

| Stage | Deals | Total value | Probability | Weighted value |
|---|---|---|---|---|
| Lead | 8 | 40,000 | 10% | 4,000 |
| Qualified | 6 | 30,000 | 25% | 7,500 |
| Proposal sent | 4 | 24,000 | 50% | 12,000 |
| Negotiation | 2 | 16,000 | 75% | 12,000 |
| **Total** | **20** | **110,000** | | **35,500** |

The headline figure of 110,000 is what the pipeline would bring if every deal closed. That will not happen. The weighted total of 35,500 is the sober estimate. Notice where it comes from: the two deals in Negotiation carry as much weight as the four proposals, and the eight leads add only 4,000. **The money sits in the late stages**, so that is where this week's follow-ups belong.

The probabilities are guesses at first. After a few months, replace them with your own numbers. Count how many deals that reached Proposal sent were won, and divide by the total that reached it. Your sheet holds the evidence if lost deals stay in it with a reason and you note the last stage each deal reached before it closed.

## Habits that keep the sheet honest

A spreadsheet only knows what someone typed. Most tracking sheets fail from neglect, not from a bad template. These are the common mistakes.

- **Stages that drift.** A deal sits in Proposal sent for two months because nobody wanted to mark it lost. Set a rule: no reply after three attempts means Lost, with a reason.
- **Rows without a next step.** A deal with an empty column J is a deal nobody is working. Fill it or close it.
- **Notes that overwrite.** Typing over the last note erases the history. Add a dated line instead.
- **Column creep.** Every new column is one more cell people skip. Fourteen is plenty.

Run a weekly review. Sort by next-step date, work the red rows first, and update every stage before you look at the pivot table. Twenty minutes a week keeps the totals close to the truth.


> ⚠ **Do not delete lost deals:** Mark them Lost with a reason instead. Deleted rows take your win rates and your lost-deal patterns with them.


## Where the free sales tracking spreadsheet stops

The sheet works for one seller, and usually for two. It breaks in predictable places as the team grows.

- **Shared editing collides.** Two reps update the same row, or one sorts the sheet while another is typing. Rows end up attached to the wrong deal.
- **There is no activity history.** A cell holds whatever was typed last. You cannot see every call and email on a deal in order.
- **Reminders do not fire.** The red row only appears when someone opens the sheet. Nothing pings the owner.
- **Email and calls are not logged.** Every conversation has to be copied in by hand, so most never are.
- **Access is all or nothing.** Unless you set up protection, anyone who can edit can change any row, including another rep's deal values.

The practical threshold is clear. Move when a third person edits the sheet every day, when open deals no longer fit on one screen, or when a deal slips because nobody opened the file that week. At that point a CRM keeps the same stages and adds history, reminders and owners. Pipedrive [is built around a pipeline of deals you move through your own stages](/articles/what-is-pipedrive), which maps directly onto the Stage column. Zoho CRM's Standard edition [covers pipelines, email and calling for a first CRM after a spreadsheet](/articles/zoho-crm-review), and its Free edition serves up to 3 users.


### Pipedrive — solves this

Deals sit in a pipeline you move left to right through stages you define, the same job as the Stage column, with contacts, activities and a calendar underneath on every plan.

- Where it stops: No free plan, only a trial; forecast reports start on Growth.
- Plan: Lite (pipeline); Growth (forecast reports)
- How Pipedrive does it: [Setting up your Pipedrive pipeline](https://professionalstoolkit.com/articles/pipedrive-tutorial)
- More: [Pipedrive](https://professionalstoolkit.com/tools/pipedrive)



### Zoho CRM — solves this

The Free edition gives a small team a simple pipeline with tasks, calls and meetings on each record, and a workflow rule updates fields when a deal closes.

- Where it stops: Free is for up to 3 users with standard reports only; multiple pipelines and sales forecasting need Standard.
- Plan: Free (pipeline); Standard (multiple pipelines, forecasting)
- How Zoho CRM does it: [What each Zoho edition covers](https://professionalstoolkit.com/articles/zoho-crm-review)
- More: [Zoho CRM](https://professionalstoolkit.com/tools/zoho-crm)



### HubSpot — solves this

Deal pipelines are on the Free plan; when you import the spreadsheet, each deal needs a name, a pipeline and a stage that already exists, so set up your stages first.

- Where it stops: Free is for up to 2 users; forecasting and custom reports need Professional.
- Plan: Free (deal pipelines); Professional (forecasting, custom reports)
- How HubSpot does it: [What HubSpot includes by plan](https://professionalstoolkit.com/articles/hubspot-review)
- More: [HubSpot](https://professionalstoolkit.com/tools/hubspot)


For the full picture, including how forecasting, multiple pipelines and reporting compare, see our guide to [sales pipeline management tools](/articles/sales-pipeline-management).


## FAQ

**Is Google Sheets or Excel better for sales tracking?**

Both handle drop-downs, conditional formatting and pivot tables with built-in features. Pick the one your team already opens every day, since a pipeline nobody opens is the real failure.

**How do I track sales per rep in the spreadsheet?**

Fill the Owner column on every row, then add Owner to the pivot table's rows next to Stage. Each rep sees their own pipeline and weighted value without a second sheet.

**What probability should each pipeline stage get?**

Start with a rough guess that rises with each stage, then replace it after a few months with your own rate: deals won divided by deals that reached that stage.

**How do I move a sales pipeline template into a CRM?**

Clean the stage names so each matches a stage in the CRM, keep one row per deal, and export the sheet as a CSV. HubSpot, for example, needs a deal name, a pipeline and a stage that already exists before a deal will import.


## The bottom line

A sales tracking spreadsheet is the right first pipeline: one row per deal, a locked stage list, a dated next step that turns red when missed, and a pivot table that weights value by stage. Google Sheets and Excel both do all of it with built-in features. Keep lost deals in it, review it weekly, and it will teach you your real win rates. Once several people edit it daily or follow-ups slip because nobody opened the file, move the same stages into a CRM.



## Sources

[1] Google Docs Editors Help — https://support.google.com/docs/answer/1272900 (Nov 2026)
[2] Google Docs Editors Help — https://support.google.com/docs/answer/186103 (Nov 2026)
[3] Google Docs Editors Help — https://support.google.com/docs/answer/78413 (Nov 2026)
[4] Microsoft Support — https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b (Nov 2026)