CSV to Canvas

Start with the template

Thirty pre-filled rows in the required ten-column layout. Replace the placeholder questions and answers.

Try a completed example

Six ready-to-convert questions covering multiple choice, true/false, and multiple response.

Have questions in a text file or Word document?

Copy this prompt and give it to an LLM along with your document. It will format supported questions for this tool and ask you before making assumptions about anything unclear.

You are converting quiz questions from an attached or pasted source document into a UTF-8 CSV file for a browser tool that creates Canvas QTI packages.

Read the entire source before doing anything. The source may be plain text, Markdown, a Word document, a PDF, or another loosely structured format.

CLARIFY BEFORE CONVERTING

Do not guess or silently repair the source. Before creating the CSV, stop and ask me concise clarification questions if any of these conditions apply:

- A question is an unsupported type, including essay, short answer, fill-in-the-blank, matching, numerical response, ordering, or file upload.
- It is unclear where a question or its answer choices begin or end.
- No correct answer is identified, the identified answer is ambiguous, or correctness markers conflict.
- A question appears to have more than one correct answer but it is unclear whether it should be multiple choice or multiple response.
- A question has fewer than two or more than five answer choices.
- An answer choice is missing, duplicated, or otherwise malformed.
- Point values are missing or inconsistent. If no point values are supplied, ask what default point value to use.
- Headings, lecture notes, explanations, or other surrounding text might need to be included in a question but the intent is unclear.

If clarification is needed, do not produce a partial CSV. Ask the questions first and wait for my answers. If everything is clear and compliant, proceed without asking unnecessary questions.

SUPPORTED QUESTION TYPES

1. Multiple choice: exactly one correct answer. Use MC.
2. Multiple response: one or more correct answers may be selected. Use MR.
3. True/False: represent it as MC with True in column F and False in column G.

REQUIRED CSV FORMAT

Create one row per question with exactly ten columns, A through J. Do not include a header row.

Column A: Question type. Enter MC or MR only.
Column B: Required unused column. Always leave it blank, but keep the column.
Column C: Point value from 0 through 100, with no more than two decimal places.
Column D: Complete question text.
Column E: Correct answer position or positions.
Column F: Answer choice 1.
Column G: Answer choice 2.
Column H: Answer choice 3, or blank if unused.
Column I: Answer choice 4, or blank if unused.
Column J: Answer choice 5, or blank if unused.

ANSWER POSITION RULES

- For MC, column E must contain exactly one number from 1 through 5 corresponding to the correct choice in columns F through J.
- For MR, column E must contain every correct choice number separated by commas, such as 1,3,4. Because this value contains commas, quote the field in the CSV.
- For True/False, use MC, put True in column F and False in column G, and put 1 in column E for True or 0 in column E for False.
- Answer choices must be consecutive beginning in column F. Never leave a blank between choices.
- Every question must have at least two and no more than five answer choices.

CONTENT RULES

- Preserve the original wording, capitalization, punctuation, Unicode characters, and point values unless I explicitly ask for editing.
- Remove presentation-only answer labels such as (a), A., or 1. from the answer text.
- Remove markers such as [correct], asterisks, bold formatting, or answer-key annotations from the answer text after using them to determine correctness.
- Do not invent questions, answer choices, correct answers, explanations, or point values.
- Do not include section headings or notes as standalone questions.

CSV RULES

- Produce valid UTF-8 comma-separated values.
- Quote any field containing a comma, double quote, or line break.
- Inside a quoted field, escape each double quote by doubling it.
- Preserve all ten columns, including blank trailing answer columns.
- Do not add blank rows, commentary, explanations, or a header row.

FINAL OUTPUT

After all necessary clarifications are resolved, create a downloadable file named canvas-quiz.csv if your environment supports file creation. Otherwise, return only the raw CSV inside a single code block so I can save it as canvas-quiz.csv. Do not include any text before or after the file or code block.

Column	Content
A	`MC` or `MR`
B	Leave blank
C	Points, 0–100
D	Question text
E	Correct choice number(s)
F–J	Two to five answer choices

CSV to Canvas

Start with the template

Try a completed example

Have questions in a text file or Word document?

CSV format

Import the ZIP into Canvas

Upload quiz CSV

Start with the template

Try a completed example

Have questions in a text file or Word document?

CSV format

Import the ZIP into Canvas