How do I bulk import content?

Getting Started

There are two ways to get your content into Trivie: one is to create each question individually using the question creation form. See how to do that here: How do I manually add content? The other is to bulk import them via CSV or Excel file.

Here we'll step you through the process of bulk importing your content starting at the beginning.

Once you're signed in to the management system, click on the "Content" button (see the icon above) on the main left-side navigation and you will be taken to the Content section.

Then click on the "Import Content" button in the top bar:


Download one of these import templates:

It doesn't really matter which one you pick, all popular spreadsheet editors should be able to open and save files in either format. But, you will need a spreadsheet editor such as Microsoft Excel, Google Sheets, Apple Numbers, or even OpenOffice Calc.

You can use this template to populate multiple-choice questions, multiple correct answers, or true/false questions. When you open the template you'll see the following headers:

Here's a breakdown of what each header means: 

  • Topic
    • This is where you can group all of your quizzes.
  • Quiz
    • Enter the name of a Quiz to associate the question with.
  • Question
    • Here's where you enter the text of the question itself (e.g. "How were my employees ever remembering anything without Trivie?).
  • Correct_answer
    • In this field, you'll type in the correct answer to the question (e.g. "They probably weren't")
  • Wrong_answer_1
    • In this field, and the next one (wrong_answer_2) you'll enter in your distractors.
  • Wrong_answer_2
  • Factoid
    • The factoid field is entirely optional, but if you want to include any extra information that the user will see after they answer the question, here is where you can enter that.

Wait, but how do you enter multiple correct and true/false questions?

True/False Questions:

You only need to enter the correct answer in the correct_answer column. The system will automatically fill in the wrong answer. Sweet! 

Remember: leave the wrong_answer_1 and wrong_answer_2 values empty!

Multiple Correct Answers:

You can have 1, 2, or 3 correct answers. To bulk upload multiple correct answers, be sure to put a * next to any answers that should be correct - even though they're in the wrong_answer columns! 

Our super-smart system will automatically mark the answers with an * as correct when uploaded - check it out:

Pro Tip:

There are character limits on fields and are as follows:

Topics: 64 character count

Quizzes: 64 character count

Questions: No character count

Correct and Wrong Answers: 160 characters

Factoids: 1,024 characters 

Save and Upload

Save the document to a place you can find it (such as to your desktop), and then import it by either clicking or dragging & dropping over the "Drag & drop or click to select file..." section that looks like this one:

Checking for Errors

If any errors are detected in the file, you will be shown the errors immediately.

You will not be able to import a file unless there are zero errors detected. The error messages will explain what is wrong with the question row.

If you can't figure out how to resolve the issue reach out to Please attach your file to the email so we can quickly identify the issue and get you on your way!

Otherwise, if there are no errors you will just see something like this:

Completing the Import

Don't forget to click the "Import Content" button to send your file to the server.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.