---
title: "What to Do With Questions Created in Excel?"
type: "article"
space: "Blackboard Ultra"
author: "Anonymous"
created: 2023-07-20T21:29:29Z
updated: 2023-07-24T19:34:30Z
tags: [".txt", "blackboard-ultra", "excel", "question-banks", "question-pools", "tab-delimited", "testing-assesments", "txt"]
url: "https://employees.senecapolytechnic.ca/spaces/266/blackboard-ultra/articles/assessing-learning/17879/what-to-do-with-questions-created-in-excel"
---

# What to Do With Questions Created in Excel?

If you previously created test questions using Excel \(.txt file format\), you will have found that Blackboard Ultra currently does not allow the import of .txt \(tab-delimited\) into the **Question Banks**.

- You can upload .txt files into an individual test. See instructions from [Blackboard Ultra's Help Page](https://help.blackboard.com/Learn/Instructor/Ultra/Tests_Pools_Surveys/Reuse_Questions/Upload_Questions), and an article from [Teesside University that includes screenshots](https://eatsupport.tees.ac.uk/staff/knowledgebase/bbu-tests-upload-questions-from-a-file/).
    - You can then create a new **Question Bank** in Blackboard Ultra and "**Reuse Questions**" from the test with the uploaded questions \(from a .txt file\).
- Alternatively, you can use an external Blackboard Test Generator that creates .zip files that are easily uploaded to **Question Banks**. Please see our related article "[Creating Question Banks Using a Test Generator](https://employees.senecacollege.ca/spaces/266/blackboard-ultra/articles/assessing-learning/17819/creating-question-banks-using-a-test-generator)."

In this article, we provide a **temporary** solution for instructors with access to an old Blackboard Original course. Where you will need to:

1. Upload the .txt file into **Blackboard Original**
2. Copy the Imported Excel Formatted Questions to your **Blackboard Ultra Course**

* * *

## Caveats 

There are question types that are not supported in Blackboard Ultra that you may have created in Excel. Please reformat the question types.

- File Response \(FIL\)
- Jumbled Sentence \(JUMBLED\_SENTENCE\)
- Opinion/Likert Scale \(OP\)
- Ordering \(ORD\)
- Quiz Bowl \(QUIZ\_BOWL\)
- *Short Response \(SR\) questions are automatically converted to Essay questions \(ESS\)*

Please note that imported **Fill in the blank** and **Multiple/Fill in the blanks** question types need to be reviewed.

- All **Fill in the blank** questions are imported by default to be an "**exact match**"
- Functional **Fill in the blank** questions will appear with a bold "**\[Blank 1\].**"
- Tip: Review the test questions in **Student Preview**.

* * *

## 1. Uploading the .txt File to Blackboard Original

1. In Blackboard Original, on the left-hand panel under the section **Course Management**, select **Course Tools** and then select **Tests, Surveys, and Pools**.![](https://employees.senecacollege.ca/attachment?file=dBM%2FT%2BhyP4xcUFCnE0WL5g%3D%3D)
2. Select **Pools**.
![](https://employees.senecacollege.ca/attachment?file=0HOnhnDZLYEkphDeVX2ABQ%3D%3D)
3. Select **Build Pool**.
![](https://employees.senecacollege.ca/attachment?file=SDYz3fSUHZTUTfbJsciU8g%3D%3D)
4. Insert a **Name** and select **Submit**at the bottom right. Tip: Give it an obvious name, you can rename it later in Blackboard Ultra. You do not need to fill out any additional sections.
![](https://employees.senecacollege.ca/attachment?file=zZrkcAOKGAGLDFNWhTFhUQ%3D%3D)
5. Select **Upload Questions**.
![](https://employees.senecacollege.ca/attachment?file=ve1eN2BBS%2F89N5pN1swXlw%3D%3D)
6. Select **Browse**and locate the .txt file on your device. 
**Note:** You can assign points per question here and you can edit them later in Blackboard Ultra.
![](https://employees.senecacollege.ca/attachment?file=GhkmKWK3I%2FHFv8Hdvy54og%3D%3D)

* * *

## 2. Copy the Imported Excel Formatted Questions to your Blackboard Ultra Course

1. Go to the Blackboard Ultra course you want to copy the questions into.
2. Select the **ellipses**next to **Course Content**. A drop-down menu is displayed.![](https://employees.senecacollege.ca/attachment?file=Wpv5XkPinienjMtzPjGepA%3D%3D)
3. Select **Copy Items** from the drop-down menu. The **Copy Items**panel is displayed.
4. Select the course you want to copy the content from. **Note**: Hidden courses will not show up in the Copy Content panel.
![](https://employees.senecacollege.ca/attachment?file=sbKz2OsGSoqsqHegG6pGGg%3D%3D)
5. Select the folder **Question Banks.![](https://employees.senecacollege.ca/attachment?file=6OdMj8Q0%2BxdfALwvNo69EA%3D%3D)**
6. Locate the question bank and select the checkbox to the left. Then, select **Start Copy** \(located on the bottom right\). 
![](https://employees.senecacollege.ca/attachment?file=3Xoei4nnu83UD3gXYcwUEg%3D%3D)
7. The newly imported question bank will now appear in the list of question banks. Refer to our related articles: [Using Question Banks and Pools](https://employees.senecacollege.ca/spaces/266/blackboard-ultra/articles/assessing-learning/15754/using-question-banks-and-pools)and [Creating a Test](https://employees.senecacollege.ca/spaces/266/blackboard-ultra/articles/assessing-learning/15650/creating-a-test).

## Attachments

- [image_72202343151689887657426.png](https://employees.senecapolytechnic.ca/attachment?file=dBM%252FT%252BhyP4xcUFCnE0WL5g%253D%253D)
- [image_70149658361689887756873.png](https://employees.senecapolytechnic.ca/attachment?file=0HOnhnDZLYEkphDeVX2ABQ%253D%253D)
- [image_27372381671689887900047.png](https://employees.senecapolytechnic.ca/attachment?file=SDYz3fSUHZTUTfbJsciU8g%253D%253D)
- [image_26105975891689888152308.png](https://employees.senecapolytechnic.ca/attachment?file=zZrkcAOKGAGLDFNWhTFhUQ%253D%253D)
- [image_783934783101689888362367.png](https://employees.senecapolytechnic.ca/attachment?file=ve1eN2BBS%252F89N5pN1swXlw%253D%253D)
- [image_639977438111689888515015.png](https://employees.senecapolytechnic.ca/attachment?file=GhkmKWK3I%252FHFv8Hdvy54og%253D%253D)
- [image_54944155961689889777611.png](https://employees.senecapolytechnic.ca/attachment?file=6OdMj8Q0%252BxdfALwvNo69EA%253D%253D)
- [image_45228622981689889972719.png](https://employees.senecapolytechnic.ca/attachment?file=sbKz2OsGSoqsqHegG6pGGg%253D%253D)
- [image_14647509831674748732393.png](https://employees.senecapolytechnic.ca/attachment?file=Wpv5XkPinienjMtzPjGepA%253D%253D)
- [image_76110501931689947325789.png](https://employees.senecapolytechnic.ca/attachment?file=3Xoei4nnu83UD3gXYcwUEg%253D%253D)