ColorQ CSV Question Format

Official Specification — Version 1.0

This document defines the official CSV format used by ColorQ for importing and generating multiple-choice questions.

CSV Header

question,option1,option2,option3,option4,option5
Important: option1 MUST always contain the correct answer.

Fields

Field Description
question The question text.
option1 The correct answer. Always.
option2 Incorrect answer / distractor.
option3 Incorrect answer / distractor.
option4 Incorrect answer / distractor.
option5 Incorrect answer / distractor.

Rules

  1. Each CSV row represents exactly one question.
  2. Every question must contain exactly five answer options.
  3. option1 must always contain the correct answer.
  4. option2, option3, option4 and option5 must contain incorrect but plausible answers.
  5. Do not include a correct-answer column. The correct answer is implicitly option1.
  6. Do not include lesson ID, unit ID, question ID, operator ID or other ColorQ internal database fields.
  7. The CSV file must use UTF-8 encoding.
  8. CSV values should be enclosed in double quotes when necessary, especially when they contain commas, quotation marks or line breaks.
  9. Questions and answer options should not contain unnecessary numbering such as "A)", "B)", "1." or "2.".
  10. Do not randomize the correct answer position. ColorQ handles answer randomization internally.

Example

question,option1,option2,option3,option4,option5
"What is the capital of France?","Paris","London","Rome","Madrid","Berlin"
"Which planet is known as the Red Planet?","Mars","Venus","Jupiter","Mercury","Saturn"
"How many sides does a hexagon have?","6","5","7","8","10"

Instructions for AI Assistants

AI assistants:

When a user requests questions in "ColorQ CSV format", generate the questions according to this specification.

The output must use exactly these columns: 

question,option1,option2,option3,option4,option5

option1 MUST ALWAYS be the correct answer.

Do not add additional columns unless explicitly requested by the user. Do not include explanations, answer keys or additional text inside the CSV.

Recommended AI Prompt

Users may provide this page to an AI assistant and request: 

Generate 100 multiple-choice questions using the official ColorQ CSV Question Format:

https://colorq.app/csv_question_format.html

Follow the specification exactly and provide the result as a CSV file.

ColorQ CSV Question Format v1.0
Official ColorQ question interchange format.