How do I import trivia questions from a CSV or PDF?
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
- Prepare the file. It needs the columns below.
- Click Import CSV on the Questions page and choose the file.
- 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
- Click Import PDF and choose one or more files.
- Choose the category they should all go into.
- 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.
Related questions
- How do I add questions to the Phenom Trivia question bank?Add trivia questions to the Phenom Trivia Question Bank one at a time, with categories, difficulty, points, media, tags and bonus questions.
- What question types does Phenom Trivia support?Phenom Trivia has nine question types, including multiple choice, music, picture, picture grid, video, anagram, list and bonus questions.
- How do I generate trivia questions with AI in Phenom Trivia?Connect your own AI provider in Phenom Trivia, generate a batch of questions on any topic, then approve them in the Review Queue.
More about questions and rounds
- Can I trust AI-generated trivia questions in Phenom Trivia?How Phenom Trivia keeps you in charge of AI questions - each comes with references, and nothing enters your bank until you approve it.
- How do I build a trivia game in Phenom Trivia?Build a Phenom Trivia game in Game Builder - pick a template, fill each round's slots from your question bank, and save it as Ready.
- How do I avoid repeating questions in Phenom Trivia?Mark a game's questions as used when you save it, restore them later, and on Studio see a flag on questions used in the last eight weeks.
- How do I print host sheets and answer sheets in Phenom Trivia?Print a branded Host Sheet, team Answer Sheets and a Picture Sheet as PDFs from any game in Phenom Trivia's Game Builder.
- How do I run music, picture and video rounds in Phenom Trivia?Import audio, images and video into the Phenom Trivia Media Library, attach them to questions and play them on the night.