Skip to content
The title slide and first slides of the Bug Tracker template

Bug Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Style
Bold
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

The Bug Tracker gives a development or support team one list of software bugs. Each row records the bug, its component, severity, reporter, assignee and status, along with the dates it was opened and closed. Days open shows how long a bug has been waiting. The Dashboard counts open bugs by severity and by status, so critical problems are seen first.

It comes with sample data for a web product with mobile and billing parts. Make a copy and replace the sample rows. The formulas, dropdowns and charts update on their own.

Useful for

  • Tracking defects found in testing before a release
  • Logging bugs reported by customers through support
  • Reviewing the bug queue at a weekly triage meeting

What's included

  • 3 tabs: Dashboard, Bugs, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Bugs: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Bugs tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this Bug Tracker template free?

Yes. Make a copy in Google Sheets or download the .xlsx file for Excel. There is no charge for the template.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Excel. The formulas, dropdowns and charts work there as well as in Google Sheets.

What does severity mean in this template?

Severity describes the impact on users. Critical means users cannot complete an important task, Major means a significant problem with a workaround, Minor means a small problem and Cosmetic means a visual issue only.

  • #bug-report
  • #bug-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bug report templates

See all 5

Also in Developer workflows

All developer workflows templates
Get this template

Preparing your template…