Analyze Usability Test Results with Excel

One of the challenges in running usability tests is analyzing the data so as to obtain meaningful results — especially if you can’t afford or don’t need to use full-featured professional software.

Fortunately, Userfocus has released Usability Test Data Logger v3.0 — a sophisticated (but not overly complex) Excel spreadsheet which allows you to:

Measure task completion rates, analyse questionnaire data, and summarise participant comments. It even includes a timer so you can measure time-on-task.

Most importantly, it’s free to use, is completely customizable and captures quantitative and qualitative data for up to 20 participants performing up to 20 tasks.

It also comes with a 27 page manual so you’re not left guessing as to how to make it work.