RNG:TC ↗
Practical guide · XLSX

From Excel spreadsheets to a ready-to-use question bank.

Prepare questions for a complete lesson unit, set their rank, type, and test flag, then import them into RNG: Teacher’s Choice.

The template is free. No account or website sign-in is needed to use it.

A sample spreadsheet. Tap to enlarge.
01Prepare a spreadsheet
02Open a lesson unit
03Import an .xlsx file
04Check the imported questions
01 · Excel structure

Five columns supported by the app

The recommended format matches the app's Excel export. Place column headers in the first row of the first worksheet and enter one question per row.

A

Question Required

The question text. This is the only field required to import a row.

B

Answer Optional

The answer or a teacher's note. You can leave it blank.

C

Rank Optional

Unranked, Easy, Medium, Hard, Advanced, or Trick. A blank cell means Unranked.

D

Question type Optional

Theory, Task, or Other. A blank cell defaults to Other.

E

Test Optional

YES marks a question for tests (★), NO leaves it unmarked. Blank means NO.

Note: The app also supports some older Excel files with fewer columns. For new files, use all five headers to preserve rank, type, and test flags.
02 · Example file

What should the spreadsheet look like?

Here is a simple three-question example. Row 1 holds the headers; the first worksheet is named Questions. These are sample questions, not from a personal question bank.

QuestionAnswerRankQuestion typeTest
What is amplitude?Maximum displacement from equilibrium.EasyTheoryYES
Define the period of an oscillation.Time for one complete oscillation.MediumTheoryNO
Calculate the frequency if the period is 0.5 s.f = 1/T = 2 HzHardTaskYES
Supported difficulty levels

Unranked · Easy · Medium · Hard · Advanced · Trick

Supported question types

Theory · Task · Other

Test flag

YES or NO (★ and ☆ are also accepted when supported).

An Excel filename can be anything you like. It does not set the name of the module or lesson unit in the app. You do not need to number questions; the app does that automatically.

03 · Import questions

Four steps from Excel to a lesson unit

  1. Prepare the file. Enter the headers Question | Answer | Rank | Question type | Test and save as .xlsx. Put the questions on the first worksheet.
  2. Open the correct question source in the app. In the main menu, open Questions, find or create the module and lesson unit, then open its question list.
  3. Choose Excel → Import from Excel. Tap Excelat the top of the question list, choose the import option, and select the .xlsx file from your phone.
  4. Verify the result. Valid rows are added to the currently open lesson unit. Review the question list and any per-row errors.
Note: If your spreadsheet contains multiple lesson units, import each unit separately. The app does not automatically group rows by lesson unit names.
Choose the destination lesson unit first.
Example of a five-column spreadsheet.
04 · Another way to add questions

You can also add questions manually

For a few individual questions, Excel is not necessary. Open the lesson unit, add a question, and enter the text, optional answer, rank, and type. Important questions can be starred for tests.

Manual entry is convenient for quick updates and individual questions.
05 · Save and reuse

Export and edit question groups in Excel

  1. Open the question list for the relevant lesson unit or group.
  2. Tap Excel → Export to Excel.
  3. Choose where the .xlsx file will be saved.
  4. Edit the exported file on your computer and import it into the chosen group when needed.
Before importing again: Keep a backup. Import adds questions to the existing group; it does not automatically replace existing questions. Avoid duplicates when re-importing.
06 · Troubleshooting

Common import problems

“Header must include the Question column”

Check that the first worksheet has a first-row header named Questionor another accepted equivalent.

A question did not import

Check the question text. A row with an empty question but other values is invalid.

Unknown rank or question type

Use the supported values above. Remove misspellings and unsupported labels.

Invalid value in the Test column

Use YES or NOas in the template. A blank cell is equivalent to NO.

Questions imported into the wrong group

The spreadsheet does not specify the target group. Open the correct lesson unit before importing.

I imported the same questions twice

Check the existing list before importing again. Import adds records; it is not an automatic synchronization mechanism.

07 · Downloads

Start with a ready-made Excel template

Both files use the same headers and a single worksheet named Questions. The blank template is ready for your own content; the filled example helps verify the format.

These files contain no personal data and no private question bank.

What next?

Select the lesson unit in Teachers mode or use its questions when creating a test.

Explore the test generator ↗