With our Question Import tool, you can import up to 100 questions at once from a spreadsheet. If you are familiar with using Microsoft Excel or Google Sheets and you can write out your questions faster using those programs, we welcome you to do so! We recommend starting from our template file to have a general layout to follow, but you can create your own from scratch with your program of choice.
This article will guide you through using Google Sheets to import questions into your Experience. Microsoft Excel will also work, as will just about any modern spreadsheet program. As long as you follow the layout and export your spreadsheet as a .CSV file, you can write your questions in practically any program you like.
When writing your questions in a spreadsheet, each question must go on a separate row. Column 1 should be the question itself. The entire question must be in the cell - do not spread it out across multiple rows or columns. You can adjust the width and/or height of each cell to make longer questions easier to read.
Column 2 should be the code for which type of question you want to include. You can set this to any type of question we offer: Multiple-Choice, Text-Answer or Numerical-Answer. You can also use Like or Dislike and Yes or No questions for Polls. Enter the appropriate code for each question in your file.
Question Type Codes
|Like or Dislike (Polls only)||likeDislike|
|Yes or No (Polls only)||yesNo|
Column 3 and onward will all become your answers. You can include up to 50 answers for Multiple-Choice questions. For Multiple-Choice Trivia questions, be sure to put the correct answer first in each row. That answer will be marked as correct, then shuffled in with the rest of that question's answers.
Setting up the row like this...
...will make a question like this!
For Text- and Numerical-Answer Trivia Questions, you can include up to 10 Correct Answers. They will be included in the Correct Answer(s) section under your question.
|...will look like this after importing.|
Exporting to a .CSV File
Now that your questions have all been written, it's time to export your spreadsheet. Crowdpurr only accepts .CSV files through our import tool. It is a universal format which any modern spreadsheet program is able to reproduce.
In Google Sheets, go to the File dropdown menu and select Download. Select Comma-separated values (.csv, current sheet) from that menu. Your spreadsheet will download to wherever your downloads go by default, likely onto your desktop or your Downloads folder.
Importing Your Questions
On the dark blue Question(s) Setup tab, click on the gray Question Tools tab to open the Question Tools panel. Click on the Import Questions button. This will bring up the Import Questions dialog.
Question Tools Panel
Click the Import Questions button and select the .CSV file you exported from your spreadsheet program. After a few moments, your new questions will finish uploading, and your Experience will be ready to start!
Please note that this will reset your experience and delete all existing questions and answers in your experience. If you need to save your questions or crowd responses, consider cloning the experience beforehand and importing into the clone instead. You can also export your crowd activity to save it onto your device.
Check out these articles for more information about the topics covered here: