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).