How to Upload Test Questions from Microsoft Excel

If you want to create your test offline using Microsoft Excel, you can do so by saving the test in a special file, and then uploading to Blackboard. Once in Blackboard, the questions can be added to different tests as if they were created using the Blackboard system.

Step-by-Step Guide

How to Upload Test Questions from Microsoft Excel

Excel question format

You can create tests offline using Microsoft Excel. When you create a test in Excel, there are rules you must follow: In the first column, you must indicate what type of question you are adding. See the table below for a full list of question type shorthand. 

Please Note:  You will notice there is not a Calculated Formula or Hot Spot Shorthand. As of now, these question types cannot be created offline using Excel.

Test question chart with abbreviations for each test type.

  1. The second column is the question text.
  2. The third column will be the answer to the question. If you have multiple answers, you will place them in the following columns. Refer to the example below.
    Sample excel spreadsheet with test questions and answers.

To create a test in Excel

  1. Open Excel.
  2. Following the format discussed above, enter your questions in Excel.
  3. When you have finished your test questions, click the File TabSave As, and then select a location.
    Save the file as an Excel file.
  4. In the File Name box, type a name for your file.
  5. In the Save as type, select Text (Tab Delimited), and then click Save.
    Select Tab delimited from the drop-down menu.

To upload test questions from Excel to Blackboard

  1. On the Control Panel, under Course Tools, click TestsSurveysand Pools.
    tests, surveys, and pools link
  2. Click Tests.
  3. Next to the test you wish to edit, click to expand the Contextual Menu, and then click Edit.
    edit link
  4. Click Upload Questions
    upload questions button
  5. On the Upload Questions page, under Upload Questions, click Choose File and locate the .txt file that contains your Excel questions.
    Sample excel file.
  6. You will also need to type the points possible for each test question in the Points per question box. 
    Add the point for each question.
  7. When you are finished, click Submit.



Video tutorial for Uploading Test Questions from Microsoft Excel. 


To request help related to this article, please see our Service Catalog.


Article ID: 93917
Thu 12/5/19 2:19 PM
Tue 9/8/20 9:39 AM