Create Your Quiz By Excel

  • HOME
  • Create Your Quiz By Excel

You can create quizzes using spreadsheet software such as Microsoft Excel & Google Spreadsheets.

1. Download the Excel Format

Click the button below and save. Edit the saved file, create the quiz for your needs, “save as” / “save”

quiz_format.xlsx

2. Create Your Quiz

    • Enter #format: table in row 1 & column A. Without this description, it will not work properly.
      A B C D E
      #format:table
    • If you want to use other options, enter in the 2nd row and 3rd row, column A for each option.
      A B C D E
      #format:table
      #shuffle_questions:true
    • Enter the quiz text in column A after the option row, the quiz type determining the word in column B, the correct answer choice in column C, and the wrong choice in column D and so on.
      A B C D E
      #format:table
      #shuffle_questions:true
      QuizSentence Word to specify the Quiz type Choice 1 Choice 2 Choice 3
      Combine the country and its capital. match: Italy :: Rome Japan Tokyo China :: Beijing
    • If you do not use a word that determines the problem type, enter the correct answers in column B and the incorrect answers in column C and later.
      A B C D E
      #format:table
      #shuffle_questions:true
      QuizSentence Correct Incorrect Incorrect Incorrect
      E.g)Where is prefactural city of Hyogo pref? Kobe city Himeji city Tatsuno city Akashi city
    • If you break the line, it would be as the next quiz
      A B C D E
      #format:table
      #shuffle_questions:true
      QuizSentence 1 Correct Incorrect Incorrect Incorrect
      QuizSentence 2 Correct Incorrect Incorrect Incorrect
    • The end result is similar to the Excel form of each quiz type.
A B C D E
#format:table
#shuffle_questions:true
Where is prefactural city of Hyogo pref? Kobe city Himeji city Tatsuno city Akashi city
Combine the country and its captal city match: Italy :: Rome Japan Tokyo China :: Beijing
  • After you complete creating the quiz, please save the data.
  • Please have a look “Quiz generation manual”.

3.Convert a File

Please upload the file you created earlier from the form below. Once the upload is done, the converted file will be downloaded.

4. Unzip/Upload

Extract the downloaded file and open index.html in it to start the quiz player. If you want to get the embedding tag of IFrame and the quiz URL, please upload the downloaded file as it is from the “Uploader“.