This video shows the fastest and simplest way to code open ended survey responses using MS Excel. You can purchase the time-saving spreadsheet at www.oneyeardissertation.com/time-saving-products, but this video will show you how to do it without the purchase as well. Other qualitative data analysis platforms are expensive, difficult to use, and do not provide as valuable of an end result. This video will show everything starting with taking data from survey platform data pulls (i.e. Qualtrics, Survey Monkey, Google Forms, etc.), how to code comments from respondents, and how to efficiently transform the coded data into a presentable table format. Most importantly, this video shows how to save a great deal of time, up to half of the time required to complete qualitative data analysis, by using a simple spreadsheet. The end result is an APA formatted table in a fraction of the time. This technique is useful for students, researchers, marketing professionals, survey professionals, or anyone who has comments from open-ended survey questions that they need to analyze. This technique will also work for unique applications such as coding comments to blog posts, Facebook, YouTube, etc.
