How to Create a Quiz from Excel or CSV
If you want to create a quiz with a large set of questions, transform your existing content into interactive quizzes, ensure high consistency across questions, or build extensive quizzes quickly, Faabul's option to make quizzes from an Excel or CSV file is just what you need.
1. Prepare Your File
Create an Excel or CSV file with the following headers (column names) in the first row:
question | explanation | correct | option1 | option2 | option3 |
---|
If you need more than 3 options, add more columns using the same pattern.
Fill in the columns with your questions, explanations, correct answers, and multiple-choice options as needed.
2. Save and Upload
- Save your file as a CSV.
- Sign in or Create an account on Faabul.
- Go to My Quizzes and click the New Quiz button.
- In the upper right corner, select Import quiz, select the file and upload it.
3. Review and Share
- Review your quiz, create a text code or QR code for it, and share it with others.
Example
This is how your table should look:
question | explanation | correct | option1 | option2 | option3 |
---|---|---|---|---|---|
What is the largest planet in our solar system? | Jupiter is known for its size and large storm called the Great Red Spot. | C | Saturn | Neptune | Jupiter |
Which planet is closest to the Sun? | Mercury orbits the Sun at an average distance of about 57.9 million km. | A | Mercury | Venus | Earth |
What planet is known as the Red Planet? | Mars is often referred to as the Red Planet due to its reddish appearance. | B | Earth | Mars | Venus |
For more information on uploading various question types, visit Import and Export (English only).