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 four files available:
- Card sort analysis spreadsheet instructions (PDF, 715KB)
- Word file to use as a template for labels (DOC, 46KB)
- Empty card sort analysis spreadsheet template for 40 participants (ZIP, 1MB)
Card sorting book
And check out my book on card sorting.