Create a quiz in Excel

Create a quiz in Excel

Microsoft Excel and Google Spreadsheet are available.

1. Download the format

Click on the button below to save the file. After editting the file, overwrite and save it.

Japanese: format　　　　English: format

2. Create a quiz

• • Add#format:tablein column A. If this description is missing, it will not work properly.
    

    column A	column B	column C	column D	column E
    #format:table

  • To add other options in column A. Enter them in line 2, 3 or more if desire.
    

    column A	column B	column C	column D	column E
    #format:table
    #shuffle_questions:true

  • Enter a Quiz sentence in column A following the options, a Quiz format in B, a correct answer in C, and incorrect answers in D and beyond.
    

    column A	column B	column C	column D	column E
    #format:table
    #shuffle_questions:true
    Quiz sentence	Quiz format	Correct answer	Incorrect answer 1	Incorrect answer 2
    Dry ice is the solid form of	sa:	Carbon dioxide	Oxygen	Nitrogen

  • If you start a new line, it will be recognized as the next quiz.
    

    column A	column B	column C	column D	column E
    #format:table
    #shuffle_questions:true
    Dry ice is the solid form of	sa:	Carbon dioxide	Oxygen	Nitrogen
    What is the capital city in Japan?	sa:	Tokyo	Osaka	Osaka

    When you add all quizzes, save the file.

    3. Convert

    Upload the file you have created.
    After uploading, the converted file will be downloaded.
    
    

    4. Unzip/upload the file

    Unzip the downloaded file and open index.html to launch the quiz player. To get the URL of the quiz /IFrame to embed, use theUploader
    

    FAQ

    • It does not work to create a quiz in a CSV file.