Skip to main content

Upload

You can compile your quiz questions and answers into a CSV file offline, and then import the file to PuzzleMe. The file must have the extension .quiz.csv . You can use any spreadsheet software like Google Sheets or Microsoft Excel to create the CSV file. Click here to download a reference CSV file.

The first row of CSV file contains the headers for each column (Question, Explanation etc). Please note that the headers are case sensitive, and should not be modified. Each row of the CSV file contains an entry for a question.

  • For free form questions, please enter the answer only in the column "Option 1".
  • For multiple choice questions, it is mandatory to specify the correct option in the "Correct Answer" column.
  • The Score, Explanation, Media and Tags fields are optional.
  • Do not change the order of the columns. Please do not delete a column, even if all the rows for that column are empty.

File name

Your file must be named in the following way: [filename].quiz.csv
If the filename does not end in .quiz.csv, the dashboard will not be able to parse it.

Data format

The platform expects the uploaded file to have the following structure:

QuestionMediaOption 1Option 2Option 3Option 4TagsCorrect Answer IndexExplanationScore
Some Question TextabcdEnglish2Here's a sample explanation. This question is worth 2 points.2
Another Question TextwxyzEnglish,Algebra1Here's a sample explanation. This question is worth 1 point.1
  1. The columns Media, Tag, Explanation and Score are optional.
  2. Question: The text that will be displayed for that question.
  3. Media: Any media URL (image, video, audio) that you'd like to embed with the question.
  4. Option 1/2/3/4: These are the options presented during the quiz. PuzzleMe also supports free-form answers. For this, you can specify all the correct answers under Option 1, where each answer is separated by a semicolon, and the Correct Answer Index is blank. To see an implementation, refer to the example file available on the dashboard.
  5. Tags: These are tags to describe the question. This is only for internal use, and the end-user does not see this. You can add comma-separated values in this field.
  6. Correct Answer Index: For a multiple-choice question, this is the index [1,2,3, or 4] of the right answer. For instance, if Option 1 is the right answer, then this field should have the value 1. For free-form answers, this field must be left blank!
  7. Explanation: The text that will be displayed to the user after they answer the question.
  8. Score: Different weighted scores can be given to questions, depending on the importance of the questions. Default score is 10.