TestFinch

Test case template for Excel

Pick smoke, sanity, regression, integration or functional, and download one Excel file with a tab each.

Loading the tool

FlowQA's agent explores your site and writes cases like this one as tests, keeping each only once it has passed twice and failed on a deliberately broken page. Free to start.

Try FlowQA free

The manual case

SMK-02 A registered user can sign in

  1. Open Sign in
  2. Enter a test account's email and password
  3. Select Sign in

Expected: the account page opens with the user's name.

The FlowQA test

account/sign-in

  1. navigate "/sign-in"
  2. fill "Email" with "mia@acme.example"
  3. fill "Password" with "••••••••"
  4. tap button "Sign in"
  5. assert url matches "/account"
  6. assert text "Mia Chen" is visible

An illustration with sample data.

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#

  1. Tick the tabs you want: Smoke, Sanity, Regression, Integration and Functional. All five start ticked.
  2. Each choice shows the columns its tab has, with how many worked examples and blank rows it holds.
  3. 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.