Yes, an Excel template for a sales tracker is a pre-built spreadsheet that logs your deals, customers, and revenue so you can see performance at a glance. You can download one from Microsoft’s template gallery or build your own in about ten minutes with a table, a few formulas, and a pivot chart.
What a Sales Tracker Template Actually Does
A sales tracker is a working log, not a static report. At its core, it stores one row per sale or opportunity, with columns for the date, customer name, product or service, quantity, unit price, and total. From that raw data, the template calculates totals, counts deals, and often adds a simple dashboard with charts. The value is that you stop digging through emails or notebooks and instead have one file that answers “how much did we sell this month?” in seconds.
Most templates also include a stage column for pipeline tracking (e.g., “Lead,” “Quote,” “Closed Won”), which turns the tracker into a lightweight CRM. You can filter by stage to see which deals are still open and which ones converted. This is useful for a solo freelancer, a small retail shop, or a sales team that does not need a full CRM system.
Key Components of a Good Template
Not all templates are equal. A solid one has these parts:
- Data entry sheet: A plain table with headers like Date, Customer, Product, Quantity, Unit Price, Total, and Status.
- Calculated columns: A Total column using a formula like
=E2*F2(quantity times unit price) so you never add numbers by hand. - Summary area: Cells that show total revenue, number of deals, and average deal size using SUM, COUNTA, and AVERAGE.
- Filters or slicers: A filter row or slicer so you can view only one month, one salesperson, or one product line.
- Chart or pivot table: A monthly revenue bar chart or a pivot table that groups sales by product or by rep.
If a template lacks the calculated Total column, you can add it yourself. With headers in row 1 and data starting in row 2, click cell G2 (assuming A–F are your first six columns) and type =E2*F2. Then drag the fill handle down to copy the formula.
How to Build a Simple Tracker from Scratch
Building your own is often better than downloading because you control the columns. Here is the shortest path:
- Open a blank workbook. In row 1, type headers: Date, Customer, Product, Quantity, Unit Price, Total, Status.
- Select row 1 and press Ctrl+T (Mac: Cmd+T) to turn the range into a table. This gives you automatic filters and structured references.
- In the Total column (G2), enter
=[@Quantity]*[@Unit Price]. Excel fills the whole column. - Below the table, add summary formulas. For total revenue, use
=SUM(Table1[Total]). For deal count, use=COUNTA(Table1[Customer]). - Insert a pivot table: select the table, go to Insert > PivotTable, and drag Date into Rows and Total into Values. Then group the date field by month (right-click a date in the pivot, choose Group, then Months).
This takes about five minutes and gives you a tracker that updates as you add rows. The table’s structured references mean you never have to adjust formula ranges.
Where to Find Free Templates
Microsoft offers a built-in gallery. In Excel, go to File > New and type “sales tracker” in the search box. You will see options like “Sales Report” and “Sales Pipeline.” These are free and work with Excel for Microsoft 365. Another reliable source is the Microsoft Create website (create.microsoft.com), which has templates for sales tracking, lead tracking, and monthly sales reports. Avoid random third-party download sites that may bundle macros or ask for personal data.
If you download a template with macros (.xlsm), be aware that macros can contain code. Only enable macros if you trust the source. To check what a macro does, press Alt+F11 to open the VBA editor and review the modules before running anything.
Common Problems and Fixes
The most frequent issue is a Total column that shows 0 or #VALUE!. That usually means the Quantity or Unit Price cells contain text, not numbers. Select those columns, go to Home > Number, and change the format to Number. Another common problem is that the pivot table does not show new rows after you add them. The fix is to make sure your source data is an Excel Table (not a plain range) before creating the pivot; then refresh with right-click > Refresh.
A third issue is that the template’s formulas break when you delete a row. If you use a Table, Excel handles that automatically. If you are using a plain range, convert it to a Table first (Ctrl+T) to avoid broken references.
Comparing Excel to Google Sheets or a CRM
Excel templates are free and offline, but they have limits. If you need multiple people to enter data at the same time, Google Sheets is easier because it is collaborative by default. In Sheets, you can use the same layout and formulas, but the table feature is called “Alternating colors” (Format > Alternating colors) and the shortcut is Ctrl+Shift+L for filters. For serious pipeline management with stages, owners, and activity history, a dedicated CRM like HubSpot (free tier) or a simple Airtable base is more robust. Excel is best when you want a single source of truth that you control, without learning a new platform.
Costs and Safety Considerations
Excel templates are free if you have a Microsoft 365 subscription (which includes Excel). The desktop version costs about $10 per month as part of Microsoft 365 Personal, or you can use the free Excel for the web at office.com, though some features like pivot charts are limited. There is no extra cost for templates.
For safety, keep your tracker on OneDrive or SharePoint so you have version history. If you share it, use a protected sheet (Review > Protect Sheet) so others cannot accidentally delete formulas. Never store sensitive customer payment data in a plain Excel file; if you must, encrypt it with a password (File > Info > Protect Workbook > Encrypt with Password). For financial figures, double-check that your formulas use absolute references where needed, and always test with a known total before relying on it.
Frequently Asked Questions
Can I track sales by month automatically? Yes. Add a helper column with the formula =TEXT(A2,"mmm yyyy") (assuming Date is in A2) to extract the month text, then use that column in a pivot table or SUMIFS. For example, =SUMIFS(Table1[Total],Table1[Month],"Jan 2025") works if you have a Month column.
What if I need to track commissions too? Add a Commission Rate column (as a decimal like 0.10) and a Commission column with =[@Total]*[@Commission Rate]. Then sum that column separately. This is a common add-on and does not require a new template.
Can I use a sales tracker on my phone? Yes, the Excel mobile app opens the same file. The desktop formulas and tables work on mobile, but editing is easier on a computer. Excel for the web also works in a phone browser, though the interface is cramped.
Why does my pivot table show blanks instead of zero sales for a month? Pivot tables hide empty periods by default. Right-click a date in the pivot, choose Field Settings, then Layout & Print, and check “Show items with no data.” That will display months with zero sales.
Is it better to track sales in Excel or a CRM? If you have fewer than a few hundred deals a year and you are the only user, Excel is faster to set up and free. If you have a team, need contact history, or want automated email sequences, a CRM is worth the learning curve.
Related
- Excel Show Weekday for Date: 4 Easy Ways
- Excel Sheet for Attendance: How to Make One
- Excel Sheet for Employee Schedule: How to Build One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Daily Attendance Register Template Excel: Setup and TipsA daily attendance register in Excel is a worksheet that lists people down the rows, dates across the…
- Forward Google Sheets: What Happens When You Share?If you forward a Google Sheets link, the recipient can open the spreadsheet only if its sharing permissions…
- Extract Data from Google Maps to Excel: Practical OptionsYou can move location data into Excel, but Google Maps does not provide a general-purpose button to export…
- RSVP List Template Excel: Build and Track Guest RepliesYes—an RSVP list template in Excel can track each guest, invitation, reply, and party size in one worksheet.…
- Free Home Budget Spreadsheet: Set Up a Simple Excel PlanYes—you can make a free home budget spreadsheet in a blank Excel workbook, or adapt a free template…
- Protect an Excel Sheet Without Locking Cells: How It WorksYes. In Excel for Microsoft 365 on Windows, unlock the cells people should be able to edit, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.