Creating the CSV file:

1. Navigate to an existing assessment module or Create a new assessment module
2. Select’ Options’ From the Questions sub-tab on the right and then ‘Import questions in bulk.’
3. Click the ‘Use this template to get started’ link to download the CSV template

Once the file loads, open it in Excel and follow these directions:

• Important: Don’t delete the headers/column titles in row 1, and don’t delete any columns from the CSV. All cells from columns A thru BF must be included in the file for a successful import. Also, no blank rows, please
• Rows 2 thru 6 are for example only. Enter your data like the examples and then delete these rows prior to import.
• Columns A and B (QuestionText and QuestionType) are mandatory fields.
• In column A: Enter the Question text, i.e., What is two plus four?
• In column B, Enter the Question Type, i.e., MULTICHOICE, FREETEXT, MATCH, KEYWORD, or SEQUENCE.
• In column C:  For Multiple choice, enter the first possible answer given to a user. For Keyword, enter the first possible keyword and repeat for columns E, G, I, K, M, O, Q, S, and U or until all answers or keywords have been entered. (No text should be entered for Free Text questions.)
• In column D: For Multiple choice, enter TRUE if the answer in column C is TRUE or FALSE if the answer in column C is false. Repeat for columns F, H, J, L, N, P, R, T, and V or until all answers have been addressed with a TRUE or FALSE. (No text should be entered for these columns for Keyword and Free Text questions)
• In column W: For the Match question type, enter the answer option and its corresponding match into columns W (OptionText1) and X (AnswerOption1). Enter the next two matches (OptionText2 and AnswerOption2) into columns Y and Z, and repeat for columns up thru AP. 
• In column AQ: For Sequence question type, enter the first answer in the sequence into column AQ, enter the 2nd answer of the sequence into column AR, and repeat thru column AZ.
• In column BA: Enter TRUE if you would like to show an Answer Hint. Enter FALSE if not, or leave this field blank.
• In column BB: Enter TRUE if you would like the learner to answer the question correctly before they can proceed to the next question. If not, enter FALSE, or leave this field blank.
• In column BC: If you would like to show Answer Feedback to the learner when the learner answers incorrectly, enter the answer feedback between the p-tags just like in this example from the template: <p>Sorry Try Again..</p>. If you don’t wish to provide feedback, leave the field blank.
• In column BD: If you wish to weigh the question, enter the number of the weight with a whole number value between 1 and 100. If not, leave the field blank, and the default will be 1
• In column BE: Enter TRUE if you want to make the question optional. If not, enter FALSE or leave the field blank
• In column BF: For Free text-type questions, enter TRUE if you don’t want to require Marking, or leave the field blank. If you want the answer to be Marked by an admin, enter FALSE.
• In column BG: For free text Questions that require marking, marking guide text can be added to this field.

Importing the CSV file:

1. Navigate to the existing assessment or Create a new assessment module.
2. Select’ Options’ From the Questions sub-tab on the right and then ‘Import questions in bulk.’
3. Click ‘Choose File’ and then Open the file.
4. Select ‘The first row of my file contains column titles.
5. Click ‘Upload’ and then wait a moment for the screen to refresh.
6. Once the screen refreshes, see the imported questions populated in the Questions sub-tab.

Helpful Hints:

• Because this is a comma-delimited file, a common reason why the import will fail is if a question or answer contains commas in the text.  To avoid this, put quotes around the answer or question that contains a comma.
• If quotes are added to a cell, Excel may include additional quotes.  Check all files in Notepad before importing them to ensure that quotes only appear once.