How does it work?
The Import Spreadsheet feature lets you import a list of quiz questions into AhaSlides. You create the question list in Excel or Google Sheets, then import that list as a series of Pick Answer slides in your presentation.How to create and import a spreadsheet for a quiz
Click 'Import Excel'
Click the + New slide button, then Import Excel in the top-right corner of the pop-up.
Download the AhaSlides template
In the new pop-up, click Download our template. You can also download the template spreadsheet here.This downloads an
.xlsx file that you can open for editing in Excel, Google Sheets, LibreOffice, or Numbers.Enter your questions and their settings
In the template spreadsheet, create your questions and 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.For a quiz question to import successfully without needing further editing in AhaSlides, it must contain:
- A question (maximum 300 characters)
- At least 2 answer options (maximum of 8)
- A time limit (chosen from the provided list)
- One or more answers marked as correct
- Either yes or no selected in the column labelled “faster answers get more points”
Save and import
Once finished, save or export the file as a Microsoft Excel file (
.xlsx). Then import it into the Import spreadsheet pop-up on AhaSlides.When you import, a leaderboard slide is automatically generated after the final quiz question. You can add more leaderboard slides by opening the settings of any quiz question slide and toggling on the leaderboard — see Adding and Deleting a Leaderboard on your Quiz.