Note: You are currently viewing documentation for Moodle 3.4. Up-to-date documentation for the latest stable version of Moodle is likely available here: qformat/csv.
|Type||Question format, CSV format|
The CSV format is a very simple way of creating multiple choice questions using a CSV (Comma separated value) file. The first line of CSV file must contain the headers separated with commas. All the other (except Header) following rows/lines contain details about the question: the question text, four options, and answer(s). Each line will contain all the details about only one question.
- You have to save the file in a CSV format. Don't save it as an Excel document or anything like that.
- Non-ASCII characters like 'quotes' can cause import errors. To avoid this, always save your text file in UTF-8 encoding (most text editors, even Libre Office, will ask you).
- The Header must be as it is shown in the example below. Everything is case sensitive as shown below; otherwise, the import will fail.
- "Answer 2" is optional, as of now there can be a maximum of two right answers for one question.
- If you want to have a comma character (,) inside the question text or in options text, then you must enclose that text between double quotes (") like the example below in the 3rd question, where the entire question is enclosed between double quotes like this "3, 4, 7, 8, 11, 12, ... What number should come next?"
questiontext,A,B,C,D,Answer 1,Answer 2 Which command is used to print a file,print,ptr,lpr,none of the mentioned,C, The command “mknod myfifo b 4 16”,Will create a block device if user is root,Will create a block device for all users,Will create a FIFO if user is not root,"None ,of the mentioned",A,B "3, 4, 7, 8, 11, 12, ... What number should come next?",7,10,14,15,D,
You can also see that the 'Answer 2' is optional as the first and third questions have only one answer, whereas the second question has two answers.