QA Test Case Template Pack

Test case template for Excel and Google Sheets, with a live dashboard

One ready-made workbook to plan, write, run and report tests: a test case template, bug report template, live execution dashboard, test plan, traceability matrix and regression checklist. No macros, no add-ons, no sign-up.

Buy on Gumroad, $9 See a free sample

$9 one-time · instant download · secure checkout through Gumroad

QA Test Case Template Pack cover: test case template, bug report template, execution dashboard and regression checklist
At a glance

QA Test Case Template Pack

  • 11 sheets
  • No macros
  • Excel
  • Google Sheets
  • LibreOffice
  • Test case and bug report templates with dropdowns and a status workflow
  • Live test execution dashboard with charts that update automatically
  • One-page test plan, traceability matrix (RTM) and a 49-item regression checklist
  • 30 example test cases, CSV versions, and Quick Start and Google Sheets guides (PDF)

$9 one-time · instant download

Buy on Gumroad, $9

Secure checkout through Gumroad · TestLinkPro never sees your card details · instant download · no account needed. How buying works

What’s inside

One test case template workbook, 11 sheets

Everything a tester needs to plan, write, run and report tests. Frozen headers, filters, dropdowns, colour coding and print-ready layouts are already set up, and every column and dropdown value can be edited.

SheetWhat it does
InstructionsHow to use each sheet, in plain language.
Test CasesThe test case template: 17 columns, with dropdowns for status (Pass / Fail / Blocked / Not Run), priority, severity and test type, plus colour-coded results.
Bug ReportsEnvironment, build, steps to reproduce, expected vs actual, severity, priority, reproducibility, attachments, linked test case and requirement, and a 10-step status workflow.
DashboardLive counts of Pass / Fail / Blocked / Not Run, pass rate, execution progress, a breakdown by priority, bug counts by severity, and charts. Pick any test sheet from a dropdown and everything updates.
Test PlanA one-page plan: objective, scope, approach, environments, entry/exit criteria, roles, schedule, risks, deliverables and sign-off, with guidance text in every field.
Traceability Matrix (RTM)List your requirements; test counts, pass/fail/blocked counts and coverage status (“Not Covered”, “Covered - Failing”…) are calculated from your test cases.
Regression Checklist49 ready-made release checks across authentication, forms, payments, permissions, cross-browser, mobile, performance, security, accessibility, API and deployment, with an automatic “Release ready?” summary.
EX - Login Page10 filled example test cases for a login page.
EX - Checkout Flow10 filled example test cases for an e-commerce checkout flow.
EX - REST API10 filled example test cases for a REST API endpoint.
EX - Bug ReportsExample bug reports that match the failing example tests.

CSV import files

CSV versions of the templates and examples, laid out for import into test management tools (TestRail, Zephyr and Xray-style fields) and issue trackers (Jira-style fields).

Quick Start Guide (PDF)

A 5-minute guide to the workbook, so you can start writing test cases the same day.

Google Sheets Guide (PDF)

How to open, convert and share the workbook in Google Sheets. Dropdowns, colours and formulas carry over.

Free sample

Preview the test case template

These are the first three of the 30 example test cases, copied from the “EX - Login Page” sheet (some columns hidden here to fit the page). The example data is fictional.

IDTitleStepsTest dataExpected resultActual resultStatusBug ID
TC-LOGIN-001Login succeeds with valid email and password
  1. Open the login page.
  2. Enter a valid registered email.
  3. Enter the correct password.
  4. Click 'Sign in'.
Email: qa.user01@example.com
Password: Valid#Pass123		User is redirected to the dashboard. Username is shown in the header. Session cookie is set.As expected.Pass–
TC-LOGIN-002Login fails with wrong password and shows a generic error
  1. Open the login page.
  2. Enter a valid registered email.
  3. Enter an incorrect password.
  4. Click 'Sign in'.
Email: qa.user01@example.com
Password: WrongPass!1		Error 'Invalid email or password' is shown. User stays on login page. Message does not reveal which field is wrong.As expected.Pass–
TC-LOGIN-003Login fails for an unregistered email
  1. Open the login page.
  2. Enter an unregistered email.
  3. Enter any password.
  4. Click 'Sign in'.
Email: not.registered@example.com
Password: AnyPass#1		Same generic error as wrong password ('Invalid email or password') to prevent account enumeration.Error shown: 'No account found for this email'. Reveals that the email is not registered.FailBUG-101

TC-LOGIN-003 fails on purpose: the error message reveals that the email isn’t registered (an account enumeration risk). It links to example bug report BUG-101, which links back to the test case and to requirement REQ-AUTH-002, so the RTM and dashboard pick it up.

All 17 test case columns

The same columns are used in the workbook and in the CSV import file.

  • Test Case ID
  • Module / Feature
  • Test Title
  • Test Type
  • Preconditions
  • Test Steps
  • Test Data
  • Expected Result
  • Actual Result
  • Status
  • Priority
  • Severity
  • Tester
  • Execution Date
  • Requirement ID
  • Bug ID
  • Notes

Pass rate vs execution progress

The dashboard shows two numbers that are often mixed up:

  • Pass rate = Passed ÷ Executed. How good is what you’ve tested so far?
  • Execution progress = Executed ÷ Planned. How much have you actually tested?

A 90% pass rate with 30% progress tells you very little. Blocked tests are not counted as executed, because they hide risk.

From the regression checklist

  • Login with valid credentials works
  • Login with invalid credentials shows a generic error
  • Logout ends the session (Back button does not restore it)
  • Password reset email is received and link works once
  • Sign-up / registration completes and confirmation email arrives

The first 5 of the 49 checks (Authentication).

Test execution dashboard with pass, fail, blocked and not run counts, pass rate, execution progress and charts
The live test execution dashboard.
Test case template sheet with example login test cases, colour-coded status and dropdowns
The test case sheet with colour-coded status.
How it works

From download to your first test run

  1. Open the workbook

    Open the .xlsx in Excel, or upload it to Google Drive and choose File → Save as Google Sheets. LibreOffice Calc works too.

  2. Learn from the examples

    Read the quick start and look through the 30 example test cases to see the level of detail to aim for, then hide the example sheets.

  3. Write, run and report

    Write your own test cases, log bugs, and pick your test sheet on the dashboard. Counts, charts and RTM coverage update as you go.

Who it’s for

Built for people who test software

  • Manual and automation testers who want a clean, consistent way to document tests.
  • Junior QA engineers who want to learn what complete test cases and bug reports look like.
  • Small dev teams and startups without a paid test management tool.
  • Freelance QA testers who need professional deliverables for clients.
  • Developers who have to “do the testing too” and want a structure that works.

Why a spreadsheet?

A test case template in Excel or Google Sheets needs no licences, no sign-up and no setup time. Everyone on the team can open it, and the CSV files make it easy to move into a test management tool later if you outgrow it.

Want a release checklist too? See the Release Readiness & QA Checklist Pack, or get every pack in the bundle.

Kamran Ghaffar

Built by Kamran Ghaffar, a Quality Assurance professional with 10+ years of experience in software quality, test automation and QA leadership.

FAQ

Questions about the QA Test Case Template Pack

Which apps does it work with?

Microsoft Excel 2010 or newer (Windows/Mac/web), Google Sheets and LibreOffice Calc. No macros or add-ons are needed.

How do I use it in Google Sheets?

Upload the .xlsx to Google Drive, open it, then choose File → Save as Google Sheets. Dropdowns, colours and formulas carry over. The included Google Sheets Guide walks through it step by step.

Can I import the test cases into Jira, TestRail or another tool?

Yes. CSV files are included with column names that map easily in most CSV importers. You’ll map the columns to your tool’s fields on its import screen.

Can I use it for client work or at my company?

Yes. You can use it for your own projects, your employer and your clients. You just can’t resell or redistribute the template files themselves (see LICENSE.txt in the download).

Is it beginner-friendly?

Yes. Every sheet has short instructions, the Test Plan has guidance text in each field, and the 30 example test cases show the level of detail to aim for.

How do I get my files?

Right after you pay, Gumroad shows your download link on screen and emails you a receipt with the same link.

Do I get updates?

Major updates or new versions of the pack may be released as a separate paid upgrade.

Works well with

Each pack stands on its own. Together they cover writing tests, working faster with AI, shipping releases and preparing for your next role. Compare all packs.

Get the QA Test Case Template Pack

$9 one-time. Instant download from Gumroad, no account needed. Questions first? Email hello@testlinkpro.com.

Buy on Gumroad, $9