LinkedIn Post – Splitter Handles Survey Monkey Data

In previous post, Survey Monkey survey data in Excel is rearranged to follow Google Forms format to allow Splitter to do deep dive. One of Splitter key function is to handle question with multiple answers. It splits multiple values/contents in a cell by splitting it into its individual value/content. Google Forms uses comma sign to separate each answer in multiple answer question. And since we also use comma the same way in writing, ie to separate clauses/items (I like the brand because price is cheap, good build quality, large screen, upgradable OS, long battery life), Splitter can be used to analyze open end question.

The link post on LinkedIn here.

Comments Off on LinkedIn Post – Splitter Handles Survey Monkey Data

LinkedIn Post – Google Forms + Splitter

Question with multiple answers is the main reason why Pivot Table can not be used to analyze survey data in Excel. Common data format in Excel is to separate the multiple answers into multiple columns, requiring complicated formula for calculation, if Excel is used for analysis at all. Google Forms data format is unique and much simpler actually, that it put all answers for a question into one column whether it is a single answer or multiple answers. We have developed Splitter, an Excel add in program, that works just like pivot table to analyze survey data in Excel with format following that of Google Forms.

The post link on LinkedIn here.

Comments Off on LinkedIn Post – Google Forms + Splitter