UAT Test Case Template (Excel & CSV)

A free user acceptance testing template you can use today: one row per test step with the action, test data, expected and actual result, a Pass / Fail / Blocked dropdown, evidence links, and a sign-off sheet for the business owner. It comes with a filled-in example, so you can see how a real test case reads.

  • Columns: Test Case ID, Scenario, Preconditions, Step, Action, Test Data, Expected Result, Actual Result, Status, Evidence, Tester, Date, Comments
  • Status dropdown (Pass, Fail, Blocked, Not run) that colours itself green, red or amber
  • A filled-in example: refunding an order, with one failed step and the defect noted
  • Sign-off sheet: release, environment, counts, overall result, tester and business owner approval
  • A "How to use" sheet with the rules most UAT teams follow
  • CSV version with the same columns, ready for TestRail or Jira (Xray, Zephyr) import

How it works

  1. Download the Excel or CSV template
  2. Write one row per step: the action, the test data and the expected result
  3. Run the test, fill in the actual result and pick Pass, Fail or Blocked
  4. Link a screenshot as evidence, then get the sign-off sheet approved

Try it with

  • Refund a paid order in the admin panel
  • New customer sign-up with email verification
  • Submit a purchase order for approval
  • Change a user's role and check their access

Frequently asked questions

What should a UAT test case include?

A test case ID, the scenario being tested, preconditions, and for each step: the action, any test data, the expected result, the actual result and a status (Pass, Fail, Blocked or Not run). Add evidence (a screenshot), who tested it and when, and a sign-off by the business owner.

What is the difference between a test case and a test script?

People use the words loosely. A test case usually describes what to check and the expected outcome; a test script is the step-by-step instructions to run it. This template combines both: one row per step, grouped by test case ID.

Can I use it in Google Sheets?

Yes. Open Google Sheets → File → Import → Upload, and choose the .xlsx file. The Pass/Fail dropdown and the colours carry over.

Can I import it into TestRail or Jira?

Yes. Use the CSV version: one row per step with the same columns. TestRail's CSV import and Jira test tools such as Xray and Zephyr can map these columns.

Is there a faster way than filling in a spreadsheet?

Yes. Record your screen while you run the test once at aiflowchart.io/uat-test-evidence. AI Flowchart writes each step's action and expected result, keeps the screenshot of every step as evidence, and gives you Pass/Fail, a sign-off block, a PDF and the same CSV. It's free to try.

Related tools

Try AI Flowchart free →