Upload and Prep SurveyGizmo Data

Data Prep Tips

Splits Required – This software's multiple choice answers in one column instead of a separate column for each answer. In order for your counts to be correct, we will have to split these answers into their own column. For these question types, you will need to use the Split Action in the Prep Data step. This software separates these answers by a comma so you will need to do Actions then Split and enter a comma as the delimiter. Make sure your answer options do not have any commas in the actual answer or else it will mess up your workflow and you may have to start over. If your answer does have a comma go to your Excel file and remove any commas that are not delimiters for the answer options. 

Zip Code Question Type - If you asked any open-ended or single one type question asking for a Zip Code then select the Zip Code Question Type and the dashboard will show a Map instead of a list of Zip Codes.

New Question # – Each New Question #  will be a separate question/chart in the dashboard. Most question types will have 1 column per question but some question types such as Multiple Choice, Matrix and Ranking will have multiple columns for one question. In this case, you will have to group all of those columns together by giving it the same New Question #.

*If you would like a more in-depth explanation about the Prep process then watch the Upload and Prep Other Survey Software's Data video to see the logic behind it all. If you still are having problems please reach out to support.

Question Type Crosswalk

Video Time SurveyGizmo   VizualSurvey New Question # Notes
7:25 Textbox   Textbox Single
7:30 Your Contact Address:    Textbox or Zip Code
Single Each of the columns will be its own New Question #. If you want to show a map for the Zip Code then you will have to select that question type for the Zip Code column.
9:30 Radio Buttons     Single Response Single  
10:30 Dropdown Menu Single Response Single
10:45 Email   Textbox
10:55 Date
Date Single  
11:06 Slider List Single Response Matrix or Numeric or Single Response Single or Grouped If you want these to show up in one chart as a matrix then you will need to group the columns together by giving it the same New Question # and selecting Single Response Matrix. If you want statistics and averages fro each of the options then you will need to select Numeric and give a separate number for each column. If you want to show a separate bar chart for each answer then you will select Single Response and give each column its own New Question #.
13:05 Checkbox Grid   Multiple Choice Matrix Grouped
15:40 Checkboxes Multiple Choice Grouped
16:10 Radio Button Grid Single Response Matrix Grouped
16:50 Star Rating Grid   Matrix of Dropdown Menu Grouped
17:20 Drag & Drop Ranking   Ranking Grouped
17:45 Ranking Grid   Ranking
18:35 Rating (Likert Scale)   Single Response Single  
19:00 Percent
Numeric Single
19:17 Image (select one)   Single Response Single
19:30 Image (multi-select)   Multiple Choice
20:17 Dropdown Menu List Single Response Matrix Grouped
20:52 Textbox List Textbox Single or Grouped Can group them or have them as separate New Question #
21:30 Continuous Sum Numeric Single Each answer will have its own New Question #
22:15 Dropdown Menu Grid Matrix of Dropdown Menu Grouped
22:45 Textbox Grid Matrix of Dropdown Menu Grouped
23:25 Net Promoter Score Net Promoter Score Single
23:50 Essay / Long Answer Text Box Single
24:00 Slider Single Response or Numeric Single
24:23 Number Numeric Single
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us