Over the past few years I have been slowly developing and refining a spreadsheet I use for analysis of card sorts. I have used it on many projects and find it invaluable for helping me manage the data and spot patterns.
I use it to analyse results from open card sorts. I have refined it to the point where I’m happy with it, and have prepared instructions for it. The instructions and spreadsheet are completely free for you to use however you wish.
There are two files:
- Card sort analysis spreadsheet instructions (PDF, 2MB)
- Card sort analysis spreadsheet template for 40 participants (ZIP, 2MB)
Card sorting book
To learn about how to conduct a card sort, check out my book on card sorting.