> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ahaslides.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Creating and Importing Quiz Questions from a Spreadsheet/Excel file

> How to download the AhaSlides quiz template spreadsheet, fill in questions and settings, and import them in bulk as Pick Answer slides.

To save time when making a quiz, you can download the AhaSlides template spreadsheet, fill in your questions and their settings, and import them directly into AhaSlides.

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

<Steps>
  <Step title="Click 'Import Excel'">
    Click the **+ New slide** button, then **Import Excel** in the top-right corner of the pop-up.
  </Step>

  <Step title="Download the AhaSlides template">
    In the new pop-up, click **Download our template**. You can also [download the template spreadsheet here](https://s3.amazonaws.com/public.ahaslide.com/template-sheet/ahaslides-quiz-template_v2.xlsx).

    This downloads an `.xlsx` file that you can open for editing in Excel, Google Sheets, LibreOffice, or Numbers.
  </Step>

  <Step title="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.

    <Warning>
      Please do not delete or modify the rows and columns highlighted in yellow. The first question in the template is an example — make sure to overwrite it with your own first question.
    </Warning>

    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"

    You can find more detail on all of these settings in [How to make and run a quiz](/using-slide-types/how-to-make-and-run-a-quiz).

    If any part of a question is left blank, it will still import, but you will need to fill in the missing parts manually in the AhaSlides editor.
  </Step>

  <Step title="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](/features-and-functions/adding-and-deleting-a-leaderboard-on-your-quiz).
  </Step>
</Steps>


## Related topics

- [Export data to Excel](/after-the-presentation/export-data-to-excel.md)
- [Collecting Audience Information](/features-and-functions/collecting-audience-information.md)
- [How to Import a PowerPoint Presentation or PDF File Into AhaSlides](/features-and-functions/importing-a-powerpoint-presentation-or-pdf-file.md)
- [AhaSlides Presentations Dashboard: Create & Organise](/getting-started/the-my-presentations-dashboard.md)
- [How to Create and Use a Word Cloud Slide in AhaSlides](/using-slide-types/using-the-word-cloud-slide.md)