Test case template (Excel and Google Sheets)

Copy the columns into Excel or Google Sheets

Paste into cell A1, then use Data → Split text to columns (Sheets) or Data → Text to Columns (Excel), comma-separated.

ID,Area,Title,Preconditions,Steps,Expected result,Priority,Type,Automated?,Last result,Last run,Notes

A filled-in example

Four rules for test cases

1. One behaviour per test case. If the title needs "and", split it.
2. Preconditions describe the starting state so anyone can run it.
3. Expected results are observable: what you see, not "works correctly".
4. Link failing runs to the bug issue so history is traceable.

Six starter test cases

"TC-001","Account","Sign up with a new email","Logged out; email not registered","1. Open sign-up
2. Enter email + password
3. Submit","Account created; welcome screen; verification email arrives","High"
"TC-002","Account","Sign up with an existing email","Email already registered","1. Open sign-up
2. Enter the existing email
3. Submit","Clear error, no account created, no email enumeration beyond policy","Medium"
"TC-003","Account","Log in with correct details","Account exists","1. Open login
2. Enter correct details
3. Submit","Lands on dashboard; session persists after refresh","High"
"TC-004","Account","Log in with wrong password","Account exists","1. Enter wrong password 3 times","Generic error; rate limit or lockout per policy","High"
"TC-005","Account","Password reset link used twice","Reset email requested","1. Open reset link, set new password
2. Open the same link again","Second use rejected with a clear message","Medium"
"TC-006","Account","Log out everywhere","Logged in on two browsers","1. In browser A, choose ""log out of all sessions""
2. Refresh browser B","Browser B is logged out","Medium"

Record the video part

When a test case fails, a short recording of the run makes the bug report unambiguous. Bobbin is a free Chrome extension that records your screen, a window or a tab with your microphone and an optional webcam bubble. No account, no watermark, no time limit, and nothing is uploaded: the file stays on your computer.

1. Click the Bobbin icon in Chrome's toolbar and choose Record screen, window or tab.
2. Pick your microphone and turn on the camera if you want the webcam bubble.
3. Press Start recording, choose what to share in Chrome's picker, and wait for the 3-second countdown.
4. Pause with Alt+Shift+P, stop with Alt+Shift+S, then press Download to save the file.

To keep other tabs and notifications out of it, share just the Chrome tab (the webcam bubble appears only in screen and window recordings). Bobbin saves MP4 where your browser supports it (Chrome 126 or newer), WebM otherwise, and tells you which it used.

File size: our 60-minute 1080p test came to about 246 MB (roughly 4 MB a minute) on a simple synthetic screen; busy real screens can be larger, so a 1–2 minute clip is usually small enough to attach.