A test case template is a sheet with one row per check and a column for each thing a tester needs: the steps, the expected result and the result of the last run. This builder gives you an Excel workbook with one tab for each kind of testing you choose, with worked examples and blank rows.
How to use it#
- Tick the tabs you want: Smoke, Sanity, Regression, Integration and Functional. All five start ticked.
- Each choice shows the columns its tab has, with how many worked examples and blank rows it holds.
- Select Download .xlsx.
The workbook opens with a How to use tab: what each column is for, the status values to use, and a note that the examples are a starting point. Each template tab then has its header row, worked examples for an example online shop, and blank rows for your own tests. Steps are written one numbered action per line, and the cells wrap so they read as lines.
Which template to use#
| Template | What its rows check | When to run it | Its own columns |
|---|---|---|---|
| Smoke | The most important paths work at all | On every new build, first | Area |
| Sanity | One fix or small change, and what sits next to it | When a build carries that change | Change checked |
| Regression | Features that already worked still do | Before every release | Priority, Last run |
| Integration | Your app and another system agree | When either side changes | Systems, Test data |
| Functional | A feature does what its requirement says | When the feature is built or changed | Requirement |
Every tab also has ID, Steps, Expected result and Status. Each template's page shows its worked examples and explains its columns. Types of software tests covers these five and the kinds a sheet does not suit, such as unit and end-to-end tests.
Making it yours#
Replace the examples with your own app's, keep the IDs unique, and set Status as you go: Not run, Passed, Failed or Blocked. Add a column if your team needs one, such as a build number or a link to the bug. The template does not know your app, so it cannot tell you what to cover.
Questions#
What columns does a test case template need?#
An ID, the steps, an expected result you can check and a status. The five tabs add what their kind of testing needs, such as a priority for regression or the requirement for functional.
Is the template free?#
Yes. Download it without an account and use it however you like.
Does it open in Google Sheets?#
Yes. The file is a standard .xlsx that Excel, Google Sheets, LibreOffice and Numbers open.
Will it cover my whole app?#
No. It is a starting point with examples; adapt the rows to your app.
Why do the examples mention an online shop?#
They show what a well-written row looks like for a familiar kind of app. Replace them with your own.