I'm trying to find way to tabulate the results of an open card sorting exercise. We have about 50 cards total and need to pair that down so I'm hoping to crunch the numbers in excel to see where there was high/low agreement between cards.

I've found a couple of spreadsheets that do other forms of analysis, but none that do the matrix. Does anyone know where I could find one?

  • 1
    I generally just use the one built into OptimalSort, but I know Donna Spencer has a Card Sort Analysis Excel template available in the resources for her book (I'm not entirely sure it contains a similarity matrix).
    – Kit Grose
    Feb 26, 2015 at 22:19
  • 1
    I had looked at Donna Spencer's template, but it didn't include a matrix. I searched a little more and it turns out, somebody made a matrix that reads data from Donna's template.
    – MCTaylor17
    Feb 27, 2015 at 19:50
  • NOTE: If you use the matrix in the link I posted above, please be aware that Sheet10 points at Sort1 rather than Sort10. Ask if that doesn't make sense.
    – MCTaylor17
    Mar 2, 2015 at 23:35

1 Answer 1


built to work with Donna Spencer's spreadsheet


  • 3
    Could you expand on this a bit. As it is it's slightly cryptic. Furthermore could you copy and paste the relevant information into your answer?
    – Mayo
    Jan 31, 2018 at 4:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.