1. Split into questions: separate questions with a blank line.
2. Title vs options:
   • First line should be question .
   • Options must start with A) or B. etc.
   • Mark correct by ending the option with *.
3. Special:
   • One line block ⇒ Short Answer.
   • Contains “true/false” only ⇒ True/False.

TXT example

            1) Employee lookup formula?
            A) SUM(A2:A10)
            B) VLOOKUP(EmployeeID, Range, 2, FALSE)*
            C) IF(A2>10, "Yes", "No")
            D) CONCATENATE(A2, B2)

            2) Count “Absent” in D2:D50.
            A) COUNT(D2:D50)
            B) COUNTA(D2:D50)
            C) COUNTIF(D2:D50, "Absent")*
            D) SUM(D2:D50)
        

CSV (headers)

type,title,options,correct,category,points,explanation
multiple_choice,Employee lookup,"=SUM(A2:A10|=VLOOKUP(EmployeeID, Range, 2, FALSE)|=IF(A2>10,""Yes"",""No"")|=CONCATENATE(A2,B2)",B,graded,1,Use a lookup

Excel: same columns as CSV.