Free QA resource

Test case template example

A clear test case format you can copy into Excel or Google Sheets today: ID, title, steps, test data, expected and actual result, status and bug ID. When the spreadsheet stops scaling, import it into TestLinkPro.

Free example

Example: three login-page test cases

Three example test cases for a login page, in the column format most QA teams use. The example data is fictional.

Three example test cases for a login page
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).

Import your spreadsheet into TestLinkPro

TestLinkPro imports test cases from Excel and CSV, then gives your team test runs with evidence, traceability and reports. Free for up to 5 users, paid plans from $19 a month.