For trainers, teachers, and anyone with a glossary in a spreadsheet

Excel to Quiz: Convert Excel to Quiz Questions From Any Spreadsheet

Export the sheet to PDF, upload it here, and get a quiz with a matching answer key written from your own rows and columns. One export step, then the same workflow as any other document.

Works with Excel, Google Sheets, Numbers, and CSV once exported to PDF. Files are deleted automatically.

Upload your exported sheet and generate the quiz

Click to upload or drag and drop

PDF, DOCX, PPTX, TXT, JPG, JPEG, PNG, HEIC, ODP, ODT, BMP, or TIFF

up to 20MB

Please wait, your quiz is being created...

Uploading...

The short answer

To convert Excel to a quiz, export the sheet to PDF first and upload that. PDFQuiz reads PDF, Word, PowerPoint, text, and images rather than .xlsx directly, and the export step is worth doing anyway: it locks in the layout you see on screen, so a term in column A stays next to its definition in column B. The one thing that ruins the result is a sheet wider than the page, because the overflow columns get pushed to a later page and the pairing breaks. Set the print area to fit one page wide, export, upload, and you get a numbered quiz plus a separate answer key.

Last updated July 2026.

How to export the sheet so the questions come out right

Almost every bad result from a spreadsheet traces back to the export, not to the questions. These are the settings that matter, in each of the four apps people actually use.

App	Path to PDF	The setting that matters
Excel for Windows	File, Export, Create PDF/XPS	Page Layout, Scale to Fit, set Width to 1 page. Leave Height on Automatic so long sheets simply run to more pages.
Excel for Mac	File, Save As, format PDF	Same Scale to Fit width of 1. Also switch to landscape once you pass roughly six columns of text.
Google Sheets	File, Download, PDF document	In the export panel set Scale to Fit to width, and turn on Repeat frozen rows so the header row prints on every page.
A raw CSV file	Open it in Excel or Sheets first, then export	Widen the columns before exporting. A CSV opened cold usually shows truncated cells, and truncated text exports truncated.

A quick check before uploading: open the PDF and confirm that row 1 and its last column are on the same page. If they are not, go back and fix the scale.

Which spreadsheets make good quizzes, and which do not

A quiz needs a fact and something to say about it. Spreadsheets that store prose in cells work beautifully. Spreadsheets that store calculations do not, because there is nothing to build a question stem out of.

Sheet type	Result	Why
Glossary: term, definition, example	Excellent	Every row is already a question and an answer. The other rows supply believable wrong options, which is the hard part of writing multiple choice.
Product catalog: model, spec, price tier	Excellent	Ideal for sales onboarding. Questions compare models against each other, which is exactly what a rep has to do on a call.
Compliance matrix: rule, owner, deadline	Very good	Produces who and by when questions, which are the ones that matter operationally and the ones people actually get wrong.
Vocabulary or language list	Very good	Straight recall pairs. Works better as flashcards than as a graded test if the list runs past about fifty rows.
Financial model driven by formulas	Poor	The PDF captures the computed numbers, not the logic. Questions come out as arithmetic trivia about cell values nobody needs to memorize.
Pivot table or dashboard	Poor	Aggregated output with almost no prose. Quiz the source document the dashboard summarizes instead.
Transaction or log export	Poor	Thousands of near identical rows. There is no teachable content, only records.

From spreadsheet to graded quiz in four steps

Trim the sheet

Delete helper columns, notes to self, and anything you would not want a question written about. Keep the header row: it tells the generator what each column means.

Export to PDF, one page wide

Set Scale to Fit width to 1 page, go landscape if you have many columns, and export. Open the PDF once to confirm nothing got cut.

Upload and choose the format

Multiple choice for graded tests, short answer where you want recall, true or false for a quick check. Set the question count to roughly one per meaningful row.

Review, then download both files

Scan for questions that give the answer away because a neighboring row is too similar. Then take the quiz and the answer key as separate documents.

Who does this

Sales enablement

The product matrix already lives in a sheet. Turning it into a weekly product knowledge check is a ten minute job, and it surfaces the specs reps consistently get wrong.

Teachers with a term list

Most vocabulary and key terms lists are already typed into a sheet somewhere. Two versions of the same quiz from the same file takes one extra click.

Ops and compliance teams

A control matrix of rules, owners, and deadlines converts cleanly into a comprehension check you can attach to the training file.

Certification study groups

Shared term sheets are the standard study artifact. Generating practice questions from one beats reading it top to bottom for the fifth time.

Restaurant and retail training

Menu specs, allergen tables, and SKU lists are spreadsheet native. A short quiz per section fits a shift briefing.

Anyone rebuilding a lost quiz

If you have the answer key in a sheet but lost the original test, exporting and regenerating is faster than retyping it.

Questions people ask about turning Excel into a quiz

Can you convert an Excel file to a quiz?

Yes, with one export step in between. PDFQuiz reads PDF, Word, PowerPoint, text, and image files rather than .xlsx directly, so in Excel you go to File, Save As or Export, and pick PDF. Upload that PDF and the questions are written from the content of your rows and columns. The export takes about fifteen seconds and it also fixes the formatting problems that raw spreadsheet parsing usually creates.

How do I turn a spreadsheet into quiz questions?

Set the print area so every column fits the page width, export to PDF, then upload the PDF and choose your question count and format. The single most common failure is a sheet that is wider than one page, because Excel silently pushes the overflow columns onto later pages and the relationship between a term and its definition is lost. Fit to one page wide before you export.

What kind of spreadsheet makes a good quiz?

Anything where a row is a fact and the columns explain it: a glossary of terms and definitions, a product catalog with specs, a compliance matrix of rules and owners, a country and capital list, a drug and dosage table. Sheets built from formulas, pivot tables, or raw numeric transaction logs make poor quizzes because there is no prose to build a question stem from.

How do you make a quiz in Excel itself?

You can, using data validation dropdowns for the answer options and an IF formula to score them, but it takes a long time and the file is easy to cheat by unhiding the answer column. It is worth doing only when your recipients must work entirely offline inside Excel. For anything you plan to share or grade, generating a quiz and an answer key as two separate documents is faster and holds up better.

Can I convert an Excel file to Quizlet?

Quizlet imports plain text rather than an .xlsx file. Copy two columns out of your sheet, paste them into Quizlet's import box, and set the term and definition separator to Tab and the card separator to New Line, which is exactly what a two column copy from Excel produces. If what you want is questions rather than flashcards, generate the quiz from the exported PDF first.

Does this work with Google Sheets?

Yes, and the path is shorter. In Google Sheets choose File, Download, PDF document, then in the export panel set Scale to Fit to width and page orientation to landscape if you have more than about six columns. Upload the resulting PDF. The same one page wide rule applies, because the export dialog will happily split a wide sheet across pages.

How many questions can you get from one spreadsheet?

Roughly one solid question per meaningful row, up to the point where the questions start repeating the same pattern. A 40 row glossary comfortably yields 20 to 30 varied questions. Beyond about 60 rows of the same structure, split the sheet by topic and generate a separate quiz per section, which also gives you a reusable question bank instead of one long test.

Turn the sheet you already maintain into a quiz

Export to PDF, upload, review the draft. The glossary you have been updating for two years is a question bank you have not used yet.

Upload your exported sheet