English

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
October 21, 2018
English

LinkedIn Post – Survey Monkey and Google Forms Excel Data Format

In Survey Monkey website, there is an example of Survey Monkey survey raw data exported to Excel, a copy can be downloaded here. As mentioned in previous post, question with multiple answer is the main reason you can not use Pivot Table, notice that question with multiple answers are separated into multiple column, the common survey data format in Excel. Had the survey been conducted using Google Forms, the format would’ve looked like a file in my comment. Notice the difference. So if you are using other online survey platform, you need to rearrange the Excel data to follow that of Google Forms in order for Splitter to analyze.

The link post on LinkedIn here.

Comments Off on LinkedIn Post – Survey Monkey and Google Forms Excel Data Format
October 21, 2018
English

Comparison Survey Data Format in Excel : Survey Monkey to Google Forms

Here we have example of raw survey data (individual responses) from Survey Monkey and the same data in Google Forms format. Survey monkey data download here, in Google Forms format download here. If you have survey data from Survey Monkey or other online survey platform and wants to do in-depth analysis using spreadsheet, you’d want to convert it to Google Forms format first and then run Splitter.

Comments Off on Comparison Survey Data Format in Excel : Survey Monkey to Google Forms
August 21, 2018