In addition to creating questions right in Confluence, you can work on them outside of your Confluence site in a CSV file and then import it in a quiz of your choice or a question bank. 

Use cases

  • migrating questions from another platform (that supports export in CSV)
  • question creators or reviewers are not Confluence users
  • creating many similar questions (it's easy to copy and paste text snippets when working on questions in a CSV file)

Steps to follow

  1. Download the template (CSV file) that you will need to use – Quizzes for Confluence - import questions from CSV - template.csv. 
  2. Open the downloaded file and fill it in. 
    Each row in the template is a question. The second row is a sample question – make sure you remove it.
    The template has the following columns:
    • Question text – type your question text in this column.
    • Additional text – if your question exceeds 255 characters, you can have the second part of the question here. 
    • Type – enter question type (single choice/ multiple choice/ free text (checked manually), free text (checked automatically)). If blank, a single choice question will be created.
    • Randomize answers – type 'yes' to enable randomizing answer options for this question, or 'no' to disable that. If blank, randomizing will be enabled.
    • Feedback if answered correctly – type the text that participants will see after answering a question correctly (if Display custom feedback is enabled in quiz settings). It's optional.
    • Feedback if answered wrong –  type the text that participants will see after answering a question wrong (if Display custom feedback is enabled in quiz settings). It's optional.
    • Correct answers – type numbers of correct answer options separated with commas, e.g. if a question has 5 answer options and the second and fifth are the correct ones, you should type '2,5'.
    • Answer Option 1 – type the first answer option here.
    • Answer Option 2 – type the second answer option here.
    • Answer Option 3 – type the third answer option here.
    • Answer Option 4 – type the fourth answer option here.
    • Answer Option 5 – type the fifth answer option here.
      If you have more than 5 answer options, just add a new column after the column 'Answer Option 5'. If you have less than 5 options, just leave the remaining columns blank.
  3. Once done, save your file in CSV UTF-8.
  4. Based on where you want to import the questions into, go to either:
    • a quiz that you want to add questions to, or
    • the question bank if you need to import questions and not to associate them with any quizzes (e.g. you want them reviewed in Confluence first)
  5. Click  in the Create question button and select Import questions.

    Quiz administration page


    Question bank

  6. Select the file you want to import or simply drag and drop it into the dialog.
  7. Click Import.
  8. When the import is completed, you will see the message saying how many questions:
    • were successfully created 
    • failed (in case something went wrong)
    If some questions fail, you will be able to download a CSV file with questions that were not imported and reasons suggesting what went wrong.

Importing questions with images

It is possible for an imported question to have an image. It can be part of a question or an answer option. You can't upload image files when importing questions. You need to use image URLs instead, which can be URLs of images stored on Confluence pages or elsewhere.

Note that an image will disappear from an imported question if that image is no longer available at the provided URL. You can set either width or the height of an image. Below are examples of what you need to enter in your CSV file (in Additional text or Answer Option):

  • Use ${imageURL|width=200} for an image with a set width
  • Use ${imageURL|height=200} for an image with a set height