Skip to main content
Import a subject

Import an exam subject from Excel

Written By Florian Barral

Last updated 21 minutes ago

Click IMPORT

⚠️ Importing an exam subject replaces the sections, exercises, and questions already in the exam. If the file contains a Pools tab, the existing pools are also replaced.

Download the .xlsx template file and fill in the following columns:

  1. Section (optional column if you don’t use sections)

  2. Section statement (optional column if you don’t use sections)

  3. Exercise (optional column if you don’t use exercises)

  4. Exercise statement (optional column if you don’t use exercises)

  5. Tag category 1 (optional column if you don’t use tags)

  6. Tag 1 (optional column if you don’t use tags)

  7. Tag category 2 (optional column if you don’t use tags)

  8. Tag 2 (optional column if you don’t use tags)

  9. Question type
    Enter one of the following types, written exactly like this: QCM, QCU, True/False, Open, Code, Spreadsheet, Schema, File upload, or Complementary statement. For a True/False question, write True or False in the Correct choices column. A QCU that declares several correct choices is imported as a QCM. The Matching question cannot be imported: add it afterward in the editor.

  10. Points
    Enter a decimal number

  11. Size limit (optional column)
    For an Open question, the maximum length of the answer, for example 200 words or 1000 characters.

  12. Question.
    Enter your question.

  13. Grading comment
    Enter the grading comment shown on the graded submission.

  14. Correct choices
    Define which choices are correct. Example:

    • 1 if the 1st choice is correct

    • 2,4 if the 2nd and 4th choices are correct

  15. Choice 1
    Enter one of the choices for the question

  16. Choice 2
    Enter one of the choices for the question

  17. Choice 3
    Enter one of the choices for the question, or leave it empty.

  18. Choice 4
    Enter one of the choices for the question, or leave it empty.

  19. Choice 5
    Enter one of the choices for the question, or leave it empty.

  20. Choice 6
    Enter one of the choices for the question, or leave it empty.

  21. Choice 7
    Enter one of the choices for the question, or leave it empty.

  22. Choice 8
    Enter one of the choices for the question, or leave it empty.

  23. Choice 9
    Enter one of the choices for the question, or leave it empty.

  24. Choice 10
    Enter one of the choices for the question, or leave it empty.

For a simple QCM with 4 choices each time, your Excel file will contain only the following 8 columns:

  1. Question type
    Always enter QCM

  2. Points
    Enter a decimal number

  3. Question.
    Enter your question.

  4. Correct choices
    Define which choices are correct. Example:

    • 1 if the 1st choice is correct

    • 2,4 if the 2nd and 4th choices are correct

  5. Choice 1
    Enter one of the choices for the question

  6. Choice 2
    Enter one of the choices for the question

  7. Choice 3
    Enter one of the choices for the question, or leave it empty.

  8. Choice 4
    Enter one of the choices for the question, or leave it empty.

To learn more about Sections and Exercises, see Structure an exam subject.

Was this helpful?

Still need help? Ask the team