Free Issue Tracker Template (Excel + Google Sheets)
What's in the issue tracker template
The workbook has two tabs. The Issue Log lists each issue once - ID, date reported, description, priority (High/Medium/Low), status (Open/In Progress/Closed) and owner - across up to 150 rows.
Two columns calculate automatically per row: Days Open (today's date minus the date reported) and an Overdue flag, which reads OVERDUE once an issue has been open more than 7 days and isn't Closed. Both use only TODAY() and IF - no macros.
The Dashboard tab lets you type any owner's name to see their open and total issue counts, and rolls up totals for open, in-progress, closed and overdue issues, plus a high-priority-open count, using COUNTIF and COUNTIFS.
Logging issues: priority, status, and owner
Each row is one issue. Priority and Status are dropdown lists so entries stay consistent, and conditional formatting highlights OVERDUE issues in red and Closed issues in green as soon as you fill in the row.
There's no cap that forces you into a second sheet for more issues - 150 rows is enough for most single-project or single-team logs; if you outgrow it, copy the sheet's formulas down further rows.
Tracking resolution time and overdue issues
Days Open updates every time you open the file, since it's driven by TODAY() rather than a fixed snapshot - so you always see current aging without recalculating anything by hand.
The Overdue flag gives you a single column to filter or sort on when triaging a long list, instead of mentally comparing today's date against every row's reported date.
Who this template is for
Small teams and technical PMs who want a lightweight issue log without standing up a full ticketing tool - useful for a single project, a client engagement, or internal QA tracking.
If you need swimlanes, automations, or multi-team routing, a dedicated tool like Jira makes more sense; this file is built for a straightforward spreadsheet log with the aging and rollup math already done for you.
How to use it
- Log each issue once on the Issue Log sheet: date reported, description, priority, status and owner.
- Watch the Days Open and Overdue columns update automatically - no formulas to touch.
- Type an owner's name on the Dashboard sheet to see their counts, and check the summary block for totals by status and priority.
Download the free Free Issue Tracker Template (Excel + Google Sheets)
No spam — template updates and new free templates only. Unsubscribe anytime.
CRM & Sales Pipeline Tracker
If your issues are really client deals moving through stages, the paid CRM & Sales Pipeline Tracker ($14) gives you stage-to-stage conversion, a 3-scenario forecast and stale-deal alerts.
See the full versionFrequently asked questions
How does the Overdue flag work?
A row reads OVERDUE once it has been open more than 7 days (today's date minus date reported) and its Status is not Closed. Set Status to Closed to clear the flag.
Can I track more than 150 issues?
The Issue Log ships with 150 rows. You can extend it by copying the formulas in the Days Open and Overdue columns down into additional rows.
Does the Dashboard update automatically?
Yes. Type any owner's name into the Dashboard sheet and their open/total issue counts calculate immediately via COUNTIFS against the Issue Log. The summary block below tallies totals across all issues by status and priority.
Do I need to sign up to download this?
No. It's a direct .xlsx download with no email gate.
Can I use this in Google Sheets?
Yes. Upload the file to Google Drive, open it, and choose File > Save as Google Sheets - all formulas and dropdowns keep working.