Creating and Importing Quiz Questions on a Spreadsheet
To save time when making a quiz, you can download the AhaSlides template spreadsheet and import quiz questions and their settings directly to AhaSlides.
How does it Work?
The 'import spreadsheet' feature lets you import a list of quiz questions into AhaSlides. You can create the question list directly within Excel or Google Sheets then import that list as a series of Pick Answer slides into your AhaSlides presentation.
How to Create and Import a Spreadsheet for a Quiz
Step 1: Click 'import spreadsheet'
Click the 'New Slide' button and then 'Import spreadsheet' in the bottom right corner of the pop-up.
Step 2: Download the AhaSlides template
In the new pop-up, click on 'Download our template'.
This will download an .xlsx file that you can open for editing in Excel, Google Sheets, Libre Office or Numbers.
Step 3: Enter your questions and their settings
In the template spreadsheet you can create your questions and their answer options, either by typing manually or pasting from elsewhere. You can also set the basic settings of each question on the right side of the spreadsheet.
Please note that the first question in this template is an example. Make sure to overwrite this with your own first question!For a quiz question to successfully import without requiring further editing on AhaSlides, it must contain...
- A question (maximum 300 characters)
- At least 2 answer options (maximum of 8)
- A time limit (chosen from a list)
- One or more answers marked as correct.
- Either 'yes' or 'no' selected from the column labelled 'faster answers get more points'.
You can get more info on all these settings in our guide on how to make a quiz.
If any part of a question is not filled in, it will still import to AhaSlides, but you will be required to manually fill in the missing parts on the AhaSlides editor.
Step 4: Save and import
Once you are finished, save or download the file as a Microsoft Excel file (.xlsx). After this, you can import the spreadsheet into the 'import spreadsheet' pop-up on AhaSlides.
When you import, a leaderboard slide will be automatically generated after the final quiz question. You can add more leaderboard slides by navigating to the settings of any of your other quiz question slides and toggling on the leaderboard.
Related Articles
How to Use Question Bank for Your Presentations
The question bank contains thousands of questions you can choose from on various topics and seamlessly import them into your presentations. What is the Question Bank? The question bank is a collection of questions consisting of different topics ...How to Make and Run a Quiz
On AhaSlides you can host a live quiz and have all of your participants competing for points. Build a quiz using quiz question slides and see who ranks top of the leaderboard at the end! Video: How to Make a Live Quiz on AhaSlides This video explains ...Creating a Poll question on AhaSlides
A poll slide is a quick and easy way to get live opinions in poll format from your audience. How does a Poll slide Work? In a poll, you ask a question and provide between 2 and 30 answer options. Your audience vote for one or more of the answer ...Adding and Deleting a Leaderboard on your Quiz
After each quiz question, a leaderboard is shown. After the final question, the leaderboard will display the winner. When you add any 'quiz game' slide, a leaderboard slide will automatically be created and placed after the quiz game slide. In case ...How to Use the Short Answer Quiz Slide
Learn how to add to the challenge of your quiz by using a 'Short Answer' quiz question. What is the Short Answer slide? How to set up a Short Answer question The results display of a Short Answer slide Manually accepting answers What is the Short ...