Free Excel to Quiz Generator — Multiple Choice, Timer & Kahoot Export
You have a spreadsheet packed with quiz questions. Maybe it is a question bank built over years of teaching. Maybe it is a compliance assessment your HR team compiled. Maybe it is a practice set your student group created for exam prep. It sits in Excel, perfectly structured, and yet turning it into an actual quiz means re-entering every single question into Kahoot, Google Forms, or ProProfs — one by one, by hand.
The ExcelGuru Excel to Quiz Generator eliminates that entirely. Upload your .xlsx or .csv file, and you have a fully interactive, live-scored quiz running in your browser within seconds. Multiple choice with A/B/C/D options. True/False. Short answer. A per-question countdown timer. Instant correct/wrong feedback. A pass/fail threshold. An answer review screen. Export to Kahoot, PDF, or Excel. All free. No account. No file upload to any server.
🔑 The core problem this tool solves Every existing tool that accepts Excel quiz questions either requires an account, caps the free tier at 8 questions (ProProfs), requires a multi-step CSV conversion (Kahoot), or uploads your file to a server (Smallpdf AI). ExcelGuru is the only free, browser-based, no-signup tool that reads a real .xlsx file, plays a live scored quiz with a timer, and exports Kahoot-compatible CSV — all in one step. |
Col D–H: Options A–E (for multiple choice) · Col I: Category (optional)
Format: Question [Tab] Type (MC/TF/SA) [Tab] Correct Answer [Tab] Option A [Tab] Option B [Tab] Option C [Tab] Option D [Tab] Category
How to Use the Tool — Step by Step
Create, play, review, and export your quiz in a few simple steps
Start directly in your browser with no signup, no installation, and no waiting time. The workflow is designed to be simple for teachers, trainers, students, and teams.
Open the tool instantly
Open the tool in your browser. There is no download, no account, and no loading time, so you can start working immediately from desktop, tablet, or mobile.
Choose your input method
Pick the method that suits your workflow: Upload File, Paste Data, or Type Manually. This gives you flexibility whether your questions are already prepared in a spreadsheet or being created from scratch.
Upload your file if you already have data
Drag and drop your .xlsx, .csv, or .tsv file into the upload area, or click to browse. If you are unsure about the required format, download the Excel or CSV template first and prepare your columns accordingly.
Paste directly from Excel or Google Sheets
If your questions are already arranged in rows, copy them from Excel or Google Sheets and paste them into the Paste Data tab. The tool automatically detects the separator, which makes importing fast and convenient.
Create questions manually when needed
Use the manual form to enter questions one by one. Change the Type dropdown to MC, T/F, or SA and the form adapts automatically. For multiple choice questions, add your options and the Correct Answer dropdown updates on its own.
Set up your quiz settings
Fill in the quiz details such as quiz name, pass mark percentage, timer duration, and question order. These settings help you tailor the quiz for classroom tests, practice sessions, or training assessments.
Generate and review the question bank
Click Generate Quiz and your full question bank appears on screen. Each question is shown with colour-coded badges for the question type, and the correct answer is highlighted clearly inside each card for quick verification.
Play the quiz live
Click Play Quiz to start the live scored session. Participants can answer using keyboard shortcuts or mouse input, making it practical for both projected classroom sessions and self-paced use.
Check results and review answers
After the quiz, review the results screen to see performance instantly. Click Review Answers to inspect every question with a full correct and wrong breakdown, which helps with learning, feedback, and discussion.
Export or start a new quiz
Use the export options that fit your needs: Kahoot CSV for Kahoot import, Print PDF for a printable paper version, or Excel for a results file. When you are ready for another session, click New Quiz to reset everything and begin again.
Best Workflow for Teachers
A practical classroom-ready process to go from spreadsheet to live quiz and printable output with a single file.
Build your question bank in Excel using the downloadable template.
Upload the file and click Generate Quiz to prepare the full question set.
Run it as a live classroom quiz while projecting your screen for students.
Export as Kahoot CSV and import it into Kahoot for a gamified version.
Export the PDF for students who need a physical copy, all from the same file.
Who Is This Tool For?
Who Uses It | Their Problem | How ExcelGuru Solves It |
Teachers / tutors | Question bank is already in Excel — re-entering it into Kahoot or Google Forms takes hours | Upload the spreadsheet, get a live quiz in 30 seconds |
Corporate trainers / HR | Compliance Q&A, onboarding assessments, product knowledge tests are in Excel — LMS costs $300/month | Free scored quiz from existing data, Excel results export for reporting |
Students (self-testing) | They have vocabulary lists, formula sheets, definition tables — want to test themselves | Paste or upload, get timed quiz, see what they got wrong instantly |
Exam prep candidates | MCAT, CPA, CFA, CompTIA practice questions are in structured spreadsheet format | Shuffle mode + answer review + multiple attempts |
Content marketers | Want an engaging lead-gen quiz — have the questions in a spreadsheet | Build quiz, export Kahoot CSV for live events or embed the HTML |
School department heads | Need to distribute the same quiz to multiple teachers without accounts | Share the template file — anyone can upload and run it |
Three Ways to Add Your Questions
Unlike every other quiz tool that forces one specific input format, the ExcelGuru generator gives you three entry paths — covering every possible workflow.
1. Upload Excel, CSV, or TSV
Drag and drop or browse for any .xlsx, .xls, .csv, or .tsv file. SheetJS reads the entire file client-side — nothing is transmitted to any server. Files with hundreds of rows parse in under a second. The tool auto-detects the separator for CSV files (tab, comma, or semicolon) so you do not need to pre-convert.
The expected column format is: Column A = Question text, Column B = Type (MC/TF/SA), Column C = Correct answer, Columns D–H = Options A through E (for multiple choice), Column I = Category (optional).
Not sure of the format? Click “Download Template” below the upload zone to get a pre-filled Excel or CSV template with 11 example questions spanning multiple choice, true/false, and short answer types — across Geography, Biology, Science, Math, History, and Technology.
2. Paste from Excel or Google Sheets
Select your columns in Excel or Google Sheets, press Ctrl+C, click the Paste tab, and press Ctrl+V. The tool detects your separator automatically and parses the data without any intermediate export step. This is the fastest path for anyone working in Google Sheets who wants to skip the download entirely.
3. Type Manually
Add questions one row at a time using the structured manual entry form. Each row has a question field, a type selector (MC / T/F / SA), a correct answer field that adapts to the type, and option fields A–D. When you select True/False, the option fields disappear and the correct answer dropdown automatically shows True or False. When you type options for a multiple choice question, the correct answer dropdown refreshes instantly with the options you entered so you can click to select rather than retype.
💡 Smart correct answer dropdown Every other manual quiz builder makes you type the correct answer in a separate field and hope it matches your option text exactly. ExcelGuru’s manual entry form links the two — as you type Option A, B, C, and D, the Correct Answer dropdown updates in real time so you just click the right one. Zero typo risk. |
Question Types — Multiple Choice, True/False, and Short Answer
The Type column in your spreadsheet controls what kind of question is generated. The tool accepts several natural variations so you do not need to memorise exact syntax:
- Multiple Choice (MC, MULTIPLE, M) — Question + up to 5 answer options from columns D–H + one correct answer
- True / False (TF, TRUE/FALSE, T/F, TRUEFALSE) — Question + correct answer of True or False (also accepts Yes/No, 1/0, T/F)
- Short Answer (SA, SHORT, S, OPEN) — Question + exact correct answer — checked case-insensitively during the quiz
Each question type renders differently in both the question bank preview and the live quiz mode, with clear visual badges and distinct interaction patterns.
Live Quiz Mode — Every Feature Explained
Click “Play Quiz” and the tool switches to a full-screen immersive quiz experience. The page header, navigation, and question bank are hidden — the entire screen becomes the quiz. Here is every feature inside the live mode:
Progress bar and score tracker
A green progress bar at the top fills as you advance through questions. Your running score (correct answers / questions answered so far) displays in the top bar so you can see your performance in real time, not just at the end.
Per-question countdown timer
Set the timer from 15 seconds to 2 minutes in the Quiz Settings before generating. The timer displays in the top-right of the quiz screen, turns amber when 10 seconds remain, and turns red when 5 seconds remain. If it hits zero, the question is automatically marked as “timed out”, the correct answer is revealed, and the quiz advances. The timer can also be turned off entirely for self-paced use.
Answer options rendering
Multiple choice questions display A/B/C/D buttons. Click any option to highlight it as your selection. True/False questions show two large buttons side by side. Short answer questions show a text input field — press Enter to submit. At no point does any question show a blank text input when options are available.
Submit, Skip, and Next
Three navigation buttons manage question flow: Submit Answer checks your response and shows feedback; Skip records the question as skipped without penalty and advances; Next Question appears after submitting or after a timeout, to advance to the next question. The Skip button disappears after you submit an answer so it cannot be used to retroactively avoid a wrong answer.
Instant feedback
When “Show feedback immediately” is toggled on (the default), submitting an answer immediately reveals whether you were correct. For multiple choice, the correct option turns green and your wrong selection (if any) turns red. A feedback bar below the options shows the verdict and the correct answer text. This toggle can be turned off for exam simulation where no feedback is given during the quiz.
Keyboard shortcuts
Press 1, 2, 3, 4 to select multiple choice options A, B, C, D without touching the mouse. Press T or F to select True or False. Press Enter to submit the current answer. Press → to skip. Press Esc to exit at any point. For short answer questions, press Enter in the text field to submit.
Results screen
After the last question, a results screen shows a score ring with your percentage, a pass/fail verdict based on your configured pass mark threshold, and a four-column breakdown of correct, wrong, skipped, and percentage. You can then:
- Try Again — reshuffles the same question set and restarts from question 1
- Review Answers — shows every question with your answer, the correct answer, and a colour-coded correct/wrong/skipped badge
- Back to Quiz — returns to the question bank without losing your last results
Quiz Settings — Customize Before You Start
The settings panel between Step 1 and Generate Quiz gives you six controls:
- Quiz Name — appears in the question bank header, PDF export, and Excel filename
- Pass Mark % — sets the threshold for the pass/fail verdict on the results screen (default 70%)
- Timer per Question — off, or 15s / 20s / 30s / 45s / 60s / 90s / 120s — applies to every question
- Question Order — Original (as uploaded) or Shuffle (random) — shuffle applies to both the question bank preview and the live quiz
- Skip header row — toggle on if your first spreadsheet row contains column names rather than a question
- Show feedback immediately — toggle off to hide correct/wrong feedback until the end — useful for formal assessments
Export Options — Kahoot CSV, PDF, and Excel
Kahoot CSV Export
Clicking Kahoot CSV opens a modal with the complete CSV text ready to copy. Paste it directly into Kahoot Creator → Import to load your questions into a Kahoot game. The format includes the question text, four answer options, time limit per question (pulled from your timer setting, defaulting to 20 seconds), and the correct answer number — exactly what Kahoot expects. Multiple choice and true/false questions are both supported in the Kahoot export. Short answer questions are excluded since Kahoot does not support that type.
Print PDF
The PDF export opens a modal with complete HTML of your quiz — ready to copy into a text editor, save as .html, open in a browser, and print with Ctrl+P. The printable format includes every question with options, an answer key section at the bottom, question type labels, category tags, and the quiz name and date. Ideal for teachers who need physical quiz papers for a classroom setting.
Excel Export
The Excel export produces a .xlsx file via SheetJS with two sheets:
- Questions sheet — all questions with columns for question text, type, correct answer, options A–D, and category
- Results sheet — only present if you played the quiz — shows every question, your answer, the correct answer, and Correct/Wrong/Skipped status, plus a score summary row at the bottom
This makes the tool genuinely useful for trainers and HR teams: distribute the quiz file, collect completed results exports, and consolidate them without needing any platform subscription.
How ExcelGuru Compares to Every Alternative
| Feature | ExcelGuru | ProProfs | Faabul | Kahoot | Quizizz | Google Forms |
| Upload real .xlsx directly | Yes — free, unlimited | Yes (8 Q free) | Yes (account req) | CSV only | No | No |
| Paste from clipboard/Sheets | Yes | No | No | No | No | No |
| Manual entry with smart form | Yes | Yes | Yes | Manual only | Yes | Yes |
| Multiple choice questions | Yes | Yes | Yes | Yes | Yes | Yes |
| True / False questions | Yes | Yes | Yes | Yes | Yes | Yes |
| Short answer questions | Yes | Yes | No | No | Yes | Yes |
| Question timer | Yes — per-question | Yes | No | Yes | Yes | No |
| Scored live quiz mode | Yes | Yes | No | Yes (group) | Yes | Yes |
| Instant feedback per Q | Yes | Yes | No | Yes | Yes | No |
| Pass mark threshold | Yes | Yes | No | No | No | No |
| Skip question option | Yes | No | No | No | No | N/A |
| Full answer review | Yes | Yes | No | No | Yes | Yes |
| Kahoot CSV export | Yes | No | No | N/A | No | No |
| PDF / print export | Yes | Paid | No | No | No | Yes |
| Excel results export | Yes | Paid | No | No | No | CSV only |
| No account required | Yes | No | No | No | No | Google acct |
| Data stays in browser | Yes | No | No | No | No | No |
| Free tier limit | Unlimited | 8 Q | Account | 10 players | Limited | Unlimited |
📊 Market context
The AI Quiz Generator market was valued at $375 million in 2025 and is growing at 26.7% annually, projected to reach $4 billion by 2035. Despite this growth, there is still no free, browser-based, no-signup tool that takes a real Excel file and produces a live scored quiz with a timer. ExcelGuru fills that gap completely.
Privacy and Performance
The tool is a single HTML file — approximately 80 KB. Every calculation, file parse, and quiz session runs entirely in the browser. No data is transmitted to any server at any point. This makes it suitable for:
- Confidential HR and compliance training materials — sensitive Q&A stays on the user’s device
- School assessments with student data — no GDPR/FERPA concerns since nothing is collected
- Proprietary corporate knowledge bases — question banks do not leave the organisation
Because the tool has no server component, there are no rate limits, no maintenance windows, and no scalability concerns. One teacher using it and ten thousand students using it simultaneously produce identical performance — each session is isolated in its own browser tab.