This Test Plan Template (Excel) is intended for the testing of software and information systems.  It is useful to prepare the Test Plan well ahead of testing and should be reviewed by the project or product manager, as well as others who have gathered the requirements.

The Test Plan Template contains separate tabs for each set of features to be tested.  Each row in a tab is a test case to be performed, and has a place to document the Expected Result as well as the Actual Result.  The Status of each row should be populated with “Pass” or “Fail” upon completion of the test case.  This will automatically highlight the row green or red.  Test data used in each test case should also be recorded in the test case row for future reference.  For any test case that fails, the details of the error or failure should be recorded in the Comments column.

Since the test plan template is built in Excel, the Overview tab is able to automatically calculate the number of cases Passed, Failed, and Remaining, as well as percentages for each.  The “Test Summary” at the top of each tab is also automatically calculated and does not need any manual editing.  The change log, reference material, overview, etc is also maintained on the Overview tab.