Skip to content
Qatesiz
Open the trainer

How to make a test from an Excel spreadsheet

A spreadsheet is the most reliable format for large question banks: one row is one question. The trainer reads XLSX, XLS, ODS and CSV, finds columns by their headers and understands the correct answer as a letter, a number or the option text.

Upload a file Download XLSX template

Step-by-step guide

  1. Create the column headers

    In the first row, enter: “Question”, A, B, C, D (as many options as you need), “Correct answer” and, optionally, “Explanation”. Short headers like question, a, b, c, d, correct work too.

  2. Fill in the rows

    Each row is a separate question. Empty option cells are skipped, so questions can have different numbers of options.

  3. Enter the correct answer

    In the “Correct answer” column, enter the letter (B), the option number (2) or the text of the correct option. List several correct answers separated by commas: A, C.

  4. Upload the file

    Save the spreadsheet as XLSX or CSV and drag it into the upload area. If the workbook has several sheets, the first sheet with questions is used.

  5. Check and save the test

    On the review screen, make sure everything was recognized correctly, fix answers if needed and save the test.

Spreadsheet example

A minimal spreadsheet with three questions:

Question | A | B | C | D | Correct answer
Capital of Kazakhstan? | Almaty | Astana | Shymkent | | B
7 × 8 = ? | 54 | 56 | 64 | 48 | 2
Prime numbers? | 2 | 4 | 7 | 9 | A, C

CSV and encodings

CSV files can use “;” or “,” as the separator. The encoding is detected automatically: UTF-8 and Windows-1251 (which Excel often uses for Russian-language files) are supported.

Spreadsheet without headers

If there are no headers, the trainer treats the first column as the question, the last filled column as the correct answer and the columns in between as options.