Download your OptimalSort results as spreadsheets

You can download your OptimalSort results as spreadsheets. 

Note: Numbers on Mac doesn't support the file format, so use an alternative program (such as Google Docs or Open Office).

Uncut data

The spreadsheets will contain results from all participants, regardless of your filtering or segmenting. It doesn't matter if a participant abandoned the survey before finishing, or if you've excluded them from your data — every action they took will be included on these spreadsheets. The uncut data will also not reflect any standardized categories you've created. 

Filtered data

The spreadsheets will reflect any filtering or segmenting you've performed in your results. Therefore, the results of participants who abandoned your survey, or who you've excluded from your results, won't be included. The spreadsheets will also reflect any standardized categories you've created.

If you've segmented your participants (by selecting only a portion of participants and then reloading your results) the spreadsheets will reflect this.

For example, you may only want to download a spreadsheet containing data from a particular demographic. You would select these results on the Participants table, reload your results, and then download the filtered spreadsheet. 

You can download the following data.

  • Raw data 
  • Participant data
  • Standardized data
  • Similarity Matrix data
  • SynCaps data (for cluster analysis software)

You can also download the Card Sort Analysis Spreadsheet, which is based on the work of Donna Spencer. You can use it to standardize and analyze your data manually.  

Here's a video from a few years ago with a general introduction to how the spreadsheet works, and how to use it to standardize categories. Since it was made, we've updated how the spreadsheet looks, and we've enabled you to standardize categories in the platform itself.  

Introduction to the OptimalSort Analysis Spreadsheet from Optimal Workshop on Vimeo.