Upload and Prep QuestionPro Data Overview


Data Prep Tips

Important: You must delete the first 2 rows of the CSV file when you export the data from QuestionPro before uploading the data to VizualSurvey. These 2 rows are just summary info which you do not need.

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 #.

Double Column Headers – QuestionPro data export has 2 headers which are not an ideal format. VizualSurvey accounts for this by loading the first row as the header if there is a value there otherwise it will grab the second row. It will do this automatically when you upload the data so there is nothing you will have to do. There will be an additional cleaning step for this in the next step.

*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 QuestionPro VizualSurvey New Question # Notes
5:45 Multiple Choice - Select One Single Response Single  
7:45 Multiple Choice - Select Many Multiple Choice Grouped  
5:45 Drop-down Single Response
Single Acts the same as QuestionPro's Multiple Choice - Select One question type. Just give it a new number and select Single Response as the question type.
4:33 Comment Box Textbox Single Acts the same as QuestionPro's Contact Information question type. Just give it a new number and select Textbox as the question type.
4:33 Single Row Text Textbox Single Acts the same as QuestionPro's Contact Information question type. Just give it a new number and select Textbox as the question type.
4:33 Email Address  Textbox Single Acts the same as QuestionPro's Contact Information question type. Just give it a new number and select Textbox as the question type.
4:33 Contact Information  Textbox Single Even though they are in the same question you will need to give each column a separate New Question number. This will make it so each column will be its own question.
8:35 Star Rating Single Response Matrix Grouped  
5:45 Thumbs Up/Down Single Response Single Acts the same as QuestionPro's Multiple Choice - Select One question type. Just give it a new number and select Single Response as the question type.
9:05 Text Slider Single Response Matrix Grouped  
9:23 Numeric Slider Numeric Single Even though they are in the same question you will need to give each column a separate New Question number. This will make it so each column will be its own question.
5:45 Image Chooser - Select One Single Response Single Acts the same as QuestionPro's Multiple Choice - Select One question type. Just give it a new number and select Single Response as the question type.
10:44 Image Chooser - Select Many Multiple Choice Grouped
11:20 Image Chooser - Rating Ranking Grouped
12:14 Rank Order Ranking Grouped
12:40 Constant Sum Numeric Single Even though they are in the same question you will need to give each column a separate New Question number. This will make it so each column will be its own question.
13:30 Drag and Drop Ranking Ranking Grouped
13:55 Matrix Multi-Point Scales  Single Response Matrix Grouped
14:23 Matrix Multi-Select Multiple Choice Matrix Grouped You will mix of questions and answers in your Column name field, just give all of them the same New Question number and we will clean it in the next step.
4:33 Date/Calendar Date Single Acts the same as QuestionPro's Contact Information question type. Just give it a new number and select Date as the question type.
5:45 Other Option* Textbox Single If you use the other option you will need to give that column its own New Question # even though it is part of the