Excel is not a documentation or testing tool

I have seen this coming up in multiple places and wanted to make my own comment. While Excel and spreadsheets in general are fine tools, they are NOT documentation or testing tools.

I know it's become the norm to create test cases and even test plans and publish them as spreadsheets so they are easily shared. But to be honest, it pains me to no end.

Excel is fine for making a basic checklist, or listing ticket numbers associated with a project and handing it over to the client to or to someone in the business so they can check the progress at a glance, but using it to store API data, SQL queries, write elaborate steps that someone should follow to perform an action, color coding dozens of columns, creating dozens of sheets filled to the gills with test permutations, or using it to backlog tickets, sends me into a terrible frenzy.

Simply put, there are far better tools out there for handling that kind of data, they are called Task Managers. If you need more than that, look for a Project Management tool.

I use Excel or rather LibreOffice to create a summary list of what I am working on for the client. But it's not something I actually work from. I use 2Do to create my own task list and keep track of my progress. I use DevonThink to track requirements documents, credentials and page links for my own personal benefit. I use Jira and Confluence for bug tracking and sharing test information.

I have seen too many cases where everything is stuffed into Excel because that's the tool someone has available and the only tool they know how to use. There are dozens of tabs filled with color coded data, lines going in all directions, screenshots plastered all over the place, and all sorts of bug descriptions.

To this I say no. It's a terrible idea. Bugs should be tracked in the correct bug tracking tool, whether that is Jira or something else. Screenshots need to be attached to the ticket or the requirements document. Simply put, the correct data should be listed in the correct place, not stuffed into an Excel spreadsheet someone made.

It also leads to the problem of data hoarding. It's far to easy to store everything inside a spreadsheet in a way that only makes sense to you, that is stored in a folder on your machine, that isn't shared and takes multiple steps to make available to someone else.

I'm a huge fan of Excel. I used to support it. It can do marvelous things. But just because it can, doesn't mean it should.

I have run into far too many spreadsheets that are stuffed to the gills with data that isn't listed anywhere else. The bugs aren't being tracked correctly. The testing data is locked away where other team members can't get to it. And in a recent case, so much crap was hoarded in spreadsheets, that not only are there dozens of them that don't make any sense, but dozens of them weren't actually shared after said person left. We are literally missing documentation because it was more important to be in control and use Google Drive than to share test data in a meaningful way with the rest of the team.

Yes, some of that is a personnel problem, but in my opinion, there is too much reliance and emphasis on using Excel as a testing tool. It can be used for a lot of things, and it has a lot of convenience, but I have a hard time believing spreadsheets are the best way to share testing information with team members.

Other articles of interest:

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments
  • Round and Round with the For..Next in Katalon Studio (1)
    • Sweet Ophaline Labador: Hello can you help me how to loop this scenario. Checking the elements is just the same. I want to check that the following function is available in www.siacargo.com: Track Shipment – clicking on this can...
  • How To Disable the Quicken Registration Prompt (30)
    • David: A BIG Thank you! I regularly reinstall Windows OS’s using different hardware configs. In short, Quicken 2011 (it’s March of 2020 as I write this) has been a program I’ve been very happy with and continue to use....
    • Karen L: Today I rang Reckon Australia again, got a different guy and he talked me through the process of getting me a new product key to enter since I already had the licence and it had been extended. Reckon have only extended it by 1...
    • Karen L: I have Australian Quicken 2008 on Windows 8.1. It keeps asking me to renew my licence which Reckon did for me however the activation won’t work. I tried this to disable the registration prompt however it did not stop the...
  • Parsing Strings in Katalon – Split, Substring and Readlines (6)
    • Don Pedro: String tempText=”Date Month January. Revenue $1,355,721.00″ println(tempText.split(“ \$”)[1]) You need to escape the $ with \$ The [1] on the split captures characters on the right of the split [0]...
    • Prasad: Hi, I need to get the substring from the below string ‘Date Month January. Revenue $1,355,721.00’ I want to extract text after $ value. Please help Thank you
  • Working with Dates and Date Formatting in Katalon Studio (15)
    • Sangeethaa: How to get previous day’s date(Yesterday’s date)? Actually I was using today.previous() before,it was working fine till today morning.Now its not retrieving right date. Can anyone please guide me on this.
    • Don Pedro: That could be a little tricky. First, is the text/format always going to be the same? You will need to do some parsing. Separate the first but of text at 2019. After that, split the text again to get rid of Central Standard...
    • Don Pedro: It should be of the same Date type as today. You could then do some calendar trickery with Calendar /*Calendar c = Calendar.getInstance(); //c.set(Calendar.MONTH, 1) //Set the month, 0=January, 11=December println...
    • josh: I’m testing a page with a string like “Updated November 21, 2019 16:25:32 PM Central Standard Time.” How might I capture the date and time and compare it to current time to verify that the update time was within...
    • zakir hussain: today = new Date() lastWeek = (today – 1.week) can u please help me in understanding what is the return type of lastweek? and I wanted to set nextyear date how can i do it
  • Output status messages and test information by writing to the Log File Viewer in Katalon Studio (6)
    • Saranya: Good One. Could you plz share link to access all your katalon related blogs. ThankQ
    • Rodrigo Calabretta: I’m using the KeywordUtil.markFailed or KeywordUtil.markError and my test stops is being shown as Error and If I use in the @afterTestCase the testCaseContext.getTestCaseSta tus() to show the status test case...
  • Setting up Environment Profiles in Katalon Studio (2)
    • Don Pedro: Not quite sure I understand. The term “Execution Profile” is normally used now, but they are still GlobalVariables and are created in the same way for version 7 as previous. You make a new execution profile, then...
  • Here is my drive cluster (2)
    • Don Pedro: While I still have those drives, the drive cluster looks nothing like that now. Almost all of my external drives have had the cases removed and they have been installed into a series of MediaSonic 8 Bay Drive Enclosures. I...