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 end to end using the Question Bank template, and is honest about which parts are free and which sit on a paid plan.

Why import questions from a spreadsheet?

Typing questions one at a time is fine for a quick exit ticket, and it is available to every teacher for free. But when you want 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 you tweak each year. ClassKite supports multiple choice, fill-in-the-blank (word and number), true/false, matching, jumbled-sentence and more, with maths written in LaTeX and images attached 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 is a good companion read.

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 agents, so you can fill it in by hand or hand the prompt to any AI assistant to help draft rows. Either way, you stay in control: nothing is assigned until you review it.

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 back into ClassKite.
4. Review and edit every question. You approve each one before it can be assigned — no question goes live unchecked.
5. Group the questions into named practices within the relevant section of your topic.
6. Run the practice live with your class, or set it self-paced. Objective answers auto-mark the moment a student submits.

Prefer to have ClassKite draft questions for you rather than build a sheet? The AI question generator drafts questions only, which you then review and approve — see using an AI question generator without losing quality for how to keep standards high.

Run it, then see what stuck

Once a practice is live, students join free in the browser with a class code — no installs, no accounts to chase. Because objective questions mark themselves on submit, you get instant feedback instead of a marking pile. After the session, per-session and per-student reports show completion, average score and accuracy, so you can spot the questions that tripped everyone up. These analytics, along with the spreadsheet import itself, are part of the paid plans. 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?

No. Uploading the Question Bank spreadsheet template is a Teacher Plus and School Plan feature, alongside AI question generation and class analytics. On the free Teacher Basic plan you can still write questions by hand and run practice with instant feedback.

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

No. ClassKite's AI drafts questions only, and it does not read your PDF contents. You review, edit and approve every question before it can be assigned. There is no lesson-plan or worksheet generation.

What question types can I include in the spreadsheet?

Multiple choice, fill-in-the-blank (word and number), true/false, matching, jumbled-sentence and more. Maths is written in LaTeX, and you can attach images. Objective question types auto-mark on submit.

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