Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesProject & Task ManagementAgile & ScrumTest Case Tracker

SpreadsheetAgile & ScrumFree

Test Case Tracker

Test cases with steps, expected result, pass or fail by run, linked defects and pass rate by module.

Shown with sample data

Colour

Test Case Tracker

Test cases with steps, expected result, pass or fail by run, linked defects and pass rate by module.

Pass rate
60%
Of cases run
Failed
2
Not run or blocked
3
Critical failures
1
Entries by priority
  • High3
  • Critical2
  • Medium2
  • Low1
Share of entries by priority
  • High338%
  • Critical225%
  • Medium225%
  • Low113%

How to use it

  1. 1Write one case per behaviour, with clear expected results.
  2. 2Set priority so critical cases run first.
  3. 3Record the result and defect ID after each run.
  4. 4Re-run failed cases once the fix is deployed.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Test what matters and know what has passed. Write each case with its steps and expected result, record the outcome and any defect raised; the tracker shows the pass rate overall and by module and lists what still needs running before release.

Who it’s for

  • User acceptance testing
  • Regression suites
  • Go-live sign-off evidence

What’s included

  • Test cases sheet: One row per test case.
  • Summary by Priority sheet: The number of entries for each priority, calculated from the Test cases sheet.

How to use it

  1. 1Write one case per behaviour, with clear expected results.
  2. 2Set priority so critical cases run first.
  3. 3Record the result and defect ID after each run.
  4. 4Re-run failed cases once the fix is deployed.
Related searchestest case templateqa trackertest planuat testingsoftware testing

Details

Format
Spreadsheet
Category
Agile & Scrum
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAgile & ScrumFree

Test Case Tracker

Test cases with steps, expected result, pass or fail by run, linked defects and pass rate by module.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Agile & Scrum
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More agile & scrum templates

View all
Sprint Backlog4 sheets

Committed

44

Done

15

Sprint progress

34%

ABCD
1StoryTypeEpicAssignee
2As a user I can reset my password by emailStoryAccountsAna
3Show order history with filtersStoryOrdersBen
4Checkout fails on expired cardBugPaymentsChen
5Upgrade logging libraryTech debtPlatformDee
Backlog
SpreadsheetAgile & Scrum

Sprint Backlog

User stories with points and status, a live burndown against the ideal line, and velocity from past sprints.

10 min setupPreview
Bug Tracker2 sheets

Open bugs

5

Open critical

1

SLA breached

4

ABCD
1TitleSeverityEnvironmentSteps to reproduce
2Checkout fails when card has expiredCriticalProductionAdd item, pay with expired test card
3Order history filter ignores date rangeMajorProductionFilter orders by last 30 days
4Typo on pricing pageTrivialProductionOpen /pricing
5Search is slow on large cataloguesMajorProductionSearch with 10,000+ products
Bugs
SpreadsheetAgile & Scrum

Bug Tracker

Bugs with severity, environment, owner and status, plus age, SLA breaches and time to resolve.

10 min setupPreview

Sprint Retrospective: Sprint 14

Date: Date · Facilitator: Name · Team: Team name

Sprint facts

Committed pointsCompleted pointsBugs found
31243

Last retro's actions

  • •Action: Done / Not done

What went well

  • •Item
  • •Item
DocumentAgile & Scrum

Sprint Retrospective

Run a focused retro: what went well, what to improve and owned actions.

15 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ