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
- Download the Excel or CSV template
- Write one row per step: the action, the test data and the expected result
- Run the test, fill in the actual result and pick Pass, Fail or Blocked
- 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.