Skip to main content
Create subject

Import a subject from Excel

Fill in the Excel template, one row per question, and import the whole subject.

Written By Florian Barral

Last updated 9 days ago

Excel is the most complete format for importing a subject: one row per question, with its choices, its correct answer, its points and its exercise.

Import an Excel file

  1. In the Create › Subject tab, click Import. The button shows as long as the subject is empty; otherwise, go through the exam's ⋮ menu › Import › Subject.

  2. Choose Excel.

  3. Click Download template › Subject only. The file contains a Guide sheet explaining each column, and a Subject sheet with examples.

  4. Fill in the Subject sheet, one row per question, then drop the file into the import area (5 MB max).

Import a subject from Excel

The questions must be in a sheet named Subject. If the sheet has another name, the import finishes without a message but the subject stays empty.

An import replaces the whole subject: sections, exercises and questions. Import before generating the copies: once the copies are generated, the subject can no longer be edited (except points, correct answers, tags and grading comments).

The columns

Column

What to enter

Question type

QCM (MCQ: one or more correct answers), QCU (SCQ: only one), True/False, or Complementary statement (text with no answer). A row with no type is skipped.

Question

The question statement.

Choice 1 to Choice 10

The choices offered, in order. Leave unused ones empty. A paper exam accepts at most 8 choices per question.

Correct choices

The numbers of the correct choices: 2, or 1, 3. For a True/False question, write True or False.

Points

The number of points (decimals accepted). Empty = 1 point.

Grading comment

A text printed only on the answer key.

Section, Section statement

Optional. Rows with the same section name are grouped together.

Exercise, Exercise statement

Optional. Questions with the same exercise name are printed together, below the statement. Without an exercise, each question stands alone.

Question columns, Choice columns

Optional. 1 or 2: on how many columns the exercise's questions or the choices are printed.

Tag category, Tag

Optional. Classify the questions (chapter, difficulty…). Several tags in one cell: separate them with commas.

SCQ or MCQ

The Question type column decides. A QCU question with several numbers in Correct choices is imported as an MCQ. You can also change the type after the import, in the editor.

Formatting

  • Line break in a cell: Alt + Enter (Option + Enter on Mac).

  • Bold and italic: **bold**, *italic*.

  • Formulas: between $…$, for example $\frac{1}{2}$. Never start a cell with =: Excel would take it for a calculation.

  • Images: they are not imported. Add them afterwards in the editor. See Edit and format content.

Frequently asked questions

The sheet holding the questions is not called Subject. Rename it, or copy your rows into the template's Subject sheet, then import again.

Check the Question type column of those rows: a row with no type, or an unknown type, is skipped.

Excel turns 1,5 into a number and 3/4 into a date if the column is not in Text format. In the template, the Correct choices and Choice columns are already in Text format: keep them that way, and if you paste cells from another file, use Paste Values.

If a row is invalid, nothing is imported: fix the row named in the message, then try again. If the message is unclear, write to us from the help chat with the file.

Write QCU in the Question type column of single-answer questions, with a single number in Correct choices.

Always start from the template downloaded from Papeez and keep the sheet named Subject. Import a few rows first to test. After each import, check in the editor each question's type, the correct answers and the points. A mistake found after the exam can still be fixed: change the correct answer, then recalculate the grades.