Quiz Toolkit
Import questions from Excel, CSV, Word and Google Sheets, and export any quiz back to Excel.
Watch the how-to: Import a whole question paper from Excel, CSV or Word
Quiz Toolkit brings questions into Turgor Exam Engine from an Excel or CSV file, a Word document or a live Google Sheet, and exports any quiz back to Excel. Open it from Turgor Exam Engine → Addons → Quiz Toolkit once the add-on is turned on.
Import a file
- Under Import a file, choose an Excel (.xlsx, .xls), CSV or Word (.docx) file.
- Pick the Quiz to add the questions to, or leave it on — create from the file — to have a quiz made from the file’s own
quiz_titlecolumn or sheet name. - Click Import. The result links to the quiz (Edit, Preview) and lists any row that could not be imported, with the reason. Good rows are imported even when others fail.
Click Download a sample template for a ready-made file in the right format.
Spreadsheet format (Excel, CSV, Google Sheets)
Row 1 holds the column names; case does not matter and spaces count as underscores, so Question Text is question_text. Each row after that is one question. Every sheet in a workbook is imported.
| Column | What goes in it |
|---|---|
question_text |
The question the student reads |
question |
The type: single or multiple |
answer_1 … answer_40 |
The options |
answer |
The correct option number, such as 2, or 1\|3 for several |
correct_1 … |
yes beside each correct option (used instead of answer when present) |
total_point |
Marks for the question (default 1) |
negative_points |
Marks taken off when wrong, written as a positive number such as 0.33. Blank uses the quiz’s rate |
partial_marking |
yes for part marks in Exam Mode |
category, topic, subtopic, difficulty, hint |
Optional; a new category is created if needed |
message_with_correct_answer |
The explanation shown after submitting |
title |
Optional label for finding the question later |
quiz_title, quiz_content, quiz_category, quiz_tags |
On the first question’s row only: the quiz to create |
For a second language, add question_text_alt, answer_1_alt … and message_with_correct_answer_alt (_hindi and _hi work too). If more than one option is marked correct, the question is saved as multiple choice whatever the question column says.
Word format
Write each question starting with a line that begins Q:. Mark the correct option with a * at the end:
Q: Which of these is heavier?
Type: single choice
A) A kilo of lead
B) A kilo of feathers *
Points: 2
Correct Message: They weigh the same.
Hint: Think about the units.
Options can be written A), A., A: or A -. Type is single choice or multiple choice; Points defaults to 1. Text before the first Q: is ignored.
Google Sheets
- In Google Sheets, share the sheet as Anyone with the link (no sign-in is needed).
- Paste its address under Google Sheet, pick the Quiz, and click Import now. A link that opens a particular tab imports that tab.
- Tick Keep this sheet in sync daily to re-import it every day. Synced sheets are listed under Syncing daily, each with Stop syncing.
The sheet uses the same columns as a spreadsheet file. To avoid copies of the same questions on each sync, turn on Update duplicate questions in the settings below.
Export a quiz
Under Export a quiz, pick the quiz and click Export to Excel. The file uses the same columns as an import, so you can edit it and bring it straight back.
Settings
Quiz Toolkit Settings (the Settings button) apply to every import:
- Minimum role to import quizzes – Administrator (default), Editor or Author.
- Publish quiz on import – otherwise new quizzes are saved as drafts.
- Remove existing questions – No (default), Remove from quiz only, or Remove from quiz and database. Questions used on another quiz, or already answered by a student, are only taken off, never deleted.
- Update duplicate questions – a question with the same title in the same quiz is updated instead of added again.
If the server is missing the spreadsheet library, the screen says so; Word and Google Sheet imports still work.
See also: Question types and The Questions screen.