Test management in Excel is hell

September 13, 2016
test management excel

It is time to wake up! Using Excel to coordinate and report on testing activities can be very annoying, inefficient, time-consuming and sometimes frustrating. It often happens that you lose the overview, so that you no longer know where you are in the testing process. How can I ensure that I do get an overview? How can I link actions to multiple users involved in the test cycle? And how can I work even more efficiently by not constantly reinventing the wheel and reusing test cases?

Research on test maturity

Testersuite has done research on the test maturity of companies using SAP during the last VNSG congress. Over 100 visitors have completed a questionnaire. The results of the research give an interesting picture of how testing works with SAP users. In this blog we look at the complexity that arises when you use Excel for test management.

Does this sound familiar?

  • You have too many folders and documents managed in spreadsheets;
  • It takes a lot of time to update all the spreadsheets, so a lot of effort for testing is lost;
  • Test cases and defects get lost because there are too many e-mails with attachments and spreadsheets going back and forth. As a result, the overview is lost;
  • You are constantly working in multiple documents and adapting information, because the information is not stored centrally. This is time-consuming and inefficient.

Lack of overview due to test management in Excel!

However, the most striking result of the survey is the use of test tools. For example, half of those questioned indicated that they record defects in Excel instead of a user-friendly, centrally available solution. A good example of a user-friendly, free cloud solution for recording and handling test findings is Defectsuite.

A package such as SAP is so complex and extensive that the number of Excel (and/or Word) test scripts quickly adds up to hundreds of individual files. These files are then stored on a network drive. Although 57% of the interviewees indicated that they reuse the scripts, the people involved undoubtedly have a hard time with this. The loose files are distributed by e-mail, the completed test scripts are returned.

A major disadvantage here is the lack of overview, which means that insight into the progress and test coverage takes a long time.

Any defects are collected via e-mail or entered directly into a joint Excel list by the testers. Moreover, the executed test scripts also need to be saved, for example for IT audits. This cumbersome way of working explains why 66% indicate that they spend too much time on test execution.

Try Testersuite for free now!

The success of Testersuite is largely due to the ease with which the user is guided through the various test phases. Do you want to start working with a user-friendly test management tool that brings structured and pragmatic testing within reach? Then start directly with Testersuite FREE or PRO.

Powerful modules support the entire testing process. Testersuite supports the management of products and requirements, the design and execution of tests and the recording and management of test results. Testersuite makes testing easy! The implementation is fast; within one day an Testersuite environment is fully set up and the organisation knows how to work with it. Do you want to know how Testersuite works before you start with FREE or PRO? Ask for an online demo.

Get started now

And discover our user-friendly cloud products
Testersuite uses cookies. Please indicate which cookies you accept. See our Privacy Statement for more information.