How to Import Questions Into Microsoft Forms (Quick Import)

How do you import questions into Microsoft Forms?

Microsoft Forms imports questions through a feature called Quick Import, which converts a Word or PDF form or quiz into a Microsoft Forms one. Open Forms, choose Quick Import, upload the document, and Forms reads the questions out of it. It handles titles and subtitles, multiple choice questions, and open text questions. The file has to be under 10MB and has to come from a local drive rather than SharePoint Online or OneDrive for Business, and the feature is not available in US Government Clouds. What it does not bring across is the answer key and the point values, so a quiz still needs a setup pass in Forms after the questions land.

That last sentence is the part most guides skip, and it is the part that decides how long this takes. Everything below is the detail: the layout that converts cleanly, what you fix afterward, and the honest answer on Excel.

What Quick Import actually does

It is a document converter, not a spreadsheet importer. You point it at a quiz that already exists as a Word file or a PDF, and it pulls the structure out and rebuilds it as Forms questions. That covers a real and common situation: a department has a printed test, a scanned paper quiz, or a Word doc a colleague wrote three years ago, and somebody has been asked to put it online.

After the conversion Forms does not just dump you into the editor. It shows suggested feedback in three categories so you know where to look:

• Missing content. Something in the original document did not make it into the form.
• Uncertain conversion result. Forms converted it with low confidence and wants you to check.
• Unsupported question type. Only multiple choice and open text are supported, so anything else needs rebuilding by hand.

Work through those three lists before you touch anything else. They are ordered roughly by how much damage an unnoticed problem causes, and a quiz that ships with a missing option is worse than one that never imported.

Get the document layout right first

A conversion that comes back covered in warnings is usually a layout problem, not a Forms problem. Microsoft's own guidance is to arrange content vertically in line with the title and the section title, and to make sure questions and answer options are clearly separated.

In practice that means the plainest possible document:

• Number the questions. A clear 1. 2. 3. down the page tells the converter where one question ends and the next begins.
• Letter the options. A. B. C. D. on their own lines, one option per line.
• Skip the layout tricks. Two column pages, text boxes, options laid out in a table, and answers running inline after the stem all confuse the reader. Vertical and boring converts best.
• Keep the answer key separate. If your document prints the correct answers, put them in their own section at the end rather than beside each question, or the key text can end up imported as if it were a question.

If you are producing the document yourself rather than converting an inherited one, build it in that shape from the start. It costs nothing and saves the review pass.

What comes across and what you set yourself

Part of the quiz	Survives Quick Import	How you set it in Forms
Question text	Yes	Read it once, fix any wording that drifted
Multiple choice options	Yes	Check none went missing
Open text questions	Yes	Nothing
Correct answer key	No	Select the Correct Answer check mark next to the right option
Points per question	No	Add a number in the Points text box
Feedback on an option	No	Select the Message icon next to that answer
Other question types	No	Rebuild by hand, they are flagged as unsupported

None of the missing pieces are hard. They are a check mark, a number, and optionally a sentence. But they are per question, so a forty question import is a couple of hundred small interactions. Budget for it, and have the answer key open beside you rather than in your head.

Can you import questions from Excel into Microsoft Forms?

Not directly. Quick Import reads Word and PDF, not Excel or CSV, so a spreadsheet of questions has no native path into Forms. The usual workaround is to get the spreadsheet into a document first: paste the questions into Word in the numbered and lettered layout above, save as Word or PDF, then run Quick Import on that.

People reach for Excel here for a reason worth naming. Typing questions into a spreadsheet is faster than typing them into any form editor, so the spreadsheet becomes a staging area for work the editor makes painful. That is a real workaround, and the conversion step is a workaround for the workaround. If the quiz does not exist yet at all, it is usually better to generate it in a format the destination already accepts than to build a spreadsheet you will have to reshape twice. The same logic applies on the Google side, where the native import is even more limited and needs an add-on or a script, which we cover in how to import questions into Google Forms from a CSV.

How do you create a Microsoft Forms quiz with answers?

Whether the questions arrived by import or you typed them, marking the answers is the same short loop. Select the Correct Answer check mark next to the correct answer or answers, then add a number in the Points text box to assign a point value. If you want a respondent to see something specific when they choose a particular option, select the Message icon next to that answer and write it, and they will see the message when they have selected that answer.

That per option message is the most underused field in Forms. On a question people reliably get wrong, a one line explanation of why the tempting option is wrong does more for retention than the score does. It costs one sentence per question and it turns a test into something that teaches.

Can Microsoft Forms grade quizzes automatically?

Yes, for questions with a defined correct answer. Forms automatically calculates the points earned on multiple choice questions once the key is marked, so thirty people submit and the scores are already there when you open the results. You can still open an individual response and edit the score to award partial or extra credit, which is what you want when a question turns out to be ambiguous and you would rather fix it for everyone than argue it one by one.

Open text answers are the exception. There is no key to compare against, so somebody has to read them. This matters when you plan a quiz: every open text question you add is marking work you have signed up for, and on a large cohort that is the difference between a quiz that runs itself and one that eats an afternoon.

What is the difference between a form and a quiz in Microsoft Forms?

A quiz is a form with scoring switched on. Both collect responses the same way and offer the same question types. The quiz adds three things: you can mark which option is correct, you can attach points to each question, and the respondent can be shown a score. A plain form has no answer key, no points, and nothing to grade.

Pick by what happens after submission. If you need to know who got it right, build a quiz. If you are collecting opinions, signups, or survey answers, use a form, because points would only add noise to data that has no right answer.

When the questions do not exist yet

Everything above assumes a quiz already exists somewhere and the job is moving it. Often that is not the situation. The material is a recorded training session, a Teams town hall, a lecture capture, or a product walkthrough, and somebody needs a knowledge check on it by Friday. There is no Word doc to convert. There is a two hour recording and a blank Forms editor.

That is the case where generating the questions first changes the shape of the work. Our Microsoft Forms quiz generator reads the recording and drafts multiple choice questions with the correct answer marked, a one line explanation, and a timestamp back to the moment each question tests. It exports a PDF laid out for Quick Import: questions numbered, options lettered, answer key printed as its own section at the end. Upload that PDF, work through the conversion warnings, then use the printed key to tick answers and set points.

The timestamps earn their keep later. When somebody disputes a question, or asks where in a ninety minute session a point was covered, you jump straight to it instead of scrubbing. If your quizzes need to end up somewhere other than Forms, the same set exports as a QTI package for your LMS or a Google Forms ready CSV, so the recording gets read once and the output format is a decision you make afterward.

The honest caveat: these are drafts generated from your own recording, not a guarantee. Read the set before it counts toward anyone's record. It is review instead of authorship, which is a much smaller job, but it is not zero.

Common problems and what they mean

• Half the questions came in as one long question. The numbering was inconsistent or missing, so the converter could not find the boundaries. Renumber and reconvert.
• Options appear inside the question text. The options were on the same line as the stem, or laid out in a table. Put each on its own line.
• Questions imported, no scores possible. Expected behavior. The key never travels, so mark it in Forms.
• Quick Import is not in my Forms. It is unavailable in US Government Clouds and some tenants restrict it. Check with whoever administers your Microsoft 365 tenant before assuming it is broken.
• Upload rejected. Either the file is over 10MB, or you selected it from SharePoint or OneDrive rather than a local drive. Download it locally and retry.
• Answer key text became its own questions. The key was printed next to each question rather than in a separate section, so the converter treated it as content.

Does Forms scale past a single quiz?

Forms is a good place to run a quiz and a thin place to run a program. It does not track who completed which module, it does not chase people who have not finished, and it does not produce a record that survives an audit two years later. Teams usually discover this the week someone asks for proof that everyone was trained on a policy. At that point the quiz wants to sit inside a training program with completion tracking rather than exist as a link in an email thread.

The same limit shows up in hiring. Plenty of teams use a Forms quiz as a first pass on candidates, which works right up to the volume where reading the responses becomes the bottleneck, and by then most of the signal you wanted was in the conversation rather than the multiple choice. Teams at that point tend to move to automated first round screening interviews and keep the Forms quiz for the narrower factual checks it is genuinely good at.

For a class quiz, a knowledge check after a training video, or a quick comprehension test on a recorded session, Forms plus a clean import is more than enough.

The short version

Microsoft Forms imports questions with Quick Import, which converts Word or PDF documents and supports titles, multiple choice, and open text. Keep the document vertical, number the questions, letter the options, and keep any answer key in its own section. Under 10MB, from a local drive, and not in US Government Clouds. The question text and options come across; the answer key, the points, and per option feedback do not, so plan a setup pass where you tick the Correct Answer check mark and type a point value on each question. Excel has no direct route, so stage it through Word. And if the quiz has not been written yet and the source is a recording, generating the questions in a Quick Import friendly layout skips both the writing and the reshaping.