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.
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.
| ID | Title | Steps | Test data | Expected result | Actual result | Status | Bug ID |
|---|---|---|---|---|---|---|---|
| TC-LOGIN-001 | Login succeeds with valid email and password |
| 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-002 | Login fails with wrong password and shows a generic error |
| 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-003 | Login fails for an unregistered email |
| 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. | Fail | BUG-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.