Bulk-Import Questions From a Spreadsheet in Minutes

If you have ever rebuilt the same set of questions term after term, you will know how much time it eats. ClassKite lets you bulk-import a whole batch of questions from a single spreadsheet, so a topic that used to take an evening of typing can be ready in minutes. This guide walks through the workflow using the Question Bank template, and says what depends on your plan.

Why import questions from a spreadsheet?

Typing questions one at a time works for a quick exit ticket, and every teacher can do it for free. For a reusable bank covering a whole unit, a spreadsheet is far faster: you can draft rows offline, paste in answers, reorder them and keep a master copy to update each year. The template takes every question type, with maths written in LaTeX and images where you need them. If you are building something you will reuse, our guide on how to build a reusable question bank for your subject goes with this one.

The import workflow, step by step

The Question Bank template is a spreadsheet with a built-in AI prompt and an instructions sheet written for AI assistants, so you can fill it in by hand or give the prompt to any AI assistant to draft rows. Either way, nothing reaches students until you start the practice, so you can review it first.

1. Download the Question Bank spreadsheet template from inside ClassKite.
2. Fill in the rows: type them yourself, or paste the built-in prompt into an AI assistant and let it draft questions for you to check.
3. Upload the completed spreadsheet to ClassKite.
4. Review and edit every question. Nothing is assigned until you run the practice or open it for self-practice.
5. Group the questions into named practices within the relevant section of your topic.
6. Run the practice live with your class, or open it for self-practice. Answers are marked the moment a student submits.

To have ClassKite draft questions without a spreadsheet, use the AI question generator: it drafts questions for you to review and edit. Using an AI question generator without losing quality explains how to keep standards high.

Run it, then see what stuck

Once a practice is live, students join free in the browser with a join code, with nothing to install. Answers are marked on submit, so there is no marking pile. After the session, per-session and per-student reports show completion, average score, First try and Solved, so you can see who needs another go. Reports come with Teacher Plus and the School plan, which also include unlimited spreadsheet import. For more on assessment workflows, see our online assessment tools.

Open ClassKite and start your question bank: download the template, fill it in and have a practice ready before your next lesson.

Frequently asked questions

Is bulk spreadsheet import free?

It depends on your plan. Unlimited spreadsheet import comes with Teacher Plus and the School plan, alongside AI question generation and class analytics. Teacher Basic may include some free imports; the pricing page shows the current allowance. Writing questions by hand and running practice with instant feedback are free on every plan. Compare the tiers.

Does the AI read my PDF and write the questions for me?

No. ClassKite's AI drafts questions only and does not read the contents of your PDFs. You can review and edit every question, and nothing is assigned until you run the practice. It does not generate lesson plans or worksheets.

What question types can I include in the spreadsheet?

All six types: multiple choice, true/false, fill-in-the-blank (word or number), matching and jumbled sentence. Maths is written in LaTeX, and you can attach images. Every type is marked automatically on submit.

Related reading: How ClassKite saves teachers time, How to create digital practice from a PDF, and the Question Bank feature page.