loadSurveyMonkeyXLS: Read an XLS format export from SurveyMonkey.

In wmurphyrd/monkeywrangler: Read, Summarize, and Visualize results from SurveyMonkey surveys

Description

Parse an XLS-format exported file from SurveyMonkey into a data frame. The function attempts to deduce the format of each survey question (e.g. multiple versus single response) from patterns in the headers and the responses in the file.

Usage

loadSurveyMonkeyXLS(fname, idcols = 1:9)

Arguments

fname	Character vector of length 1 pointing to file location.
idcols	Numeric vector identifying columns in the data to be treated as respondent identifiers as opposed to question responses.

Details

To obtain the proper file from SurveyMonkey, request a data export of "all responses" and choose the XLS format (not XLS+).

Value

an object of class SurveyQuestion that inherits from data.frame. The data is in long form wherein each row respresents a single selection from the with the corresponding question named in the question column and the selected or entered value in the response column. The columns specified in the idcols argument will appear in data as well as a unique questionId, question format type, and subgroup within a survey question where appropriate. Methods are available for summary and plot for the entire survey or for single questions retrieved via extractQuestion.

See Also

SurveyQuestion, extractQuestion, plot.SurveyQuestion, summary.SurveyQuestion

wmurphyrd/monkeywrangler documentation built on May 4, 2019, 9:46 a.m.