QUICK TIPS: How to Import and Export Assessment Questions

Learn how to import and export question from Brillium using the Question Export function and the Excel Import / Export template.

Import and Export Assessment Questions using the Excel format

Assessment questions can be exported from Brillium into an Excel spreadsheet template. Once exported, changes to questions can be made from within Excel, and the spreadsheet can be imported into a Brillium assessment.  

When importing questions, existing questions can be replaced, or new questions can be created.

Export Questions from a Brillium Assessment

  1. Choose Assessments from the main menu
  2. Select an assessment from the Assessments view
  3. From Assessment Builder, select the tools icon and choose Export
  4. From the Export Format dropdown, choose Brillium Excel
  5. Select the Export button
  6. Select the DOWNLOAD EXPORT HERE link to download the export file
  7. The resulting export file is an Excel spreadsheet with 3 tabs that include instructions, examples, and the exported assessment questions.

Import Questions to a Brillium Assessment

  1. Choose Assessments from the main menu
  2. Select an assessment from the Assessments view
  3. From Assessment Builder, select the tools icon and choose Import
  4. Next to Import File: choose the Select button
  5. Choose the Excel Question Import Template containing the questions to import from the local computer
  6. To replace changed questions in the destination assessment with the questions contained in the Excel Question import template, select Yes from the Merge With Existing Questions (where ID's match): section. To create new questions, select No
  7. Select the Import button to import the questions.

IMPORTANT  It is important that the format of the Excel template is not changed in any way (i.e. do not add new columns and be sure to follow the row formatting conventions outlined in the instructions and examples). Modifications to the Excel format may cause the import functions to fail with an error.