Get your questions into CramSnap in five minutes

Pick how you have them right now and follow the steps.

·

  1. 1 Open the template
  2. 2 Fill it in
  3. 3 Download
  4. 4 Check
  5. 5 Import

Open the template

Download the .xlsx template. In Google Sheets, go to File → Import → Upload and pick it. You can also open it in Excel or Numbers.

Download .xlsx

The template has the column titles and two example questions. Leave the first row exactly as it is; delete the examples at the end.

Write one question per row

The question in the question column. Each answer in an answer column and, next to it in correct, true if it is right or false if not.

  • true or false (the sheet may show it as TRUE: that works too)
  • Two answers at least, ten at most
  • Several true = a multiple-answer question
  • The explanation is optional

True or false: two answers, “True” and “False”, and mark the right one with true.

More than four answers? Add the columns answer5 and correct5, and so on up to answer10.

Download it as CSV

Save it as CSV, comma-separated, in UTF-8. Pick your program:

Google Sheets

File → Download → Comma-separated values (.csv). The file goes to Downloads.

Check it here

Pick the file or paste its text. You will see your questions as the app will show them, or the exact line to fix.

Import it into CramSnap

On the web, the button below opens it already loaded. In the app: Create → Import quiz → CSV → Choose file, and pick the .csv in Downloads.

The web may ask you to sign in: it is the same account as in the app.

  1. Close this tab. Send the file to your phone (email, Drive or a message to yourself).
  2. Pick CSV. In the app: Create → Import quiz → CSV.
  3. Tap Choose file. Tap Choose file.
  4. Pick the file in Downloads. Pick the file.

If you opened this guide from the app, go back: the format is already picked.

  1. 1 Open an editor
  2. 2 Write
  3. 3 Save
  4. 4 Check
  5. 5 Import

Open a text editor

Any editor that saves plain text. Pick yours:

Windows

Open Notepad: press the Windows key, type “Notepad” and press Enter.

What is the capital of France?
A. London
B. Paris
C. Berlin
D. Madrid
ANSWER: B

Which planet is known as the Red Planet?
A. Venus
B. Mars
C. Jupiter
ANSWER: B

Copy the template and change only the marked words

The question on one line, the answers with A. B. C., and at the end ANSWER: with the right letter. One blank line between questions.

  • The question on a single line
  • Answers A. B. C. with a space after the dot
  • Last line ANSWER: B, in capitals

What you type here is kept in this tab until you close it.

This format keeps no explanations. If you want them, use the spreadsheet. Go to the spreadsheet

Save it as .txt

As plain text, in UTF-8. Pick your editor:

Windows

File → Save As. Leave the encoding on UTF-8 and give it a name that ends in .txt.

Check it here

Paste the text or pick the file. You will see your questions, or the exact line to fix.

Import it into CramSnap

On the web, the button below opens it already loaded. In the app: Create → Import quiz → Aiken → Choose file, and pick the .txt.

The web may ask you to sign in: it is the same account as in the app.

  1. Close this tab. Send the file to your phone (email, Drive or a message to yourself).
  2. Pick Aiken. In the app: Create → Import quiz → Aiken.
  3. Tap Choose file. Tap Choose file.
  4. Pick the file in Downloads. Pick the file.

If you opened this guide from the app, go back: the format is already picked.

Check your file

Pick the file or paste its text. We tell you what it is, whether it works and how to upload it.

The JSON schema

An object with version: 1 and a quizzes list. Fields we do not know are ignored; the JSON must be strict.

FieldRequiredWhat it holds
version yes The number 1.
quizzes yes A list with at least one quiz.
quizzes[].questions yes At least one question.
questions[].text yes The question.
questions[].answers yes Two answers or more.
answers[].text yes The answer text.
answers[].correct no true on the right ones; missing counts as false.
questions[].explanation no The explanation.
questions[].type no single or multi; it must match the right answers.
quizzes[].title no Read but not saved: you name the quiz when you import.

The formats, one by one

For people who already have a file: what each format keeps and what is lost.

GIFT Text with marks, for hand-written questions with explanations.

Three rules

  1. The answers go between { and }
  2. = in front of the right one, ~ in front of the wrong ones
  3. The explanation goes after #### and starts with a word

Smallest example

What is the capital of France? {
  ~London
  =Paris
  ~Berlin
  ~Madrid
  ####Paris has been the capital of France since the year 987.
}

What is not kept

Titles ::like this::, per-answer comments and categories.

Download a 30-question example Open the example in the box
Aiken The simplest text: question, answers and the right letter.

Three rules

  1. The question on a single line
  2. Answers A. B. C. with a space after the dot
  3. Last line ANSWER: B, in capitals

Smallest example

What is the capital of France?
A. London
B. Paris
C. Berlin
D. Madrid
ANSWER: B

What is not kept

Explanations (the format has none) and anything after ANSWER:.

Download a 30-question example Open the example in the box
CSV A spreadsheet saved as text: one row per question.

Three rules

  1. The first row: question, answer1, correct1…
  2. true or false in the correct columns
  3. Comma-separated, in UTF-8

Smallest example

question,answer1,correct1,answer2,correct2,answer3,correct3,answer4,correct4,explanation
What is the capital of France?,London,false,Paris,true,Berlin,false,Madrid,false,Paris has been the capital of France since the year 987.

What is not kept

Columns we do not know and answers from the eleventh on.

Download a 30-question example Open the example in the box
JSON For people who generate questions with a program.

Three rules

  1. version: 1 and a quizzes list
  2. Each answer with text and correct
  3. Strict JSON: no trailing commas

Smallest example

{
  "version": 1,
  "quizzes": [
    {
      "questions": [
        {
          "text": "What is the capital of France?",
          "explanation": "Paris has been the capital of France since the year 987.",
          "answers": [
            {
              "text": "London",
              "correct": false
            },
            {
              "text": "Paris",
              "correct": true
            },
            {
              "text": "Berlin",
              "correct": false
            },
            {
              "text": "Madrid",
              "correct": false
            }
          ]
        }
      ]
    }
  ]
}

What is not kept

The quiz title and description: you name the quiz when you import.

Download a 30-question example Open the example in the box
QTI The standard for moving questions between learning platforms.

Three rules

  1. QTI 2.1, in a single .xml
  2. Multiple-choice questions only
  3. Several questions: inside one root element

Smallest example

<?xml version="1.0" encoding="UTF-8"?>
<assessmentItem xmlns="http://www.imsglobal.org/xsd/imsqti_v2p1" identifier="q1" title="q1" adaptive="false" timeDependent="false">
  <responseDeclaration identifier="RESPONSE" cardinality="single" baseType="identifier">
    <correctResponse><value>B</value></correctResponse>
  </responseDeclaration>
  <itemBody>
    <choiceInteraction responseIdentifier="RESPONSE" shuffle="false" maxChoices="1">
      <prompt>What is the capital of France?</prompt>
      <simpleChoice identifier="A">London</simpleChoice>
      <simpleChoice identifier="B">Paris</simpleChoice>
      <simpleChoice identifier="C">Berlin</simpleChoice>
      <simpleChoice identifier="D">Madrid</simpleChoice>
    </choiceInteraction>
  </itemBody>
</assessmentItem>

What is not kept

Explanations and all feedback.

Download a 30-question example Open the example in the box