Creating and Importing Quiz Questions from 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 Excel'

Click the '+ Slide' button and then 'Import Excel' 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'. You can also download it here: Import 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 refrain from deleting or modifying the rows and columns highlighted in yellow.

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

1. A question (maximum 300 characters)
   
2. At least 2 answer options (maximum of 8)
   
3. A time limit (chosen from a list)
   
4. One or more answers marked as correct.
   
5. 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

• Importing a PowerPoint Presentation

  You can import a PowerPoint presentation to AhaSlides in PPT, PPTX or PDF format. Doing this means you can put interactive slides from AhaSlides in between the slides of your PowerPoint. Importing your existing PowerPoint presentation to AhaSlides ...

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

• Adding and Deleting a Leaderboard on your Quiz

  The Leaderboard shows the ranking and scores of participants in a quiz. After the final question, the leaderboard will display the winner. Leaderboard will only work with quiz slides (Pick Answer, Short Answer, Match Pairs, Correct Order and ...

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

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