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

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.

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 covers the definitions and how a pipeline differs from a funnel.

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.

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.

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.

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, which maps directly onto the Stage column. Zoho CRM's Standard edition covers pipelines, email and calling for a first CRM after a spreadsheet, and its Free edition serves up to 3 users.

For the full picture, including how forecasting, multiple pipelines and reporting compare, see our guide to sales pipeline management tools.

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.