With the 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, you can write out your questions faster using those programs, and 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 template 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.
Questions
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
Multiple Choice | multipleChoice |
Text Answer | text |
Numerical Answer | numerical |
Like or Dislike (Polls only) | likeDislike |
Yes or No (Polls only) | yesNo |
Question Points
Column 3 allows you to include a per-question Point Value through the import. Custom Point Values should be between 1 and 1,000 points per question. For Polls, this column will be ignored, but it must still be included as a column on the spreadsheet for the import process to work properly.
Question Time
Column 4 allows you to set unique Question Timer durations for each of your questions, similar to the per-question Point Values in Column 3. You can set each question to any amount of time between 1 second and 61 minutes.
Question Media URL
Column 5 allows you to paste in a Question Media URL such as an image link address or YouTube video URL to display alongside the question.
If you prefer to upload your own image or embed a YouTube video to questions directly on the platform, you're welcome to leave this column blank to later select your desired Question Media after importing the spreadsheet.
Question Note
Column 6 allows you to add in a Question Note and also allows you to add in HTML code to customize your text within the spreadsheet. If you're familiar with HTML and want to add basic HTML formats to your Question Note while editing the spreadsheet, feel free to type text formatting code directly onto the cell.
If you prefer to stylize your Question Note using Crowdpurr's built-in rich text editor, you're welcome to leave this column blank to later add in your Question Notes after importing the spreadsheet. Please visit the following Help Center article: Question Notes Explained.
Correct Answer(s)
Column 7 allows you to set the Correct Answer(s) for your questions. If you don't wish to include a correct answer for a particular question, simply leave that cell blank.
If you would like to include more than one correct answer, simply type all the correct answers into the same cell, separated by@@@. Our import tool will then create a separate answer for each one.
Setting up the row like this...
...will make a question like this!
Answers
Columns 8 and onward will all become your answers. You can include up to 100 answer options for Multiple Choice questions. For Multiple Choice trivia questions, any correct answers from Column 4 will be 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.
These rows...
![]() |
![]() |
...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 that 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 light blue Questions 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 the spreadsheet into the clone instead. You can also export your Crowd Activity to save it onto your device.
What's next?
Check out these articles for more information about the topics covered here:
Comments
0 comments
Article is closed for comments.