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.

TIP

Imported questions can include properly formatted safe HTML.  For information on supported HTML tags, refer to the following knowledge article: HTML Tags Supported in Brillium

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

If you are importing a new assessment, one that has not previously been exported, you'll need to use the Microsoft Excel Brillium Import spreadsheet. You can download the template here.  

  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. If the file is a Brillium encrypted ZIP file, enter the encryption password in the Password field.

    NOTE The import process WILL NOT WORK WITH PASSWORD PROTECTED EXCEL files. Remove Excel passwords from a spreadsheet prior to upload. 
  7. 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
  8. 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.