Create quizzes in Excel

  • HOME
  • Create quizzes in Excel

Create quizzes in Excel

You can use spreadsheet software such as Microsoft Excel or Google Spreadsheet to create your quiz.

1. download the Excel format

Click on the button below to save the file. Edit this page, describe the quiz you want to create and overwrite/save as.

quiz_format.xlsx

2. create a problem

    • Row 1, column A.#format:tableinput. If this description is missing, it will not work correctly.
      column A column B column C column D column E
      #format:table
    • If you want to use other options, you can enter them in column A of lines 2 and 3 for each option.
      column A column B column C column D column E
      #format:table
      #shuffle_questions:true
    • After you have finished entering the options, enter the question text in column A, the word to determine the question type in column B, the correct answer in column C, and the wrong answer in column D and onwards in the row following the last option.
      column A column B column C column D column E
      #format:table
      #shuffle_questions:true
      problematical statement Word to determine the problem format Option 1 Option 2 Option 3
      Example: Combine the state and the capital. match: Italy::Rome Japan::Tokyo China::Beijing
    • If you do not use a word to determine the question type, enter the correct answer in column B and the wrong answer in column C and onwards.
      column A column B column C column D column E column F
      #format:table
      #shuffle_questions:true
      problematical statement problem format correct answer mistaken answer or response mistaken answer or response mistaken answer or response
      Example: What is the capital of Hyogo Prefecture? sa: Kobe City Himeji City Tatsuno City Akashi City
    • If you start a new line, it will be recognized as the next problem.
      column A column B column C column D column E
      #format:table
      #shuffle_questions:true
      Problem statement 1 correct answer mistaken answer or response mistaken answer or response mistaken answer or response
      Problem statement 2 correct answer mistaken answer or response mistaken answer or response mistaken answer or response
    • The end result will look similar to the tabular form of each question format.
column A column B column C column D column E
#format:table
#shuffle_questions:true
What is the capital of Hyogo Prefecture? sa: Kobe City Himeji City Tatsuno City
Combine state and capital. match: Italy::Rome Japan::Tokyo China::Beijing

When you have completed all the problems, save the file.

3. convert

Please upload the file you have just created using the form below.
When the upload is complete, the converted file will be downloaded.

4. unzip/upload

Unzip the downloaded file and open index.html to launch the quiz player. if you want to embed an IFrame or get the URL of the question, you can use theuploaderPlease upload the file that you have just downloaded from

Frequently Asked Questions

 

en_USEN