In my 15 years in the field of user experience, I’ve analyzed a lot of user research and usability testing data. For most of that time, I’ve typed up and organized my notes in spreadsheets. I find a spreadsheet to be an ideal format for research notes, because it allows me to list participants in each column and tasks, problems, and themes across rows.
On larger projects, when analyzing data with a group of people, I…