How do I import trivia questions from a CSV or PDF?

Applies to Phenom Trivia 0.4 beta Updated

On the Questions page in Phenom Trivia, use Import CSV to bring in a spreadsheet of questions, or Import PDF to read question-and-answer pairs out of a quiz document. CSV is the reliable way to bring in a lot of questions.

Importing a CSV

  1. Prepare the file. It needs the columns below.
  2. Click Import CSV on the Questions page and choose the file.
  3. Read the message at the end. It tells you how many were imported and how many had errors. Rows missing a required column are skipped.
Column Needed? Notes
question_text Yes The question.
answer_text Yes The answer.
category_id Yes The ID of a category that already exists in the app.
question_type No standard (the default), multiple_choice, music, picture, video, anagram, list or bonus.
points No Defaults to 1.
difficulty No easy, medium (the default) or hard.
mc_options No For multiple choice: the options separated by a vertical bar, for example Paris|London|Berlin|Madrid.
mc_answer No For multiple choice: the letter of the correct option, A to D.

Importing a PDF

  1. Click Import PDF and choose one or more files.
  2. Choose the category they should all go into.
  3. Let the app find the pairs. It adds them to your bank.

It recognises Q: / A: pairs, numbered questions with the answer after a |, and numbered questions with the answer on the next line.

  • Everything comes in as a Standard question worth 1 point at medium difficulty, in the one category you chose. Edit afterwards if needed.
  • Importing the same PDF twice gives you the questions twice.

Why did a PDF import find nothing?

The PDF must contain real text. A scanned page (one where you cannot highlight the words) gives nothing, and so does a layout the importer doesn't know. Use a CSV instead.

More about questions and rounds